Relational Database Design - Now it's your turn

Task 1

Here is a record card from a vet's surgery

1    Write down the 2 entities

2    Write down next to the entities you have chosen which fields belong with each entity

3    Choose a unique key field for each entity

Write your answers in the table below

Task 2

Here is a record card from an art dealer

Write down the 2 entities

1    Write down next to the entities you have chosen which fields belong with each entity

2    Choose a unique key field for each entity

Write your answers in the table below

Task 3

This is a record card from the North West Institute of Plumbing

Write down the 2 entities

1    Write down next to the entities you have chosen which fields belong with each entity

2    Choose a unique key field for each entity

Write your answers in the table below

Task 4

Here are 2 record cards that are used by HITEK Computer Services

Write down the 3 entities

1    Write down next to the entities you have chosen which fields belong with each entity

2    Choose a unique key field for each entity

Write your answers in the table below

Back to index