BCS403 – Database Management System (DBMS) Set-2 Solved Model Question paper with answers
BCS403 – DBMS Model Question Paper – II
Module 1
1.a] What is a Database? Explain the three-schema architecture with a neat diagram.
1.b] What are the advantages of using DBMS approach?
1.c] Explain the following terms: 1. Data Dictionary 2. Weak Entity
OR
2.a] Explain the categories of Data Models.
2.b] Explain the component modules of DBMS & their interactions with diagram.
2.c] What are the responsibilities of DBA & database designers?
Module 2
3.b] Explain Unary relational operations with examples.
3.c] What is an Integrity Constraint? Explain the importance of Referential Integrity Constraint.
OR
4.a] Explain relational algebra operations: JOIN, DIFFERENCE, SELECT, UNION.
4.b] Discuss E.R to Relational mapping algorithm with examples for each step.
4.c] Explain relational algebra operation for set theory with examples.
Module 3
5.a] Illustrate insert, delete, update, alter & drop commands in SQL.
5.b] Explain informal design guidelines for relational schema design.
5.c] What is Functional Dependency? Explain inference rules for functional dependency with proof.
OR
6.a] Check equivalence of F = {A→C, AC→D, E→AD, E→H} and E = {A→CD, E→AH}.
6.b] Explain types of update anomalies in SQL with examples.
Module 4
7.a] Demonstrate transaction states & additional operations.
7.b] Demonstrate working of Assertion & Triggers in databases with an example.
OR
8.a] Demonstrate the System Log in database transaction.
8.b] Discuss ACID properties of database transaction.
8.c] Explain stored procedure language in SQL with an example.
Module 5
9.a] Explain the Two Phase Locking Protocol used for concurrency control.
9.b] Define Schedule. Illustrate with an example.
9.c] Why is Concurrency control needed? Demonstrate with an example.
OR
10.a] What is NoSQL? Explain the CAP theorem.
10.b] What are document-based NoSQL systems? Explain basic CRUD operations in MongoDB.
10.c] What is NoSQL Graph database? Explain Neo4j.