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 Crows 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.