22 Feb 2021
the description included in the word document which you will need to follow the steps to complete the work. The requirement included in the word document is as following:
- Create a representation of the above in table format
- Draw a complete dependency diagram identifying the dependencies between the attributes (remember that this means you have to figure out what the primary key attributes are)
- Identify the reasons why this set of data is not in 3NF. After identifying the primarky attributes, what NF is the data in?
- Including all intermediate stages (this means show how you got to 3NF), organize the attributes into a set of 3NF relations
- Draw an ER Diagram based on the normalized relations
please see the word document for more important details.