Example: bankruptcy
HW#1 Solution
STUDENT, DEPARTMENT, COURSE, SECTION, and GRADES as shown below, where the primary keys are underlined. The COURSE, SECTION, and GRADES relations are in 3NF and BCNF if no other dependencies exist. The STUDENT and ... YX ->Y (using IR1 (reflexivity), knowing that Y subset-of YX) (5) WX ->Y (using IR3 (transitivity) on (3) and (4)) (b) Proof: (1 ...
Download HW#1 Solution
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: