Using the Employee table below, write the rational schema and drawit's dependency diagram. Identify all dependencies. EMP_NO EMP_NAME CUST_NO CUST_NAME CUST_PHONE PROD_NO PROD_NAME DATE 215 SPHELELE 15 HUGUETTE 0834528787 10 SOAP 20/03/2012 216 BOKHOSI 16 TANDIWE 0784521635 12 BRAID 20/03/2012 217 THEMBA 16 TANDIWE 0784521635 15 PHONE 21/04/2012 218 LEFA 14 BUSISIWE 0618578542 12 PEN 22/04/2012 219 VALENTINE 14 BUSISIWE 0618578542 13 LAPTOP 22/04/2012 220 PROMISE 18 GIRLY 0829687841 13 LAPTOP 22/04/2012

4.1 Identify all dependencies.                   (8)

4.2 Using the Employee table above, write the rational schema and draw it's dependency diagram.                          (9)

4.3 Create an database whose table(s) is at least in 3rd normal form, showing the dependency diagram and the rational schema for each table.   (8)