F / 45 / 00 FORMAT
Question Paper Format
Name of College: Polytechnic / Engineering / D. Pharmacy / B. Pharmacy Date: DD/MM/YYYY
Name of
Civil / Computer / Electrical / E&TC / Mechanical / Pharmacy/ Other
Department:
Academic Year: 2025-26 Class: 1st / 2nd / 3rd / 4th Semester: Odd/ Even
Database Management
Name of Subject: Marks: 30 Time: Hrs
System
Instructions:
1. All questions are compulsory.
2. Illustrate your answers with neat sketches where ever necessary.
3. Figures to the right indicate full marks.
4. Assume suitable data if necessary.
5. Preferably, write the answers in sequential order.
Q.1 Attempt any Three of the following. (5 Marks Each) 3X5=15 CO
a) What is DBMS ?Enlist the characteristics of DBMS. Explain Advantage of DBMS CO1
over file system.
b) Explain Data Abstraction and Data Independence. CO1
c) Construct ER Diagram For Library Management System. CO1
d) Draw and Explain Overall structure of database system. CO1
Q.2 Attempt any Three of the following. (5 Marks Each) 3X5=15
a) Explain any four Codd’s rules. CO2
b) Define Normalization. Explain three normal forms with example CO2
c) Explain Entity integrity constraint with example CO2
d) Write note on Multivalued Dependancy CO2
:-All The Best:-