Answer to Question #174924 in Databases | SQL | Oracle | MS Access for NTOBEKO

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.1 Identify all dependencies. (8) 

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

Answer 1

1 - SQL query for select everything from the EMPLOYEES table:

select * from HumanResources.Employee;

For 2 we need to to have the structure and the column names of the four tables as:

HumanResources.Employee,

Sales.Currency,

Person.ContactType,

Sales.Customer.