1. A well-maintained relational DBMS has a high level of data integrity. What features of a relational DBMS contribute towards this level of integrity? 2. (a) Explain the various functions of RDBMS? Name the different categories of RDBMS users and how they are different from each other. (b) RDBMS has become most popular Database System world wide? Justify your answer with suitable example. 3. Explain different integrity constrains supported by RDBMS and ORDBMS with suitable examples. 4. Process of normalization is the integral part of designing a database. Justify this statement with suitable database design. 5. Differentiate among on any three of the following giving suitable examples:- a) Primary Key b) Candidate Key c) Alternate Key d) Unique Key e) Super Key Data Base management System Assignment B Marks 10 Answer all questions. 1. Write SQL statements to create a table from existing table. What are the advantages of creating a table from existing table? 2. What do you mean by 'view'? What are its different types? Differentiate between updatable and non updatable 'view' with suitable examples. Also give proper syntax for creating 'view'. 3. Explain the difference between the Drop & Delete, Commit & Rollback and Alter & Update with suitable examples. 4. Read the case study given below and answer the question given at the end.