Pete$$s Pools have a number of swimming centres. Each centre has a name, establishment date, and a description. Clients $($who have an ID and name$)$ can join one or more of these swimming centres. As a client joins a centre, the date that the client joined is to be recorded. 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