How sebastianwin01/cis3400-gym-database works
This is a coursework project for designing and analyzing a MySQL database for a multi-location gym, not a running gym-management application. Its documented workflow moves from business requirements through entity and schema design to SQL implementation and business analysis. The README describes six core tables and five analytical questions, but the supplied tree contains no SQL scripts or source excerpts, so the graph reflects documented scope rather than verified runtime behavior.
Main entry points: 02_entities_and_attributes.md Entities and fields · 03_database_design.md Database design · README.md Business questions · 01_Business_Requirements.md Gym requirements
Components 9
Business planning
- Gym requirements
docs/01_Business_Requirements.md
Data design
- Entities and fields
docs/02_entities_and_attributes.md - Database design
docs/03_database_design.md - Normalization
docs/04_normalization.md - MySQL implementation
docs/05_database_implementation.md - Six-table schema
docs/02_entities_and_attributes.md
SQL analysis
- Business questions
README.md - Attendance and revenue insights
README.md
Other components
- Business analyst
Connections 8
- Gym requirements → Entities and fields: defines entities
README.md - Entities and fields → Database design: informs design
README.md - Database design → Normalization: guides review
README.md - Database design → MySQL implementation: guides creation
README.md - Entities and fields → Six-table schema: specifies tables
README.md - Business analyst → Business questions: poses questions
README.md - Business questions → Six-table schema: queries tables
README.md - Business questions → Attendance and revenue insights: summarizes findings
README.md