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

    Need help on this (Normalization)

    Hi, im having trouble with this...

    anyone willing to help me out to verify if its right or wrong and do tell me where went wrong. thanks!

    http://img37.imageshack.us/img37/4643/3nf.png

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    hand it in just like that, it's perfect, you are sure to get an A

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by r937
    hand it in just like that, it's perfect, you are sure to get an A


    erm.. really? is it correct? or do i have to provide more details ? So that people can understand what im trying to describe?
    Last edited by MarineX; 07-05-09 at 21:08.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    what do you think
    do you think it meets the requirement
    does it easily explain the processes.
    does it support the business requirement

    ..after all its your homework, its your thought processes that matter
    you have to demonstrate that you have understood the material
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by healdem
    what do you think
    do you think it meets the requirement
    does it easily explain the processes.
    does it support the business requirement

    ..after all its your homework, its your thought processes that matter
    you have to demonstrate that you have understood the material
    thanks for replying...

    thats why i asked. if not i wouldnt. sighz...

    if u r not here to help or even answer my question, why bother commenting?

    by saying those.. i will not know where went wrong.

    its like telling others.. your router is spoil but not telling the other where exactly is e problem..

    being spoiled is being extremely general.... is that really that difficult to explain it out alittle more? will that really hurt?

    im not here to ask for direct answers w/o doing anything.
    Last edited by MarineX; 07-06-09 at 11:54.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by MarineX
    im not here to ask for direct answers w/o doing anything.
    well, that's good, because most people who come here for homework help aren't very eager to do the necessary work

    so let's go back to the beginning, and why don't you explain which parts of your diagram you are having trouble with
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by r937
    well, that's good, because most people who come here for homework help aren't very eager to do the necessary work

    so let's go back to the beginning, and why don't you explain which parts of your diagram you are having trouble with
    im just trying to understand if my 3NF is correctly planned or not... coz it seems wierd but i just cant to seem to find where e fault lies.

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    without knowing the constraints you are trying to model how do we know whether your model is reasonable?

    if you've looked at it for long enough
    if you've read the suitable texts (Fundamentals of Relational Database Design -- r937.com and The Relational Data Model, Normalisation and effective Database Design) spring to mind
    ...and you've talked it through with your peers and your teachers / lecturers then its probably right or good enough

    ..unless you have got a specific problem, and can explain where your problem lies then I don't see how we can help with 3nf
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by healdem
    without knowing the constraints you are trying to model how do we know whether your model is reasonable?

    if you've looked at it for long enough
    if you've read the suitable texts (Fundamentals of Relational Database Design -- r937.com and The Relational Data Model, Normalisation and effective Database Design) spring to mind
    ...and you've talked it through with your peers and your teachers / lecturers then its probably right or good enough

    ..unless you have got a specific problem, and can explain where your problem lies then I don't see how we can help with 3nf
    my apologies...

    my scenario is smth like that..

    • one School create one Project
    • one Project created by one School
    • one Project require many Loans
    • one Loan is required by one School
    • one Project makes one Advertisement
    • one Project makes many Advertisement
    • one Advertisement is made by one Project

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by MarineX
    one School create one Project
    one Project created by one School
    one Project require many Loans
    one Loan is required by one School
    think this through carefully, you have relationships here that aren't in the diagram

    Quote Originally Posted by MarineX
    one Project makes one Advertisement
    one Project makes many Advertisement
    one Advertisement is made by one Project
    none of these are in the diagram either

    also, in the diagram, the relationship between Advertising and Loan is wrong
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by r937
    think this through carefully, you have relationships here that aren't in the diagram

    none of these are in the diagram either

    also, in the diagram, the relationship between Advertising and Loan is wrong
    hmm.. so what shld it be ?

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by MarineX
    hmm.. so what shld it be ?
    hmmm, what do you think it should be?

    make an effort and i promise to tell you if it is correct

    srsly, i'm not going to do your assignment for you
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Jul 2009
    Posts
    24
    Quote Originally Posted by r937
    hmmm, what do you think it should be?

    make an effort and i promise to tell you if it is correct

    srsly, i'm not going to do your assignment for you

    but srsly, i did not even once ask of you to do my assignment for me. Why do you have to keep harping on that?

    i will work on it and see where went wrong... thanks again. will request for assistance again if i neeed it. thanks.

Posting Permissions

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