Database
management system
(DBMS)
Model Question Solution bsc csit
 |
| csit notes DBMS model question solution |
Section A (Long questions)
Attempt any two questions. (2 × 10 = 20)
1. Consider the following database and write SQL as given:
Customer (Cno, Cname, Caddress, Ccontact)
Purchase (Cno,Pid)
Product (Pid, Pname, price, quantity) (5 × 2 = 10)
a. Find the names of all products having price 1000.
b. Find the name of those customers who purchased Dell Laptop.
c. Find the total number of products purchased by customer ‘Ram’
d. Increase price of all products by 5 %
e. Find total price of Apple Mobiles
2. What are the benefits of using normalization? Discuss 1NF, 2NF, and 3NF with suitable example. (2.5 + 7.5 = 10)
3. Define Relational Algebra (RA) and explain its six fundamental operations with suitable example. (2 + 8 = 10)
Section B (Short questions)
Attempt any eight questions. (8 × 5 = 40)
4. What database schema? What are functions of database administrator? (2 +3 = 5)
5. Construct an E-R diagram for online course registration where students register courses online.(5)
6. Discuss referential integrity with example. (5)
7. What is functional dependency? Why do we need inference rules? (2 + 3 = 5)
8. Why do we need concurrency control? Discuss two phase locking protocol. (2 + 3 = 5)
9. Why do we need database recovery? Discuss shadow paging technique for database recovery. (2 + 3 = 5)
10. Differentiate concept of Centralized and Client/Server Architectures for DBMSs with suitable example. (5)
11. Define Transaction and explain its desirable properties. (5)
12. Explain constraints and characteristics of Specialization and Generalization of data model. (5)
