DBMS Using Mysql — DU B. Voc – Web Designing Previous Year Question Papers

7. (a) Explain file indexing and different indexing techniques used in DBMS. 7 (b) Discuss concurrency control and recovery mechanisms in transaction processing. 8 (NEP UGCF) Parts of a question must be answered together. 1. (a) Explain the characteristics of the database approach. 5 (b) Differentiate between file system approach and DBMS approach. 5 (c) Define entity, attribute, and relationship with suitable examples. 5 (d) What are integrity constraints in the relational data model? 5 (e) Explain the purpose of DDL and DML commands in SQL. 5 (f) What are ACID properties in transaction processing? 5 2. (a) Explain the three-schema architecture of DBMS with suitable diagrams. 7 (b) Discuss data independence and its types in 3. (a) Explain the components and notation used in Entity Relationship (ER) diagrams. 7 (b) Discuss different types of relationships and constraints in ER modeling. 8 4. (a) Explain the relational data model and schema-instance distinction. 7 (b) Discuss relational algebra operators with suitable examples. 8 5. (a) Explain the SQL commands used to create databases and tables with examples. 7 (b) Discuss aggregation functions, GROUP BY clause, and HAVING clause in SQL with examples. 8 6. (a) Explain functional dependencies and their role in database normalization. 7 (b) Discuss INF, 2NF, 3NF, and BCNF with suitable examples. 8