please answer the following questions

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) What normal form is this table above?

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)).

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.

FIGURE 6.3 FIRST NORMAL FORM (1NF) DEPENDENCY DIAGRAM PROJ NUM PROJ NAME EMP NUM EMP NAME JOB CLASS CHG HOUR HOURS Partial dependency Transitive dependency Partial dependencies 1NF (PROJ NUM, EMP NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS) PARTIAL DEPENDENCIES: (PROJ_NUM PROJ_NAME EMP NAME,JOB-CLASS, CHG-HOUR) TRANSITIVE DEPENDENCY: JOB CLASSCHG HOUR)