1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help functional dependencies in 1NF

Discussion in 'Meet and Greet' started by Iona, Nov 15, 2010.

  1. Iona

    Iona New Member

    Joined:
    Sep 30, 2007
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    0
    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
     

Share This Page