Simple Hospital Registration Management System
Project for SE3003L: Software Engineering Outline.
Implemented using Python 3, with Tkinter and MySQL.
Before getting started, please make sure you have these installed:
- Python 3
- MySQL
pip install Faker mysql-connectorRun sql/tables.sql in MySQL, using either:
- MySQL Workbench, if installed
- Or
mysql -e sql/tables.sql
Configurations are inside resources\mysql_config.json
For details, please visit MySQL: Python Connection Arguments.
| Name | Description |
|---|---|
user |
The user name used to authenticate with the MySQL server. |
password |
The password to authenticate the user with the MySQL server. |
host |
The host name or IP address of the MySQL server. Default is localhost. |
database |
The database name to use when connecting with the MySQL server. Default is hospital according to tables.sql. |
Please make sure you have package Faker installed.
Run the generation scripts in the following order:
gen_users.pyUsernames, passwords, user typesgen_departments.pyDepartment names, locationsgen_doctors.pyNames, assign doctors to departmentsgen_patients.pyNames, balance, personal infogen_registration.pyRegistration entries, states
You should be able to see loads of entries in your database now.
Run ui_login.py to get started.
Default logins:
Doctor: usernamedoctor, passworddoctor
Patient: usernamepatient, passwordpatient