Answer the following questions. Make sure you answer all parts of each question. What is the candidate
Fantastic news! We've Found the answer you've been seeking!
Question:
Answer the following questions. Make sure you answer all parts of each question.
- What is the candidate key (or keys) of the relation, as it currently exists? What normal form is the relation in? Explain your reasoning.
- Explain the problems with the existing design, in terms of the potential modification anomalies that it might exhibit.
- Convert the relation to a set of relations in at least Third Normal Form (3NF). You only need to show the schema, not the data. Do not make any new attributes: work with the ones in the table. Give each of your new relations an appropriate name. Show all primary keys and foreign keys.
- Explain how your new design addresses the problems you identified in (b). Also demonstrate that your set of relations has the dependency-preserving and lossless join properties.
Related Book For
Financial and Managerial Accounting
ISBN: 978-1133940593
10th edition
Authors: Belverd E. Needles, Marian Powers, Susan V. Crosson
Posted Date: