Microsoft Office Tutorials and References
In Depth Information
20. Consider the following table:
Patient (PatientID, PatientName, BalanceOwed, DoctorID, DoctorName, ServiceCode,
ServiceDesc, ServiceFee, ServiceDate)
This is a table concerning data about patients of doctors at a clinic and the services the
doctors perform for their patients. The following dependencies exist in the Patient table:
PatientID, DoctorID, ServiceCode
DoctorName, ServiceDesc, ServiceFee, ServiceDate
a. Based on the dependencies, convert the Patient table to first normal form.
b. Next, convert the Patient table to third normal form.
21. Suppose you need to track data for mountain climbing expeditions. Each member of
an expedition is called a climber, and one of the climbers is named to lead an expe-
dition. Climbers can be members of many expeditions over time. The climbers in
each expedition attempt to ascend one or more peaks by scaling one of the many
faces of the peaks. The data you need to track includes the name of the expedition,
the leader of the expedition, and comments about the expedition; the first name, last
name, nationality, birth date, death date, and comments about each climber; the
name, location, height, and comments about each peak; the name and comments
about each face of a peak; comments about each climber for each expedition; and
the highest height reached and the date for each ascent attempt by a climber on a
face with commentary.
a. Create the tables for the expedition database and describe them using the alterna-
tive method. Be sure the tables are in third normal form.
b. Draw an entity-relationship diagram for the expedition database.
22. What is the difference among natural, artificial, and surrogate keys?
23. Why should you use naming conventions for the identifiers in a database?
Ending Data Files
There are no ending Data Files needed for this appendix.