To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in the table below. Sample ITEM Records: Primary Key = Item_ID ITEM_QTY ITEM DESC HP DeskJet 895Cse 17 ITEM ID 231134 342245 254668 WHSE_BIN WHSE_CODE WHSE_NAME 325 NTC Nottoclear 642 NTC Nottoclear 123 CSF Canseefar WHSE MANAGER I. B. Rightonit 1. B. Rightonit May B. Next HP Toner 4 DT Scanner 29 a. Given the above table structures provided, write the relation schema in meso provided bmw. b. The table is susceptible to update anomalies. Provide examples of an insertion, deletion, and modification anomaly (one of each). c. Review the table structure and the functional dependency diagram provided. List all Functional Dependencies in the table using the A B notation. d. Analyze the table structure and determine its current state of normalization. Present your rationale and conclusion using the PRECISE methodology demonstrated in the class lecture