DBMS Assignment #1

Writing Exercises(Elsmari and Navathe, 2013)

1. Define in maximum of two lines:
   • Data
   • Database
   • DBMS
   • Database system
   • Database catalog
   • Program-data independence
   • User view
   • DBA
   • End User
   • Canned Transaction
   • Deductive Database Systems
   • Persistent Objects
   • Meta-Data
   • Transaction Processing Applications
2. What do you mean by self-describing nature of the database?
3. What are the responsibilities of a DBA and database designer?
4. What are the functions of a DBMS?
5. Discuss the differences between database systems and information retrieval systems.
6. Explain the difference between two-tier and three-tier architectures. Which is better suited for web applications? Why?
7. What are the advantages and limitations of Network Data Model and Hierarchical Data Model?

References

• Elsmari, R. and Navathe, S. (2013). Database Systems -Models, Languages, Design and Application Programming. 1st ed. New Delhi: Dorling Kindersley(India) Pvt. Ltd., pp.1-27.