Answer to Question #332869 in Databases | SQL | Oracle | MS Access for Nick

Question

Using the Employee table below, write the rational schema and draw it’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.2 Using the Employee table above, write the rational schema and draw it’s dependency diagram. (9) 

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order