Using The Table Structure Shown In Table P6 4 Do The Following Computer Science Homework Help

Question Description

Using the table structure shown in Table P6.4, do the following:

1.Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive dependencies.

2.Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest extent possible. If you believe that practical considerations dictate using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.

3.Draw the Crow’s Foot ERD.

-15-

---

Buy plagiarism free, original and professional custom paper online now at a cheaper price. Submit your order proudly with us