To keep track of office furniture, computers, printers, and so on, the FOUNDIT Company uses the table structure shown in Table P6.5.

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 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.
c. Draw the Crow’s FootERD.

Transcribed Image Text:

Attribute Name ITEMID ITEM LABEL ROOM NUMBER 325 Sample Value 231134-678 HP DeskJet 895Cse HP Toner Sample Value Sample Value 342245-225 254668-449 INTC İNottooclear 325 NTC Nottoclear 123 CSF Canseefar BLDG CODE BLDG NAME BLDG_MANAGER |I. B. Rightonit L. B. RightonitMay B. Next