You$$re now going to return to the Pete$$s Pools case $($see Pass $5$a$).$ The business rules have

changed. Read the new narrative:

Clients may now join and leave and$/$or re$-$join any swimming centre. As a result you need to

record such information.

$$ Adjust your previous ERD. You should not have to create any new entities. Do not introduce any

surrogate keys. Indicate all identifiers. The correct identifier is crucial. An incorrect identifier may

prohibit customers from re$-$subscribing to the same magazine again.

$$ Convert the ERD into a Relational Schema.

$$ Create some Test data $($in a Table format $$ no need to write out Insert statements$)$ :

o Create three sample clients and three sample swimming centres.

o Create data that allows clients to join, leave and re$-$join a swimming centre.

$$ Scan, Photograph or take a screenshot of the ERD and place it in the document named

T$05$C$.$DOCX

$$ Copy and paste the Relational schema and place it in the document named T$05$C$.$DOCX

$$ Copy and paste the Test data and place it in the document named T$05$C$.$DOCX