Cambridge Nationals: Database Entity Relationship Modelling

A field that is a primary key in the same table or another table. It is the method of recording relations in a relational database.

• foreign key
• surrogate key
• name
• key field

For the following two ENTITIES, which is the appropriate relationship:
RULER / COUNTRY

• One to One
• One to Many
• Many to Many

For the following two ENTITIES, which is the appropriate relationship:

PRODUCT /PRICE

• One to One

• One to Many

• Many to Many

For the following two ENTITIES, which is the appropriate relationship:
ZOO / ANIMAL

• One to One
• One to Many
• Many to Many

For the following two ENTITIES, which is the appropriate relationship:

RECIPE/ INGREDIENT

• One to One

• One to Many

• Many to Many

For the following two ENTITIES, which is the appropriate relationship:
DOCTOR / PATIENT

• One to One
• One to Many
• Many to Many

For the following two ENTITIES, which is the appropriate relationship:
SIM CARD / PHONE NUMBER

• One to One
• One to Many
• Many to Many

For the following two ENTITIES, which is the appropriate relationship:
COUNTRY / CAPITAL CITY

• One to One
• One to Many
• Many to Many

For the following two ENTITIES, which is the appropriate relationship:

ACTOR / MOVIE

• One to One

• One to Many

• Many to Many

For the following two ENTITIES, which is the appropriate relationship:
CUSTOMER / ORDER

• One to One
• One to Many
• Many to Many