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: what is linked list in data structure, what is linked in, what is data structures, what is data structure, what is data in data structure, what is a linked list in data structures, what is a linked list in data structure, what is a data structures, what is a data structure, what data structure, use of data structures, use of data structure, use diagrams, types of data structures, types of data structure, types data structures, types data structure, two types of data structures, tables in data structure, structures data, primary data, one key data, no structure, need of data structure, list of data structures

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