Question

To keep track of office furniture, computers, printers, and so on, the CSU DIT uses the table structure shown in Table 1.

Please note that BLDG stands for building.

Table 1 Sample ITEM Records

Attribute Name	Sample Value	Sample Value	Sample Value
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

a. Given that information, draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. 5 Marks

b. Modify the dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. 5 Marks

c. Draw the Crow’s Foot ERD.    5 Marks

Please rename attributes to meet the naming conventions and create new entities in part B

I have posted the question 2 times but did't get the correct answer yet. Please help.

Answer 1

here i have tried to show the dependencies possible . where item_id is the key attribute

now i am splitting it into 3NF:

now crow foot representation is: