Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2011
    Posts
    3

    Exclamation Unanswered: Need help with basic normalisation..please help

    Estate agency -- single branch

    Property:
    address
    numberofbedrooms
    typecode
    typedescription
    price


    Viewing:
    Date
    customercode
    customername
    customeraddress
    customerphone
    salesconsultantID
    salesconsultant

    I have the two tables above..i need someone to put it into 1nf, 2nf and 3nf and with expressions if possible please.
    no additional attributes are allowed
    and address is the starting primary key

    Thank you

    wulf

    need asap reply.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >need asap reply.
    when do you need to turn in homework assignment?

    If you already know what fields go in which tables; then normalization has already occurred.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2011
    Posts
    3
    av got few more days, but with exams needed it done asap.

    thats the two tables i have been given, they need to be put into 1nf, 2nf and 3nf.
    the brief states
    (a) Design a relational database for the table fragment shown on the next page.

    You should assume that the data shown in the table is a typical snapshot of data for these records and demonstrates all the enterprise rules which apply, even though some rules may be simpler than those in reality.

    Normalise this table into Third Normal Form showing the intermediary stages of First and Second Normal Form. Primary keys and foreign keys in all the three forms should be indicated clearly. You are expected to start the normalisation process by first choosing the property address as a primary key. Your normalised tables should only include the attributes shown in the table fragment; do not add any new attribute.

    Justify your solution to this problem.

    hope that helps you give me an answer.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Apr 2011
    Posts
    3

    help

    help is still needed. any one good at normalisation. help would be really appreciated.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by wulf View Post
    help is still needed.
    you can beg all you want, it won't help

    we are here to help you do your assignment

    but we are not gonna do it for you

    so, what specific questions do you have?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

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