Steps to deign the database.
1. List down the Entities
2. List down the attributes of all entities
3. Draw the relationship between the entities based on their attributes
4. Define the constraints like optional,range validations for the attributes
Based in the initial analysis, i found the following active entities
1. Branch
2. Clients
3. Health Insurance types
4. Staff
5. Sections of each branch
6. Gym details
7. Gym Instructor details
8. Gym Class Timetable
9. Gym Equipments
10. Equipment Service History
11. Equipment Fault History
12. Equipment Supplier
13. Seminar Room
I can provide the detailed database design document with E-R diagram for all the entities.
Thanks.
Hi,
I have a huge experience in Database (DWH/OLTP) design, architecture and development.
Requirements seems clear, the only question is desired ER-diagram format. But in any case you can consider me for that job.
Regads,
Mykhail