Hi everyone, long time no see

I am working on a small project which consists of making a system for a leisure center using visual basic. At the moment i am working towards my investigation and design, i am little bit stuck and need some advice from anyone of you who know a little bit about Entity relationship diagrams.

In the project i am working on i am have to design and build a system which could allow sports hall, personal trainer, different type of classes e.g dance classes bookings. A member can sign in after he registers with the centre and start booking different type of facilities. Moreover, the there are many people working in the centre, like receptionists, class instructors and personal trainers.

I have design an ERD for this. I just need know if i am correct or need some modifications in my design.

Name: ERD.jpg Views: 773 Size: 7.9 KB


Have small brief:

  • A member can have many PT sessins and class bookings
  • A member can also have many Sports hall bookings
  • One personal trainer can be booked more than once
  • A class instructor can be booked more than once


So what do you think? Am I missing something here or is everything fine?

Cheers