Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    4

    Need help with Databases in 3NF

    I had this homework to do where I had to put this DB into 3NF

    BLUE Marina Corporation
    Marina (MarinaNum, MarinaLocation, Date_In, Date_out, DailyDockingFee, BoatLength, BoatName, OwnerNum, LastName, FirstName, Phone)
    Create tables in 3rd NF
    I had submitted this as my answer

    Marina (MarinaNum, MarinaLocation, BoatId)
    Service (MarinaNum, BoatID, ServiceID)
    ServiceHist (ServiceID, DailyDockingFee, DateIn/Out)
    Owner (OwnerId, OwnerLastName, OwnerFirstName, Phone)
    Boat (BoatID,OwnerID)
    BoatInfo (BoatName, BoatLength)
    Apparently there were several mistakes
    He replied with
    1.what is the function of BoatId here
    Marina (MarinaNum, MarinaLocation, BoatId)

    2.what is the purpose of this PK in the tables
    Service (MarinaNum, BoatID, ServiceID)

    3.where is the link BoatName and BoatId
    BoatInfo (BoatName, BoatLength)
    How can I fix this?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by GaDoomZ View Post
    How can I fix this?
    well, first of all, you have to understand why he asked those questions

    why don't you try answering them, one at a time

    i will help you if you try
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    read up on normalisation
    http:\\www.r937.com\Relational.html
    and
    The Relational Data Model, Normalisation and effective Database Design
    are worth a look.

    you need to think carefully about naming
    entity 'boat' is misnamed it probably should be BoatOwners
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Please do not post the same question in separate places. Threads merged.
    George
    Home | Blog

Posting Permissions

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