Database Management System (DBMS) — Winter 2019

Discuss the characteristics of Data in Database Management System.

Describe in detail various components of Database Management System.

Discuss in brief Data Dictionary. Describe various types of users of DBMS.

Define Data Abstraction. Differentiate between logical and physical data interdependence.

Discuss advantages of using DBMS against the File Management System.

Define Entity. Discuss various types of entity with suitable example.

Discuss various forms of relationships in database in detail.

Discuss various models of database with appropriate examples.

Discuss various symbols used to draw E-Rdiagram with explanation.

Discuss Codd’s rules for Database Management System.

Define Data integrity. Discuss various integrity constraints of DBMS.

Discuss the process of Normalization and explain BCNF with example.

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

Discuss the functions of SQL- ROLLBACK, COMMIT, SAVEPOINT

Define Views. Discuss the benefits of generating views in DBMS.

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

Discuss the role of Data Warehouse for online retailer.