DB - Normalization Question # 1 Patient Medication Form Patient Number: P10034 Full name: Elbert McDonald Ward Number: Ward 11 Bed Number: B4 Ward Name: Orthopaedic Drug Number Name Description Dosage Method of Admin Unit per Day Start Date Finish Date 10223 10334 10223 Morphine Tetracyclene Morphine Pain Killer Antibiotic Pain Killer 10mg/ml 0.5mg/ml 10mg/ml Oral IV Oral 50 10 10 24/03/04 24/03/04 25/04/05 24/04/05 17/04/04 02/05/06
DB - Normalization
Question # 1
Patient Medication Form
Patient Number: P10034
Full name: Elbert McDonald Ward Number: Ward 11
Bed Number: B4 Ward Name: Orthopaedic
Drug Number |
Name |
Description |
Dosage |
Method of Admin |
Unit per Day |
Start Date |
Finish Date |
10223 10334 10223 |
Morphine Tetracyclene Morphine |
Pain Killer Antibiotic Pain Killer |
10mg/ml 0.5mg/ml 10mg/ml |
Oral IV Oral |
50 10 10 |
24/03/04 24/03/04 25/04/05 |
24/04/05 17/04/04 02/05/06 |
Examine the Patient Medication Form above:
- Put the above form into a relation schema
- Identify the functional dependencies.
- Describe and illustrate the process of normalization to produce 3NF relations.
Question#2:
Given the following Theatre
No.of seats:500 |
Owner: J.Martin |
||||
Year Founded: 1890 |
Owner’s Phone: 2347756 |
||||
- |
- |
- | - | - | |
Play Name |
Play Type |
No. of performances |
Play Author name |
Play Author nationality |
|
MacBeth |
Tragedy |
35 |
W.shakesper |
English |
|
Ulysses |
Drama |
12 |
J.Joyce |
Irish |
|
Represent the above as an unnormalized relational schema then apply the rules of normalization to normalize it to 3NF.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps