4th Sem: DBMS - Syllabus

 

 

 SEMESTER IV

CORE THEORY PAPER – 4

DATABASE MANAGEMENT SYSTEM (BCS41)

UNIT - I Database Basics

Introduction: Flat File – Database System – Database – Actionable for DBA. The Entity – Relationship Model: Introduction – The Entity Relationship Model. Data Models: Introduction – Relational Approach – The Hierarchical Approach – The Network Approach.

UNIT – II Relational Algebra

Structure of Relational Databases – Fundamental Relational Algebra Operations –Additional Relational Algebra Opearations - Extended Relational Algebra Operations - Null Values - Modification of the Database - The Tuple Relational Calculus – The Domain Relational Calculus

UNIT – III Normalization

Normalization: Introduction - Normalization – Definition of Functional Dependence (FD) – Normal Forms: 1NF, 2NF, 3NF and BCNF.

 

UNIT – IV Structured Query Language

Structured Query Language: Features of SQL – Select SQL Operations – Grouping the Output of the Query – Querying from Multiple Tables – Retrieval Using Set operators – Nested Queries. T-SQL – Triggers and Dynamic Execution: Transact-SQL..

UNIT – V Procedural Language

Procedural Language- SQL: PL/SQL Block Structure – PL/SQL Tables. Cursor Management and Advanced PL/SQL: Opening and Closing a Cursor – Processing Explicit Cursor – Implicit Cursor – Exception Handlers – Sub Programs in PL/SQL – Functions – Precaution While Using PL/SQL Functions – Stored Procedure – Object Oriented Technology.

Text Book

1. Rajesh Narang, “Database Management Systems”, PHI Learning Private Limited, New Delhi, sixth printing, 2010.

Reference

1. S.K. Singh, “Database Systems – Concepts, Design and Appplications”, Dorling Kindersley (India) Pvt. Ltd., Second Impression, 2008

2. Database System Concepts , Abraham Silberchatz, Henry F Korth , S.Sudarshan, McGraw-Hill - 5th Edition - 2006.

 

 

core practical [practical – Iv]

RDBMS LAB (BPCS45)

 

1. Table creation and simple Queries

2. Queries using Aggregate Function and Set Operations

3. Table creation with various Joins

4. Nested Sub queries and correlated Sub queries

5. View creation and manipulation

6. PL/SQL program for cursor

7. PL/SQL program for packages

8. PL/SQL program for triggers and its type

9. PL/SQL program for procedures and functions