Question $2$ Normalisation $($Marks: $25)$

Answer this question in your answer booklet.

A lot of data about restaurant staff employment has already been collected in a spreadsheet $($an

extract from the spreadsheet is shown below$).$ The data has been normalised to first normal form

already $$ underlined column names indicate composite primary key columns.

Note: A waiter can work at a specific restaurant only once. But waiters are allowed to move to a

different restaurant in the chain. The employment type for a waiter never changes.

Restaurant ID

Restaurant

Name

Waiter

ID

Waiter

Name

Waiter

Surname

Employee

Type ID

Employee

Type

Start

Date

End

Date

$1$ Bears of

Brooklyn

$2$ John Smith $1$ Permanent $2020-$

$01-19$

$2020-$

$09-15$

$1$ Bears of

Brooklyn

$3$ Sarah Ndambi $2$ Temporary $2021-$

$09-09$

$2021-$

$10-30$

$2$ Cats of

Cape Town

$3$ Sarah Ndambi $2$ Temporary $2021-$

$11-02$

$-$

$2$ Cats of

Cape Town

$4$ Themba Dlamini $1$ Permanent $2022-$

$02-02$

$2022-$

$03-15$

$3$ Doves of

Durban

$5$ Pete Nair $2$ Temporary $2022-$

$04-30$

$-$

Normalise the above data to the third normal form $(3$NF$).$ Show all steps and the final answer in

the form of dependency diagrams.