Question: Given the info below can you draw or design the relational data schemes and data dependency diagrams for all tables in MS Visio? Start out

Given the info below can you draw or design the relational data schemes and data dependency diagrams for all tables in MS Visio? Start out with listing all data attributes in 1NF, then label partial dependencies and potential transitive dependencies. Break down all partial dependencies into their own entities (tables) normalizing to 2NF. Then break down any transitive dependencies into their respective entities, normalizing to 3NF. Lastly, create an ER diagram of your tables in 3NF. Include all minimum and maximum cardinalities with the crow's feet notation.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!