Tildelt

Converting ERD diagrams to data structure diagrams - Repost

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.

Thanks

Færdigheder: Databehandling, Database Administration, MySQL, SQL

Se mere: 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, 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, data structures using, data structures types, data structures list, data structures example, data structure list

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt-ID: #5990216

1 freelancer byder i gennemsnit $15 for dette job

it2051229

Hired by the Employer

$15 USD på 1 dag
(174 bedømmelser)
6.1