i just dont get any of it! what is with all this one-to-many, many-to-many? i keep testing it out on my pc but i dont know how to create the relationships its really confusing. the text book doesnt help at all. can someone help? trials are on monday nooo!!
-
Finished your HSC? Check out our University Discussion, Non-School forums or help out next year's HSC students! -
YOU can help the next generation of students in the community! Share your trial papers and notes on our Notes & Resources page
schematic diagrams (1 Viewer)
- Thread starter Fry
- Start date
KingofthieF
Member
Schematic diagrams are data modelling tools used for databases, they defined the entities, attributes and the relationships between entities...
An easy way to understand it i guess, is through visualising it...
Take one to many relationship for example:
1. teacher (one) to courses (many) means that one teacher can teach many courses but at the same time each courses is only taught by one teacher...
2. Student (many) to courses (many) means that a student cound be doing more that one courses and at the same time each courses can have many students...
and so on so for one-to-one... many-to-one...etc
I've tried using Microsoft Access for my database assignment and finds the same problem with defining relationship... it seems that Access automatically set all relationships to one-to-many... i dun know how to change it yet but check the help menu~~
hope this helps
best luck for ur IPT trials
An easy way to understand it i guess, is through visualising it...
Take one to many relationship for example:
1. teacher (one) to courses (many) means that one teacher can teach many courses but at the same time each courses is only taught by one teacher...
2. Student (many) to courses (many) means that a student cound be doing more that one courses and at the same time each courses can have many students...
and so on so for one-to-one... many-to-one...etc
I've tried using Microsoft Access for my database assignment and finds the same problem with defining relationship... it seems that Access automatically set all relationships to one-to-many... i dun know how to change it yet but check the help menu~~
hope this helps
best luck for ur IPT trials
yeah i suffer from the same problem!!Originally posted by KingofthieF
I've tried using Microsoft Access for my database assignment and finds the same problem with defining relationship... it seems that Access automatically set all relationships to one-to-many... i dun know how to change it yet but check the help menu~~
hope this helps
best luck for ur IPT trials
thanks for that King & SamD, you both are legends!!!