Database Management System (DBMS) — Winter 2022

Explain Database Management System (DBMS) architecture with proper diagram.

Explain Relational Model, Network Model and Hierarchical Model with neat diagram and suitable example.

Explain Codd’s 12 Rules in detail.

Explain different types of Relationships. With suitable E-R Diagram and Example.

Specify E-R Symbols and their use.

Which are the Components of Database? Explain Any Five of your Choice Which are the Components of Database?

Discuss the characteristics of Data in Database Management System.

Define Data integrity. Discuss various integrity constraints of DBMS.

Discuss the concept of foreign key and primary keys in DBMS with suitable example.

What is Normalization? Explain 1NF, 2NFwith suitable example(s).

Draw E-R Diagram for the situation given below: Auniversity consists of a number of departments. Each department offers several courses. Anumber of modules make up each course. Students enrol in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students.

Explain with Diagrams: A. Conceptual Data Model B. Logical Data Model C. Physical Data Model

Discuss advantages of using DBMS against the File Management System.

Describe GRANT and REVOKE commands.

Define SQL. Discuss various types of languages available in SQL.

Discuss the functions of SQL- ROLLBACK, COMMIT, SAVEPOINT.

What is SQL? What are Various Features of SQL?