BCS403 – DBMS Set-1 Solved Model Question paper with answers

BCS403 – Database Management System (DBMS) Set-1 Solved Model Question paper with answers

---

BCS403 – DBMS Model Question Paper – I

Module 1

1.a] Explain the types of end users with examples.

1.b] What are the advantages of using DBMS?

1.c] Describe the characteristics of database.

OR

2.a] Explain three schema architecture. Why mappings between schema levels are required?

2.b] Explain the different types of attributes in ER model.

2.c] Explain the following: 1. Cardinality Ratio 2. Weak Entity

---

Module 2

3.a] Explain the different Relational Model constraints.

3.b] Demonstrate the concepts of Generalization & Specialization with examples.

3.c] Explain Entity Integrity Constraint & Referential Integrity Constraints. Why is each important in a database?

OR

4.a] Write SQL queries for Sailors-Boats-Reserves database:
 1. Find colors of boats reserved by Alber.
 2. Sailor IDs with rating ≥ 8 or who reserved boat 103.
 3. Sailor names who didn’t reserve boat containing “storm”.
 4. Sailor IDs over age 20 who didn’t reserve boats with “thunder”.

4.b] Discuss Equijoin & Natural Join with examples.

4.c] Explain relational algebra operation for set theory with examples.

---

Module 3

5.a] Explain Cursor and its properties in embedded SQL with an example.

5.b] What is Normalization? Explain 1NF, 2NF & 3NF with examples.

5.c] Explain informal design guidelines for relational schema design.

OR

6.a] What is Functional Dependency? Write algorithm to find minimal cover and apply it on:
  F = {B→A, D→A, AB→D}

6.b] Explain types of update anomalies in SQL with an example.

---

Module 4

7.a] Demonstrate the Database Transaction with transaction diagram.

7.b] Demonstrate working of Assertion & Triggers in SQL with an example.

OR

8.a] Demonstrate the System Log in database transaction.

8.b] Demonstrate the ACID properties of database transaction.

8.c] Explain stored procedure language in SQL with an example.

---

Module 5

9.a] Demonstrate Two Phase Locking Protocol used for concurrency control.

9.b] Demonstrate Concurrency control based on Timestamp ordering.

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.