DBMS: Syllabus & Model Paper

 Syllabus

UNIT I

Overview of Database Management System: Introduction to data, information, database, database management systems, file-based system, Drawbacks of file-Based System, database approach, Classification of Database Management Systems, advantages of database approach, Various Data Models, Components of Database Management System, three schema architecture of data base, costs and risks of database approach. 

UNIT II

Entity-Relationship Model: Introduction, the building blocks of an entity relationship diagram, classification of entity sets, attribute classification, relationship degree, relationship classification, enhanced entity-relationship model(EER model), generalization and specialization, advantages of ER modelling. 

UNIT III

Relational Model: Introduction, CODD Rules, relational data model, concept of key, relational integrity, relational algebra, relational algebra operations, relational calculus, tuple relational calculus, domain relational Calculus (DRC), Normal forms up to BCNF. 

UNIT IV

Structured Query Language: Introduction, History of SQL Standard, Commands in SQL, Data Types in SQL, Data Definition Language, Selection Operation, Projection Operation, Aggregate functions, Data Manipulation Language, Table Modification Commands, Join Operations, Set Operations, Views, Sub Query. 

UNIT V

PL/SQL: Introduction to PL/SQL, Structure of PL/SQL, Data Types, Operators Precedence, Control Structure, Steps to Create a PL/SQL, Program, Iterative Control, Procedure, Function, Database Triggers, Types of Triggers, Cursors, Types of Cursors, Exception handling.

BOOKS:

1.Database System Concepts by Abraham Silberschatz, Henry Korth, and S. Sudarshan, McGrawhill

2.Database Management Systems by Raghu Ramakrishnan, McGrawhill

3.Principles of Database Systems by J. D. Ullman

4.Fundamentals of Database Systems by R. Elmasri and S. Navathe

5.SQL: The Ultimate Beginners Guide by Steve Tale.

MODEL PAPER, 

DATABASE MANAGEMENT SYSTEMS 

Section – A

Answer the following 4 questions.   Each question carries 10 marks.         5 X 10 = 50M

1. (a)    What is Database Management System? Compare and Contrast File Management System with Database Management System.      [co1]

Or

    (b)      Explain different types of data models.           [co1]

2. (a)      What is ER-Model? Frame ER Diagram with suitable example.   [co2]

Or

    (b)      Explain Relational Set Operators with examples.    [co2]

3. (a)       Explain Codd rules.                                                 [co3]

Or

    (b)      Explain types of Normalization with an example.   [co3]

4. (a)       Explain DDL and DML Commands and create a database. [co4]

Or

    (b)      Explain Join Operations with example.     [co4]

5. (a) Discuss different control structures in PL/SQL with example.  [co5]

                                                               or

    (b)What is Exceptional Handling? Explain different types with examples. [co5]

 Section – B

Answer any five questions. Each carry 3 marks                        5 X 3 = 15 M

 6. Describe the architecture of DBMS.             [co1]

 7. Write about Levels of Data Abstraction.       [co1]

 8. Define derived attribute with an example.    [co2]   

 9. Explain Relational Calculus and its types.    [co2]

10. Explain Integrity Constraints with an example.       [co3]

11. Explain about Aggregate Functions with example.  [co4]

12. Explain different types of clauses with example.     [co4]

13. Explain different types of Triggers in PL/SQL.       [co5]

 Section – C

Answer all Questions                                                                        5 X 2 = 10M

14. Give differences between Data and Information.          [co1]

15. What is an Entity and list different types of entities.     [co2]

16. Write a short note on DBA.                                            [co3]

17. Define a View with syntax?                                            [co4]

18. What is a Cursor?                                                            [co5]