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

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?

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.

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.

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

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 ?

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.