Assignment1_CO1.docx.pdf

GOVERNMENT POLYTECHNIC FOR GIRLS, AHMEDABAD Department of Information Technology Course: Database Management (4331603) UNIT 1 Introduction to Database Systems Date of Allotting Assignment: 30/07/2024 Date of...

GOVERNMENT POLYTECHNIC FOR GIRLS, AHMEDABAD Department of Information Technology Course: Database Management (4331603) UNIT 1 Introduction to Database Systems Date of Allotting Assignment: 30/07/2024 Date of Submission: 05/08/2024 This assignment covers following CO: CO1: Explain the basic concepts of databases. Sr Questions Marks R/U/A NO 1. What is database? Explain the purpose of DBMS in detail. 7 U 2. List applications of DBMS. 3 R 3. Define Database and Database Management System 2 R 4. Write a short note on: Disadvantage of file oriented system. OR 4 U Share your Views as on what difficulties will we face if there are no Database Management System 5. Differentiate between file oriented system and database system. 7 U 6. Explain the advantages of database system over file oriented 4 U systems. 7. Who is DBA? Describe the responsibility of DBA in detail. 7 U 8. Differentiate DA and DBA 3 U 9. Define: Metadata, System Catalog. 2 R 10. Write a short note on data dictionary. 3 R 11. Give the difference between Active Data Dictionary and Passive 3 U data dictionary. 12. Explain three level architecture of DBMS. 4 U 13. Explain Schema, sub-schema and Instances. 3 U 14. Differentiate: Database schema v/s database instance. 2 U 15. Write a short note on: Data Independence. 4 U 16. List out the types of data models. Explain any two with example 7 R&U