Database Management Systems, Normalization

timer Asked: Nov 9th, 2016

Question description

Help with completing this assignment,

Figure 13.18 [1] Examine the Patient Medication Form for the Wellmeadows Hospital. (a) Identify all the candidate keys. (b) Decide a primary key. (c) Identify (all) the functional dependencies represented by the attributes shown in the form in Figure 13.18. State any assumptions you make about the data and the attributes shown in this form. (d) Describe and illustrate the process of normalizing the attributes shown above Figure to produce a set of well-designed 3NF relations (1st normal form, 2nd normal form, and 3rd normal form). 1st Normal Form: Definition: Normal For: 2nd Normal Form: Definition: Normal Form: 3rd Normal Form: Definition: Normal Form [client/Property view] Table clientNo fName lName propertyNo viewDate comment CR56 Aline Stewart PA14 5/24/2001 too small CR56 Aline Stewart PG36 4/28/2001 street 16 Holhead 2 Manor Rd CR56 Aline Stewart PG4 5/26/2001 6 Lawrence St Glasgow CR62 CR74 Mary Mike Tiregear PA14 Richie PG4 5/14/2001 no dining room 16 Holhead Aberdeen 4/21/2001 6 Lawrence St Glasgow CR76 John Kay 4/20/2001 too remote PG4 6 Lawrence St Glasgow Street and city represent a property’s address. [2] Please find out the primary key from above table. [3] Please identify all the functional dependencies in minimum set. [4] Please convert above table to the second normal form. [5] Please convert [4] to the third normal form city Aberdeen Glasgow

Tutor Answer

(Top Tutor) Studypool Tutor
School: Cornell University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors