Relationtional Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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/
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One to one relationship 0
Look up tables vs. relationships design 1
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Database 3
Database for document tracking 0
Relationship Help 3
Help... .. Deciding one to many or many to many.. Type.. 2
same field in more than one table 2

Back
Top