Milestone Project

Serzhan Yedil CSSE-1601K 25000

Topic: Fitness club.

Nowadays, Fitness club is becoming more and more popular. So I decided to develop the application about a fitness club. I have 7 entities, in which there are three types of relaitonships as well.

7 Entities:

• coach(id, name, tel)

• course(id, name, coachId, roomId)

• room(room_id, capacity)

• equipment(id, name, price, roomId(FK))

• member(id, name, tel)

• couresmember(id, courseId(FK), memberId(FK))

• membershipcard(id, createdAt, memberId(FK))

Relationships:

• one to one:

  • coach - course
  • member - membershipcard

• one to many:

  • room - course
  • room - equipment

• many to many:

  • member - course

Validations

the remote validation

VerifyEmail of the property 'Email' of model 'Member' and the function is in the Controller 'MembersController'

the custom attriubute validation

The custom attribute validation is 'NotContainsDigits' It validates the property 'Name' of model 'Member', making sure that the name contains no digits, the implementation is in the same model.

the model which implements IValidatableObject

The model 'Equipment' inherits IValidatableObject And we'r using it to make sure when the equipment's name is 'bench', its price should not exceed 20000.