7. Linked tables and relationships

The previous page has a picture showing two tables with related fields. These are depicted graphically as a line between them.

relationship in a database


The line between the fields has a '1' on one side and the infinity sign on the other. In Access this indicates a 'one-to-many' relationship. This is described in more detail on the Entity Relationship Diagram mini-web.

A small relational database may only contain two tables whilst a large corporate database could contain hundreds of tables.



Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: database diagrams



Copyright © www.teach-ict.com