This is a website I built for the class "An Introduction to Databases" (CS3319) I took at Western University.

This website was built using PHP, CSS, Javascript, HTML, and MySQL.
The goal of this project was to create a health network website that allows someone to update the doctors, hospitals, patients and treats (which doctor is treating which patient) tables.

The follow is a list of features that health websites has:
- Lists all the doctor's first name and last name in alphabetical order by last name or by first name.
- Allows the user to decide if the doctors name (either first or last) should be in ascending or descending order.
- Once the list of doctors is displayed, allows the user to select one of the doctors and then display all of this doctor's information.
- Lists all the doctors who were licensed before a given date.
- Allows the user to enter a new doctor.
- Allows the user to delete an existing doctor.
- Allows the user to update a hospital's name.
- Lists all the hospital names and the first name and last name of the head doctor of each hospital and the doctor's start date as head, in alphabetical order by hospital name.
- Allows the user to select a patient (by entering their OHIP number) and then outputs that patient's first and last name and the name of the doctor(s) who treat that patient.
- Allows the user to assign a doctor to treat a patient.
- Outputs the first and last name of any doctor who has no patients.