schematic diagrams (1 Viewer)

[Fry]

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!!

 

[KingofthieF]

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

 

[SamD]

To alter the relationships in Access first go to the relationships window then click to select the join, it will go bold. Then right click and select join properties...

 

[Fry]

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

yeah i suffer from the same problem!!
thanks for that King & SamD, you both are legends!!!