To keep track of office furniture, computers, printers, and other office equipment, the FOUNDIT company uses the table structure shown in the table below.

Attribute Name

Sample Value

Sample Value

Sample Value

ITEM$\_$ID

$231134-678$

$342245-225$

$254668-449$

ITEM$\_$LABEL

HP DeskJet $895$Cse

HP Toner

DT Scanner

ROOM$\_$NUMBER

$325$

$325$

$123$

BLDG$\_$CODE

NTC

NTC

CSF

BLDG$\_$NAME

Nottooclear

Nottooclear

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 label the transitive and$/$or partial dependencies.

Write the relational schema and create a set of dependency diagrams that meet $3$NF requirements. Rename attributes to meet the naming conventions and create new entities and attributes as necessary.

Draw the Crow$$s Foot ERD.