You have been presented with the case study below. You are required to design a database...

 

Transcribed Image Text:

You have been presented with the case study below. You are required to design a database (MySQL) schema for this scenario. These are the requirements: 1. Read the case study and develop an Entity-Relationship Diagram using the conventions for this unit. This diagram needs to describe all the necessary entities and their relations in the case study. Visio is recommended for the E-R Diagram, but any diagramming package, or a hand-drawn diagram included as an image in your Word Document or PDF is acceptable. 2. Using this unit's Entity-Relationship to Relational Schema Algorithm, convert your Entity-Relationship Diagram into a relational schema. 3. Using MySQL create the database based upon your relational schema. 4. Enter two records into each of the relations that you have created in your MySQL database. Case Study Regi Zuqui soccer club wants to create a database to keep track of kids enrolling in the club. The club offers multiple programs, each program can have multiple age groups, and each age group can have multiple sessions. Each kid can enrol in multiple programs and each program can have multiple enrolled kids. For each kid, the club needs to store their name, age, parent/guardian name, contact information, and height. For each program, the club needs to store its name, description, fees, and the number of available slots. For each session, the club needs to store the date, time, and location. The club's colour is red and white, as such the players wear red shorts and white with red stripe shirt. Design a database schema to store the necessary information using MySQL. I You have been presented with the case study below. You are required to design a database (MySQL) schema for this scenario. These are the requirements: 1. Read the case study and develop an Entity-Relationship Diagram using the conventions for this unit. This diagram needs to describe all the necessary entities and their relations in the case study. Visio is recommended for the E-R Diagram, but any diagramming package, or a hand-drawn diagram included as an image in your Word Document or PDF is acceptable. 2. Using this unit's Entity-Relationship to Relational Schema Algorithm, convert your Entity-Relationship Diagram into a relational schema. 3. Using MySQL create the database based upon your relational schema. 4. Enter two records into each of the relations that you have created in your MySQL database. Case Study Regi Zuqui soccer club wants to create a database to keep track of kids enrolling in the club. The club offers multiple programs, each program can have multiple age groups, and each age group can have multiple sessions. Each kid can enrol in multiple programs and each program can have multiple enrolled kids. For each kid, the club needs to store their name, age, parent/guardian name, contact information, and height. For each program, the club needs to store its name, description, fees, and the number of available slots. For each session, the club needs to store the date, time, and location. The club's colour is red and white, as such the players wear red shorts and white with red stripe shirt. Design a database schema to store the necessary information using MySQL. I