PVKN - III B.Sc(V-Sem)
III B.Sc., SEMESTER –V
DATABASE MANAGEMENT SYSTEMS
Subject Code: 21-CSC-501
- Course outcomes and Syllabus: click here
- Model Paper: click here
- Lab List of Programs: click here
e-content
UNIT-I
OVERVIEW OF DBMS
Data and information, Database, DBMS, Structure of
DBMS, Objectives of DBMS: click here
Assignment Questions: click here
-------------------------------------------------------------------------------
Evolution of DBMS: click here
Assignment Questions: click here
-------------------------------------------------------------------------------
Classification of DBMS, file-based system,
Drawbacks of file-Based System: click here
Assignment Questions: click here
------------------------------------------------------------------------------
DBMS Approach, advantages of DBMS, Ansi/spark Data Model, Data models: click here
Assignment Questions: click here
-------------------------------------------------------------------------------
Components and Interfaces of DBMS: click here
Assignment Questions: click here
--------------------------------------------------------------------------------
Database Architecture, Situations where DBMS is not Necessary, DBMS
Vendors and Their Products: click here
Assignment Questions: click here
UNIT-II
Structured Query Language
History of SQL Standard, Commands in SQL, Data Types in SQL: click here
Assignment Questions: click here
----------------------------------------------------------------------------------
Data Definition Language, Data Manipulation Language, Data Control
Language, Transaction Control Language: click here
Assignment Questions: click here
-------------------------------------------------------------------------------
Aggregate Functions: click here
-----------------------------------------------------------------------------------
Imposition of Constraints: click here
-----------------------------------------------------------------------------------
Join Operation: click here
-----------------------------------------------------------------------------------
Set Operation: click here
-----------------------------------------------------------------------------------
View, Sub Query: click here
-----------------------------------------------------------------------------------
UNIT-III
PL/SQL
Shortcomings of SQL, Structure of PL/SQL:
click here
-------------------------------------------------------------------------------
PL/SQL Language elements: click here
-----------------------------------------------------------------------------------
Control Structures: click here
-----------------------------------------------------------------------------------
Cursors: click here
-----------------------------------------------------------------------------------
Procedures and Functions: click here
-----------------------------------------------------------------------------------
Packages and Exceptions: click here
-----------------------------------------------------------------------------------
Database Triggers: click here
-----------------------------------------------------------------------------------
UNIT-IV
Entity-Relationship Model
ER Model Introduction: click here
-------------------------------------------------------------------------------
Relationship degree,classification,ER to RelModel etc: click here
-------------------------------------------------------------------------------
EER Model: click here
-------------------------------------------------------------------------------
UNIT-IV
Relational Model
Codd Rules: click here
-------------------------------------------------------------------------------
Relational Model: click here
-------------------------------------------------------------------------------
Relational Algebra: click here
-------------------------------------------------------------------------------
Database Design: click here
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
🍒🍒~ Advertisement ~🍒🍒
Want to Learn Cooking
in a simple way?????
👍👍LIKE #### SHARE #### SUBSCRIBE👍👍
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sir please Send the important questions for Sem end exam
ReplyDelete