Results 1 to 12 of 12
  1. #1
    Join Date
    Jul 2009
    Posts
    24

    Need Assistance for my Project 2

    no further assistance...
    Last edited by MarineX; 07-03-09 at 09:50.

  2. #2
    Join Date
    Jul 2009
    Posts
    24
    do correct me if im wrng. thanks
    Last edited by MarineX; 07-03-09 at 09:47.

  3. #3
    Join Date
    Jul 2009
    Posts
    24
    can anyone assist me on it ? thanks.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by MarineX
    Car Rental Agency (AgencyId, AgencyLocation, CustomerId)
    this is wrong, because it means each rental agency has only one customer


    Quote Originally Posted by MarineX
    Car Vehicle Details (VehicleId, VehicleTypeId, VehicleType)
    this is wrong because it fails 2NF

    i'm not going to hand you the correct answers, you have to figure those out yourself
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by r937
    this is wrong, because it means each rental agency has only one customer


    this is wrong because it fails 2NF

    i'm not going to hand you the correct answers, you have to figure those out yourself
    thanks... wad about this?
    Last edited by MarineX; 07-03-09 at 09:47.

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You fixed the problems Rudy mentioned but added a new one
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by pootle flump
    You fixed the problems Rudy mentioned but added a new one

    so the above is correct right now ? including the ER Diagram?

    i am wondering if its correct or not as i am taught only up to 4 of it. But right now i have 5.

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Look again at Vehicles - do you think that looks right?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  9. #9
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by pootle flump
    Look again at Vehicles - do you think that looks right?
    hmm.. r u refering to the diagram?

    erm... shld i change agencyId to RentalId instead?

    if it is... it makes me understand one more thing... your ER diagram reflects entirely the same as your NF, am i right to say that?

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I'm referring to post #15.

    Looking at your diagram, post #15 and the diagram are out of sync. Perhaps you should get one correct and derive the other from the correct one, eh?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by pootle flump
    I'm referring to post #15.

    Looking at your diagram, post #15 and the diagram are out of sync. Perhaps you should get one correct and derive the other from the correct one, eh?
    so that means what i will be doing is to switch e diagram from Vehicles > AgencyId to RentalId yahs?

  12. #12
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by MarineX
    so that means what i will be doing is to switch e diagram from Vehicles > AgencyId to RentalId yahs?
    Anyone care to help?

Posting Permissions

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