Determine all candidate keys of the above table and prove it by using Armstrong Axioms [SCORE: 10]
Fantastic news! We've Found the answer you've been seeking!
Question:
Determine all candidate keys of the above table and prove it by using Armstrong Axioms [SCORE: 10] b. in which normal form (1NF, 2NF, 3NF, or BCNF, which one?) the above table ? [SCORE: 5] c. Do decomposition to normalize that table to become BCNF. [SCORE:5] d. Write an SQL statements to reconstruct the original (the un-normalized) table from the normalized tables. [SCORE: 5]
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Posted Date: