Database Systems

Running head: DATABASE SYSTEMS
Database Systems
Name of the Student
Name of the University
Author’s Note

1
DATABASE SYSTEMS
Table of Contents
Introduction..........................................................................................................................2
Dependency Diagram..........................................................................................................2
3NF......................................................................................................................................3
ERD.....................................................................................................................................4
Conclusion...........................................................................................................................5
Bibliography........................................................................................................................6

2
DATABASE SYSTEMS
Introduction
The data base normalization is a technique that is used for designing the tables in such a
manner that there is no redundancy in the data that is inputted in the tables. The normalization is
applied for reducing the redundancy in data and identification of the relationship between the
data. The report is prepared for explaining the dependency and decomposition of the Sample
Item Records into a set of 3NF.
Dependency Diagram
The following table is in original state of “Sample Item Records”.
Table 1: Sample Item Records
ITEM_I
D
ITEM_LAB
EL
ROOM_NUMB
ER
BLDG_CO
DE
BLDG_NA
ME
BLDG_MANA
GER
231134-
678
HP Deskjet
895Cse
325 NTC Nottoclear I.B. Rightonit
342254-
225
HP Toner 325 NTC Nottoclear I.B. Rightonit
254668-
449
DT Scanner 123 CSF Canseefar May B. Next
The following dependency diagram is created from the above table and here the building code
(BLDG_CODE) is not considered as a determinant of Room Number and since the building may
have many rooms and the building code would not be sufficient to know the room.