$1.$ SQL Schema:

o Based on the ERD, create the SQL schema for the healthcare database. Include appropriate data types, constraints, and relationships.

o Submit your $.$sql file that contains your CREATE TABLE scripts for your database

$2.$ Sample Data:

o Generate sample data to populate the tables in your database. Ensure the data reflects realistic scenarios, such as multiple patients with varying medical histories, appointments, and billing records.

o A minimum of $5$ Physician, $5$ Patients $($with their Medical Record$),8$ appointments, and $8$ bills must be present

o Submit your $.$sql file that contains your INSERT INTO scripts for your database

$3.$ SQL Queries:

o Write SQL queries to demonstrate the functionality of the database. Include queries for:

$$ Retrieving patient information.

$$ Updating doctor details.

$$ Adding new appointments.

$$ Calculating total billing for a specific patient.

$4.$ Indexing:

o Identify fields that would benefit from indexing and justify your choices. Implement additional indexes where appropriate, but Primary Key and Foreign Key indexes must exist in each table. If there are no Foreign Keys in your table, then you do not need to have a Foreign Key index.

o Submit a screenshot of the Indexes in your database by table. You can use the query SHOW INDEX from table$\_$name; to get your indexes on the table. You can provide a screenshot of the result of the query.