Detailed information file attached
Project: Database design for Gym Management System Project
PART 1 (3%)- Write a 1-2 page Statement of Work (SOW) to describe the need to create, design and implement the database that you propose for your project.
PART 2 (5%)- Create requirement definition document and use ER Assistant, Visio, or SQL Developer Data Modeler to create Entity Relationship Diagram (ERD) for your project.
PART 3 (6%)- Use SQL DDL statements to create your tables/views/triggers and other required database objects for you project. Also include queries (select statements on database catalog/data dictionary such as user_objects and user_tables) to demonstrate all objects are created successfully.
PART 4 (6%)- Use SQL DML statements to insert sample data into your tables. Use SQL SELECT statements to query your data. This submission should be a final consolidated document which includes Project