Converting ERD diagrams to data structure diagrams.
Using the ERD attached, create the data structures for this ERD. Deal with the entities that have multivalued attributes, deal with the relationships on ERD (Convert many to many relationships to associative entities), (resolve the one to one relationships), (redefine the relationship as one to many or many to many). Each entity becomes a relationship. Create a data structure for each entity that will identify the name of the entity, its identifier and any other attributes. Resolve any relationships with foreign keys or associative entities. Break down any composite attributes into individual attributes. Normalize all tables to 3NF.
Your project is to complete one Logical Data Structure form for each Data Structure in your business for the project. (I choose my business to be an electronic store, feel free to be a little creative) (Submit your forms as separate Word document attachments) below is the master form, make as many copies of the form as you need. (Use SAVE AS and name them Data Structure Form1, Data Structure Form2, and so on for as many as you need.)
* Data Structure Form
Instructions for Completing Your Data Structure Forms:
1. Identify each Data Structure in your business. (Example: you're running a trucking company. One Data Structure would be all the details about one driver including the types of trucks this driver is qualified to drive.) Remember to use the 3rd Normal Form!
2. For each Data Structure in your business, complete a copy of the Data Structure form (linked below). Depending on your business, you could have one or two or more forms. The form provides spaces for you to list the primary key along with other fields, assumptions, and business rules related to each Data Structure.
I have also attached a sample that will help you visualize what is required in the different parts of the form.