Chapter 6 Homework Answer the questions below. Note: In drawing the diagrams, use the textbook notation In drawing the diagram, you can use any (diagraming) software, such as Draw.io, Microsoft Visio, LucidChart, or even Microsoft Word. Copy and paste the diagram to Microsoft Word or convert them PDF and Submit the Word file or PDF file o Include diagram ONLY, not entire software screen o Your submission should be readable Put your name on your document Due date: Oct. 21 (Sunday) 11:59PM Eastern Time (Questions) Q1. Order_ID Order_Date Product_ID Product_Desc Unit-Price Quantity OD100 09/08/2000 E34T098 Coffee Table $175.00 2 OD100 09/08/2000 N78S571 Nightstand $150.00 3 OD100 09/08/2000 B66K881 Bookcase $200.00 2 OD213 01/01/2001 B66K881 Bookcase $200.00 1 OD121 12/20/2000 D87D729 Drawer Dresser $225.00 2 OD121 12/20/2000 E34T098 Coffee Table $175.00 3 1) In what normal form is this table? 2) Describe the insertion, update, and deletion anomalies of the table by providing example (that is, the problems occurred when delete, update, insert record(s)). Refer page 209 for the anomalies explained with example. Your answer should be similar to them. 3) Draw its dependency diagram and identify all dependencies. Yours looks like the one in Figure 6.3. Include both diagram (top portion in Figure 6.3) and textual notation (bottom portion in Figure 6.3) for each identified dependency. But you dont have to include relational schema, that is, 1NF (PROJ_NUM, EMP_NUM, PROJ_NAME.). 4) Normalize the table so that there are no more partial and/or transitive dependencies, and draw the new dependency diagrams for the normal form. Yours looks like the one in Figure 6.5. Again include both diagram and textual notation. Q2. Customer_ID Name Salesperson Region 8023 Anderson Smith South 9167 Bancroft Hicks West 7924 Hobbs Smith South 6837 Tucker Hernandez East 8596 Eckersley Hicks West 7018 Arnold Faulb North 1) In what normal form is this table? 2) Draw its dependency diagram and identify all dependencies. Yours looks like the one in Figure 6.3. Again include both diagram and textual notation. 3) Normalize the table so that there are no more partial and/or transitive dependencies, and draw the new dependency diagrams for the normal form. Yours looks like the one in Figure 6.5. Again include both diagram and textual notation.