Discuss the below:
Q1. To keep track of office furniture, computers, printers, and so on. the FOUNDIT company uses the table structure shown here.
|
|
|
|
|
|
ITEM ID
|
231134-678
|
342245-225
|
254668-449
|
|
ITEM LABEL
|
HP DeskJet 895Cse
|
HP Toner
|
DT Scanner
|
|
ROOM NUMBER
|
325
|
325
|
123
|
|
BLDG CODE
|
NTC
|
NTC
|
CSF
|
|
BLDG NAME
|
Nottooclear
|
Nottoclear
|
Canseefar
|
|
BLDG_MANAGER
|
I. B. Rightonit
|
I. B. Rightonit
|
May B. Next
|
Given that information, write the relational schema and draw the dependency diagram. Make sure that you labe the transitive and/or partial dependencies.
Q2. Using the answer to Q1, write the relational schema and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions and create new entities and attributes as necessary.
Q3. Using the results of Q2, draw the Crow s Foot ERD.