Sandip Institute of Technology and Research Centre, Nashik
(An Autonomous Institute Permanently Affiliated to
Savitribai Phule Pune University, Pune)
Academic Year: 2024 - 2025 Semester: I
Assignment No.: 01 Units Covered: 01
Course: Advanced DBMS Course Code: 2423502
Instructions:
• All questions are compulsory.
• Attach data sheet/property table/standard charts etc. in support of reference wherever
necessary
• Assume suitable data wherever necessary and mention it clearly.
• Clarity in the answers and neatness is highly desirable.
Q.
Questions BTL CO
NO.
1. Distinguish between File Systems and DBMS. L1 CO1
2. Write a short note on Database Languages. L2 CO1
3. What are integrity constraints and how to enforce them in database. L2 CO2
4. What are Database Models ? Explain. L2 CO2
What are views in database ? How to create and update them ? what its CO1
5. L1
uses.
6. What are primary data type structures in OORDBMS ? Explain. L4 CO2