Unit1.doc

7UNIT1 1) 2) 3) 4) 5)

What is data independence? Describe the three schema architecture. Explain the working& architecture of database management system with exp.? What re the advantages and disadvantages of relational database models? What is DBMS and what are its functions? Explain: i) Data dictionary ii) Meta Data. iii) Database manager. 6) Diffrentiate: i) Single valued and multi valued. ii) Logical and physical data independency. iii) Strong and week entity set. 7) What are functions of DBA? 8) Draw an E-R Diagram of university by determining entities of interest nad relationships that exists between these entities? 9) Explain: i) Specialization ii) Generalization iii) Aggregation. 10) What are the different types of database schemas? 11) Explain various data models? With Example? 12) What are the advantages of DBMS? 13) Explain the difference between 2-tier and 3-tier client server architechture? 14) Construct a E-R Diagram for a hospiotal with set of patients and set of medical doctors?