Question

Pass Task3. Read the following narrative: Jims Gyms have a number of fitness clubs. Each club has a name, establishment date, and a description. Clients (who have an ID and name) can join one or more of these fitness clubs. As a client joins a club, the date that the client joined is to be recorded Draw an ERD based on this information. Expand all M:M relationships. Do not introduce any surrogate keys. The ERD may be neatly hand drawn or can be created in a package such as Visio. The symbols in the ERD must conform to the symbols used throughout all ERD lectures this semester. Clearly indicate strong and/or weak entities, all identifiers and all relationship names Convert the ERD into a Relation Schema

Answer 1

Task 3

ER-Diagram

esdablishment date nam e 1 D tnes Client

Participation of entity client in relation joins is total, it means each client must join at least one fitness club.

Relation schema:

fitness_club(name, establishment_date)

client(ID, name)

joins(name, ID, date_of_joining)

name is a foreign key reference to fitness_club relation and ID is a foreign key reference to client relation.