03d - Relationships

Question 1

Define a relationship.

Answer 1

Links two tables in a database using afield that exists in each of the tables. Primary key of one table is stored as the foreign key of another.

Question 2

Examples of Entity Relationships.

Answer 2

Pupil Locker=One to one
Form teacher to pupil=One to many
Pupil to Class=One to many