Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Meet and Greet (http://www.go4expert.com/community/meet-and-greet/)
-   -   Help functional dependencies in 1NF (http://www.go4expert.com/community/help-functional-dependencies-1nf-t23880/)

Iona 16Nov2010 01:44

Help functional dependencies in 1NF
 
Hi
Just starting lectures in normalisation so this will seem a bit simple to some of you

have a relation in 1NF

carReg make model custNo custName hireDate

R111EEE ford escort c100 smith J 14/05/01
R111EEE ford escort c201 owen P 15/05/01
T666TTT Nissan sunny c100 smith J 20/06/01
Y666YYY ford mondeo c413 blatt S 14/05/01
Y666YYY ford mondeo c200 smith J 20/05/01
H888HHH nissan sunny c295 owen P 20/05/01
Y666YYY ford mondeo c413 blatt S 10/06/01
R111EEE ford escort c100 smith J 12/07/01

Assuming a customer can hire only one car on the same date but may hire the same car on different dates and that the functional dependencies represented by the data in the relation will hold for any additional data identify the functional dependencies represented by the data in the relation.

I have the following

(carReg, hireDate).......(make,model,custNo,custName) primary key
(carReg,custNo)........(make,model,custName) candidate key
(carReg)........(make,model) partial dependency
(custNo,hireDate).........(carReg,make,model,custN o) candidate key
(custNo).......(custame) transitive dependency

Can someone let me know if I am on the right tracks

Just cant get my head round this


All times are GMT +5.5. The time now is 22:13.