Hussin-Swilhe/PL-SQL-and-SQL-Project-whth-Oracle — reverse-engineered prompt

I want a small medical center management system built from this project, basically a clinic or small hospital app with a proper Oracle database and simple Oracle Forms screens.

Please make it so staff can log in, land on a home screen, and log out safely. There should be an admin side to add, edit, delete, and view the main data like patients, doctors, departments, nurses, appointments, medical records, and test results. Appointments should connect a patient with a doctor, department, date, and time. Medical records should let the user save diagnosis, treatment, and related exam or test information.

Use the database relationships shown in the ERD and mapping files so the data stays consistent, and add the usual checks for required fields and valid links between records. If the zip already has forms or database work, continue from that instead of starting over.

Keep the interface straightforward and usable for non technical clinic staff. If anything is unclear, look at the included docs and current Oracle Forms conventions online.