ECET 450: Laboratory 2 Part A: 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. 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.

In this laboratory exercise, we are tasked with normalizing a small part of a database, specifically the ITEM records of a small business that wants to keep track of office furniture, computers, printers, etc. The goal is to bring the data items into 1NF, 2NF, and 3NF and then generate an Entity-Relationship Diagram (ERD) for the resulting normalized tables.

To begin, let’s examine the provided sample values for the ITEM records:

ATTRIBUTE NAME SAMPLE VALUE 1 SAMPLE VALUE 2 SAMPLE VALUE 3
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. Dependency Diagram:
The first step is to draw the dependency diagram for the given data. The dependency diagram represents the relationships between the attributes and identifies any transitive or partial dependencies. From the provided sample values, we can observe the following dependencies:

– ITEM_ID determines ITEM_DESCRIPTION, ROOM_NUMBER, BLDG_CODE, BLDG_NAME, and BLDG_MANAGER.
– There are no observed transitive or partial dependencies in this case.

2. 3NF Dependency Diagrams:
Using the dependency diagram developed in step 1, we need to create a set of dependency diagrams that meet the requirements of 3rd Normal Form (3NF). In 3NF, all attributes are determined solely by the key, the whole key, and nothing but the key. To achieve this, we may need to rename attributes, create new entities, and introduce additional attributes as necessary.

3. Crow’s Foot ERD:
Finally, we need to draw the crow’s foot ERD using the VISIO drawing tool, incorporating the results of step 2. The crow’s foot ERD is a graphical representation of the entities, relationships, and attributes in a database system.

Overall, this laboratory exercise involves data normalization and the creation of an ERD to represent the relationships between the normalized tables. By following the outlined steps, we will be able to achieve a well-organized and efficient database structure for the small business’s inventory tracking system.