QUESTIONS FOUR (25 MARKS] Using the Employee table below, write the rational schema and draw it's dependency diagram. Id

[answerhappygod]

Questions Four 25 Marks Using The Employee Table Below Write The Rational Schema And Draw It S Dependency Diagram Id 1 (37.19 KiB) Viewed 43 times

QUESTIONS FOUR (25 MARKS] Using the Employee table below, write the rational schema and draw it's dependency diagram. Identify all dependencies. EMP NO 215 216 217 218 219 220 EMP NAME SPHELELE BOKHOSI THEMBA LEFA VALENTINE PROMISE CUST NO 15 16 16 14 14 18 CUST_NAME CUST_PHONE PROD_NO HUGUETTE 0834528787 10 TANDIWE 0784521635 12 TANDIWE 0784521635 15 BUSISIWE 0618578542 12 BUSISIWE 0618578542 13 GIRLY 0829687841 13 PROD_NAME DATE SOAP 20/03/2012 BRAID 20/03/2012 PHONE 21/04/2012 PEN 22/04/2012 LAPTOP 22/04/2012 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 a database whose table(s) is at least in 3rd normal form, showing the dependency diagram and the rational schema for each table. (8)