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.

Order ID Order Date 09/08/2000 09/08/2000 09/08/2000 01/01/2001 12/20/2000 12/20/2000 Product ID E34T098 N78S571 B66K881 B66K881 D87D729 E34T098 Product Desc Coffee Table Nightstand Unit-Price antit OD100 OD100 OD100 OD213 OD121 OD121 Drawer Dresser Coffee Table 175.00 l) 2) In what normal form is this table? occurred when delete, update, insert record(s)). Draw its dependency diagram and identify all dependencies. Describe the insertion, update, and deletion anomalies of the table by providing example (that is, the problems Refer page 209 for the anomalies explained with example. Your answer should be similar to them. Yours looks like the one in Figure 6.3. Include both diagram (top portion in Figure 6.3) and textual . 3) . notation (bottom portion in Figure 6.3) for each identified dependency. But you don't have to include relational schema, that is, INF (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 formm. . Yours looks like the one in Figure 6.5. Again include both diagram and textual notation. Customer ID 8023 9167 7924 6837 8596 7018 Name Anderson Bancroft Hobbs T uckcr Eckersle Arnold Sales Smith Hicks Smith Hernandez Hicks Faulb Region South West South East West 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 formm. Yours looks like the one in Figure 6.5. Again include both diagram and textual notation