Can you help me with a Database design homework problem
Part A:
Purpose:
This exercise involves normalizing a small part of a DB. The steps to complete this exercise include getting the data items into 1NF, 2NF, and 3NF. The final step is to generate the ERD for the table or tables that are in the dependency diagram in 3NF.
Discussion:
Some small business wants to keep track of office furniture, computers, printers, etc. A sample of the ITEM records is shown below:
ATTRIBUTE NAME | SAMPLE VALUE | SAMPLE VALUE | SAMPLE VALUE |
ITEM_ID | D1342245 | D1453356 | D1365779 |
ITEM_DESCRIPTION | IQ Deskjet 683P | IQ Toner | DT Photocopier |
ROOM_NUMBER | 227 | 227 | 342 |
BLDG_CODE | SC | SC | ET |
BLDG_NAME | Science | Science | Electronics Technology |
BLDG_MANAGER | A. B. Jones | A. B. Jones | R. S. Smith |
- Draw the dependency diagram using the data in the table. Make sure to label the transitive and partial dependencies.
- Using the dependency diagram developed in step 1, create a set of dependency diagrams that meet 3rd Normal Form requirements. Rename attributes to meet the naming conventions. Create new entities and attributes as necessary.
- Draw the crow’s foot ERD with the VISIO drawing tool using the results of step 2.
10 years ago
20
Answer(0)
Bids(0)