The Multiple Sclerosis (MS) Center, headed by Dr. Z, has been using a spreadsheet to keep track
Question:
The Multiple Sclerosis (MS) Center, headed by Dr. “Z,” has been using a spreadsheet to keep track of information that patients provide upon signing in for a clinic visit. One of the staff members thought it would be better to use a relational database for recording this information and imported the spreadsheet as a table into a Microsoft Access database (MVCH Figure 4-5).
a. What would you suggest as the primary key for this table?
b. Is this table a relation? Why or why not?
c. Can you identify any problems with this table structure? Are there any insertion, deletion, or update anomalies?
d. Diagram the functional dependencies for this table.
e. Using the normalization steps described in this chapter, develop a set of 3NF relations.
f. Using a tool such as Microsoft Visio, draw the relational schema, clearly indicating referential integrity constraints.
g. Write CREATE TABLE commands for all relations in your schema. Make reasonable assumptions concerning the data type for each attribute in each of the relations.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi