Exercises
2.12 Analyze the DBMSs that you are currently using. Determine each system’s compliance with the functions that
we would expect to be provided by a DBMS. What type of language does each system provide? What type
of architecture does each DBMS use? Check the accessibility and extensibility of the system catalog. Is it
possible to export the system catalog to another system?
2.13 Write a program that stores names and telephone numbers in a database. Write another program that stores
names and addresses in a database. Modify the programs to use external, conceptual, and internal schemas.
What are the advantages and disadvantages of this modification?
2.14 Write a program that stores names and dates of birth in a database. Extend the program so that it stores the
format of the data in the database: in other words, create a system catalog. Provide an interface that makes this
system catalog accessible to external users.
2.15 How would you modify your program in Exercise 2.13 to conform to a client–server architecture? What would
be the advantages and disadvantages of this modification?