Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2008
    Posts
    6

    NORMALISATION CHALLENGE! not easy!!

    UNNORMALISED: (batchno, agentno, agent name, holiday code, cost quantity, booked airport, code, airport name)


    CAN ANYONE GET THIS INTO 1NF
    THEN 2NF
    THEN 3NF?

    I struggled!!

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Why don't you post your final attempt so we can comment on that rather than simply just do your homework for you.

    Mike

    PS very few of us would ever go through the individual stages of 1NF,2NF ... but this is a useful exercise for the student.

  3. #3
    Join Date
    Nov 2008
    Posts
    6
    It is not my homework...I am doing for "fun".

    (batchno,agentno,agentname,(holidaycode,cost,quant ity,airportc,airportn))

    Agentno->agentname

    Holidaycode->cost

    airportc->airportn


    That is as far as I got, I am confused about quantity as it doesn not depend on any PK!

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    in which case you need to think what "quantity" represents, find what entity its dependent on. if you cant find any dependency then its probably an entity in its own right
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    It is not my homework...I am doing for "fun".
    Yeah, right

    As a student do you often set yourself database work and then include fields you don't know the meaning of?

  6. #6
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by gdanelian
    It is not my homework...I am doing for "fun".

    (batchno,agentno,agentname,(holidaycode,cost,quant ity,airportc,airportn))

    Agentno->agentname

    Holidaycode->cost

    airportc->airportn

    That is as far as I got, I am confused about quantity as it doesn not depend on any PK!
    Then maybe your list of attributes is incomplete. Determining dependencies based only on a list of hypothetical names is a pretty arbitrary exercise. The answer can be whatever you want it to be.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by gdanelian
    It is not my homework...I am doing for "fun".
    Sure it isn't....http://www.dbforums.com/database-con...king-help.html
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    From your original question:
    ..., cost quantity, ...
    That implies to me that there is one attribute called "cost quantity", or perhaps one attribute "cost" that is of type "quantity"?!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •