Relationtional Databases

[Guest]

I am learning about databases at college, including one-to-many
relationships. My teacher keeps referring to 'one' tables and 'many' tables.
Am I right in thinking that the 'one' table is the primary table in the
relationship, where the primary key is the field linked (e.g. Computer
Details) whereas the 'many' table is the table which could have multiple
entries for that field (e.g. Computer repairs table, where one Computer may
have many recorded repairs).

Thanks

 

[Jeff Boyce]

If I understand your example, yes. Another example is an Order. One Order
can have many OrderItems.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/