I. To keep track of office furniture, computers, printers, and so on, the FOUNDIT compan uses the spreadsheet shown in below. Sample ITEM Records Attribute Name ITEM ID ITEM LABEL ROOM NUMBER 325 BLDG CODE BLDG NAME BLDG MANAGER I. B. Rig Sample Value 231134-678 HP Sample Value 342245-225 Sample Value 254668-449 DT Scanner 123 CSF 895Cse HP Toner 325 NTC NTC Mav B. Next Given that information, write the relational schema to show this as a relation in First Normal Form. Take note of transitive and/or partial dependencies. a. ITEMC ITEM_ID, ITEM_DESCRIPTION, BLDG ROOM, BLDG CODE, BLDG_NAME, BLDG _MANAGER) b. What steps need to be taken to convert the relation to Second Normal Form? Write the relational schema for the relation in Second Normal Form. Write the relational schemas that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. Assume that one employee manages each building c