Begin by outlining the requirements for your database, based on the scenario given below.

Consider the type of data that needs to be stored, how the data will be used, and any specific

constraints that should be applied. This step is critical as it will guide the structure of your

database.

The scenario to use for this database design is First Coast Yoga Studio $($FCYS$).$ FCYS wants to

create an app that will allow its patrons to sign up for yoga classes. The studio offers a variety of

classes and each class is taught by one of its highly qualified yoga instructors. The studio would

like to store data about its members, instructors and classes.

Design the Database Schema:

Develop an initial database schema that includes tables, primary keys, foreign keys, and any

necessary indexes. Ensure that your design aligns with the goals of structural correctness and

data integrity as discussed in the module.

Implement the Schema:

Using a drawing software like Visio and Figure $2\mathrm{.}2$ as an example, define and draw the structure

of your database. This should include tables for members, instructors and classes, in addition to

any tables needed to record information about classes and member signups.

Document Your Design:

Provide a brief explanation of your design choices, including why you selected certain keys and

indexes, and how your design meets the database requirements. This should be clear and

concise, demonstrating your understanding of the key concepts.