Example: air traffic controller

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 ...

Tags:

  Section, Reflexivity

Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Other abuse

Advertisement

Related search queries