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.