Hospital Management System:

Database Name: HospitalManagement

Table 1:
Name:- Patient Details
Columns:
  Patiet_id
  Name
  Date of Birth
  Age
  Sex
  Address
  Date of Admission
  Date of Discharge
  Doctor Assigned (One doctor can be assigned to many patients but one patient is assigned to only one doctor)

Table 2:
Name:- Doctor Details
  Name
  Date of Birth
  Age
  Sex
  Speciality

Project Steps:

- start a new php project
- create a database
- connect your php project to the database
- create two tables: doctor and patient
- save data in two tables
- write code to show the following actions
    Find total patients
    Find total patients admitted in a day
    Find Male and Female Patients
    Find patients assgined to a doctor