To keep track of office furniture, computers, printers, and other office equipment, the FOUNDIT Company uses the table structure shown in Table P6.5.
\table[[\table[[ATTRIBUTE NAME],[ITEM_ID]],\table[[SAMPLE VALUE],[231134-678]],SAMPLE VALUE,SAMPLE VALUE],[TTEM LABEL,HP Desklet 895Cse,342245-225,254668-449],[ROOM_NUMBER,,HP Toner,OT Scanner],[BLDG_CODE,\table[[325],[NTC]],325,123],[BLDG_NAME,Nottooclear,NTC,CSF],[BLDG_MANAGER,1. R. Rightonit,Nottooclear,Canseefar],[,,L. B. Rightonit,Mry B. Next]]
A. Given that information, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies.
B. 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.
C. Draw the Crow's Foot ERD.