2. Design an E-R model for a fitness club that enrolls members in a variety of...

 

Transcribed Image Text:

2. Design an E-R model for a fitness club that enrolls members in a variety of classes run by different trainers. Member is identified by unique member id, member name, Email, Phone number and address. Trainer is identified by unique Trainer Id, Trainer Name, Rank, Age, and Phone number. The class is identified by unique class number, class Name, Class Description and level. Member might join more than one class and the class might be joined by more than one member. Trainer teaches more than one class and the class might be taught by more than one trainer. 1 2. Design an E-R model for a fitness club that enrolls members in a variety of classes run by different trainers. Member is identified by unique member id, member name, Email, Phone number and address. Trainer is identified by unique Trainer Id, Trainer Name, Rank, Age, and Phone number. The class is identified by unique class number, class Name, Class Description and level. Member might join more than one class and the class might be joined by more than one member. Trainer teaches more than one class and the class might be taught by more than one trainer. 1