Databases Reference
In-Depth Information
17. Describe the role of database administration in
database design and explain why that role makes
sense.
18. What is metadata?
19. What is a data dictionary?
20. Explain in your own words why a data dictionary
in a relational DBMS environment would have a
''Tables table.''
21. What is the difference between an active and a
passive data dictionary?
22. List some typical data dictionary entities.
23. List some typical uses of the data dictionary.
24. How does a relational catalog differ from a general-
purpose data dictionary? What is its role in the
relational DBMS environment?
25. How does a data repository differ from a general-
purpose data dictionary?
EXERCISES
1. You have just been named Director of Data
Administration of General Hardware Co. General
Hardware maintains a large central IS organization
with several operational relational databases at
its headquarters. It also has databases on several
local-area network servers, some located at its
headquarters and some in regional offices. Of
course, there are many relational databases on
individual employees' PCs, too. Certain data is sent
from the central databases to the LAN databases
nightly.
You have been given a free hand to create
a data administration department and supporting
database administration departments for General
Hardware and its IS environment. Design your data
and database administration functions. Include their
responsibilities and explain how they will add value
to the corporation.
2. Good Reading Bookstores Database.
a. Create a data dictionary TABLES table and an
ATTRIBUTES table and enter data in them for
Good Reading Bookstores database shown in
Figure 7.21. Your answer should be based on the
format shown in Figure 10.6. Use your judgment
as to attribute type values, length values, etc.
b. Create a relationships table for this tables and
attributes data, using the format in Figure 10.7.
3. Best Airlines Mechanics Database.
a. Create a data dictionary TABLES table and an
ATTRIBUTES table and enter data in them for
Best Airlines' mechanics database, shown in
Exercise 8.5. Your answer should be based on the
format shown in Figure 10.6. Use your judgment
as to attribute type values, length values, etc.
b. Create a relationships table for this tables and
attributes data, using the format in Figure 10.7.
MINICASES
1.
Happy Cruise Lines.
a. You have just been named Director of Data Admin-
istration of Happy Cruise Lines. Happy Cruise Lines
maintains a central IS organization with several oper-
ational relational databases on several large servers
at its headquarters. Each of its cruise ships has a
medium-scale server on board with its own databases
that help manage the running of the ship. Real-time
transmissions are made via satellite between head-
quarters and the ships that keep both the headquarters
and shipboard databases constantly up to date.
You have been given a free hand to create a data
administration department and supporting database
administration departments for Happy Cruise Lines
and its IS environment. Design your data and
database administration functions. Include their
responsibilities and explain how they will add value
to the corporation.
b. Create a data dictionary TABLES table and an
ATTRIBUTES table and enter data in them for Happy
Cruise Lines' database, shown in Minicase 5.1. Your
answer should be based on the format shown in
Figure 10.6. Use your judgment as to attribute type
values, length values, etc.
c. Create
a
relationships
table
for
this
tables
and
attributes data, using the format in Figure 10.7.
Search WWH ::
Custom Search