In Progress

Converting ERD diagrams to data structure diagrams

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.


Skills: Anything Goes, Data Processing, Database Administration, MySQL, SQL

See more: erd structure, use data structures, use data structure, use diagrams, types data structures, types data structure, two types data structures, tables data structure, structures data, primary data, parts database example, one key data, no structure, need data structure, list data structures, list data structure, linked list data structures, key data structure, different types data structures, different types data structure, different data structures, data structure types

About the Employer:
( 7 reviews ) Orlando, United States

Project ID: #2585466

Awarded to:


Hi, I have experience with this project, I happily if work with you in this project. Regards

$35 USD in 1 day
(8 Reviews)

3 freelancers are bidding on average $33 for this job


Hi, kindly check your inbox for my inquiries. Thanks.

$35 USD in 0 days
(21 Reviews)

Dear Sir, i accept your project. and done well.

$30 USD in 1 day
(0 Reviews)