ECET 450: Laboratory 2
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
1. Draw the dependency diagram using the data in the table. Make sure to label the transitive and partial dependencies.
2. 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.
3. Draw the crow’s foot ERD with the VISIO drawing tool using the results of step 2.
