Project 1

Examine the Patient Medication Form for the Wellmeadows Hospital shown below.
  1. Identify the functional dependencies represented by the data shown in the form.
  2. Describe and illustrate the process of normalizing the data shown to 1NF, 2NF, 3NF, and BCNF.
  3. Identify the primary key and foreign keys in your BCNF relations.
  4. State any assumption you make about the data shown in this table.
Wellmeadows Hospital
Patient Medication Form
Patient Number:  P10034 
Full Name:  Robert MacDonald  Ward Number:  Ward 11 
Bed Number:  64  Ward Name:  Orthopaedic 
Drug Number Name Description Dosage Method of Admin Units per Day Start Date Finish Date
10223 Morphine Pain Killer 10mg/ml Oral 50 03/24/01 04/24/02
10334 Tetracyclene Antibiotic 0.5mg/ml IV 10 03/24/01 04/17/01
10223 Morphine Pain Killer 10mg/ml Oral 50 04/25/01 05/02/03


Due date: Tuesday February 5, 2002 11:59pm
The solution should be typed and sent to me.