normalization estate exercise

  • got this relational database exercise and didn't move from here but I know whats on the last table.

    all normal forms are shown using unf to 3nf.yet I was able to only do 3nf but did know unf,1nf,2nf

    this is the problem to normalize

    PropertyCode

    PropertyType

    Address

    Asking Price

    New Offer

    Commission

    Vendor A/C Code

    Name

    Address

    Tel. No.

    NegotiatorCode

    Name

    Mobile

    Email

    Solicitor A/C Code

    Name

    Address

    Tel. No

    Prospect Code

    Name

    Address

    Tel. No.

    .............................................................................................................................................................

    using the bellow method

    | UNF | 1NF | 2NF | 3NF |

  • Homework?

    What have you got so far and where exactly are you stuck?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I have only done the 3nf am stuck with the beginning UNF,1NF ,2NF

    if you don't mind I can mail you the sample method as I couldn't upload it

  • yes its homework

  • You can mail it to me, I'll just delete it. I am not doing your homework for you. I don't need the practice, I don't need the qualification.

    To do 3rd normal form requires that the table already be in 2nd normal form, so either you've done them all or you've done nothing.

    Again, what do you have so far and where exactly are you stuck? We'll help, we're not doing it for you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • How can you get to 3NF if you don't go through 1NF and 2NF first? Interesting concept.

    Here's a pretty easy primer on Normal Forms. If you apply them in sequence (and completely), you should be off and running.

  • here is my mine

    3nf

    Property Code PK

    Property type

    Vendor A/C Code FK

    Negotiator Code FK

    Negotiator Code PK

    NAME

    Code PK

    Solicitor FK

    SolicitorCode PK

    Name

    Mobile

    ProspectCode PK

    Date

  • pietlinden (8/5/2014)


    How can you get to 3NF if you don't go through 1NF and 2NF first?

    You can't. The definition of 3rd normal form goes "To be in 3rd normal form, a table must be in 2nd normal form and ..."

    mobildiho: Start from 1st normal form. You can't go straight to 3rd. Take the starting design, put it into first normal form. Make sure it's right. Take that, put it into 2nd normal form, make sure it's right. Finally, take the tables in 3nd normal form and put them into 3rd. It's a progression.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • yes but the is composite/ compound key that will be at the 2nf..ok thanks so far

  • No, you can't have parts of a table in one form and parts in another. Either the table is 3rd normal form or it isn't. You can't say that it's part 3rd, part 2nd, etc.

    2nd normal form doesn't require composite keys.

    I suspect you may want to go back to your tutor/lecturer and go over the normal forms with them again.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • pietlinden (8/5/2014)


    How can you get to 3NF if you don't go through 1NF and 2NF first?

    Very easily, you just need to ensure that the non-trivial determinants of every non-key attribute are superkeys. Outside of an academic exercise I'm surprised if anyone would go through the trouble of creating a table design that satisifies 1NF but not 2NF and then refine it to make it satisfy 2NF and then refine it again to make it 3NF. I've certainly never bothered with such exercises outside the classroom.

    2NF and 3NF are of mostly historical or academic importance anyway. Most of the time it makes sense to design to Boyce-Codd / 5th Normal Form and don't concern yourself with 3NF except in cases where you need to denormalize in order to enforce certain business rules.

  • sqlvogel (8/6/2014)


    pietlinden (8/5/2014)


    How can you get to 3NF if you don't go through 1NF and 2NF first?

    Very easily, you just need to ensure that the non-trivial determinants of every non-key attribute are superkeys.

    Which is fine when you're comfortable with normalisation and know what you're doing. The OP however is just learning it and doing an academic exercise.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • sqlvogel (8/6/2014)


    pietlinden (8/5/2014)


    How can you get to 3NF if you don't go through 1NF and 2NF first?

    Very easily, you just need to ensure that the non-trivial determinants of every non-key attribute are superkeys. Outside of an academic exercise I'm surprised if anyone would go through the trouble of creating a table design that satisifies 1NF but not 2NF and then refine it to make it satisfy 2NF and then refine it again to make it 3NF. I've certainly never bothered with such exercises outside the classroom.

    2NF and 3NF are of mostly historical or academic importance anyway. Most of the time it makes sense to design to Boyce-Codd / 5th Normal Form and don't concern yourself with 3NF except in cases where you need to denormalize in order to enforce certain business rules.

    Although it moves very quickly, I still think in terms of 1st, 2nd and so forth. That way I know I have approached it correctly. Only with the simplest databases would I be comfortable with moving directly to BCNF. And, even then, I think my mind would still go through the earlier stages.

    Tom

  • For the OP:

    Here is a link with a straightforward explanation of the normal forms.

    http://databases.about.com/od/specificproducts/a/normalization.htm

    You should be able to create the 1st and 2nd normal forms from that explanation.

    Tom

  • OCTom (8/6/2014)


    For the OP:

    Here is a link with a straightforward explanation of the normal forms.

    http://databases.about.com/od/specificproducts/a/normalization.htm

    You should be able to create the 1st and 2nd normal forms from that explanation.

    Tom

    "Straightforward" but also completely WRONG. Ignore it. Don't waste time reading anything on about.com.

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply