Database Management Systems, Normalization

Anonymous
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