Plan
Plan
Plan
For this program I’m going to use python, sqlite3 for databases to store data and
datetime module to work with date and time. I have some knowledge in this modules
and program is not really complicated so I will use simple sqlite for the database . I’ll
need table for appointments with doctor containing:
Patient’s name
Surname
Date of birth
Date of appointment
Time of appointment
Symptoms
If he has an allergies
Patient contact details
Table with patients require surgery:
Patient’s name
Surname
Date of birth
Date of operation
Time of operation
Description of operation
If he has an allergies
Patient contact details
Table with hospital treatment
Patient’s name
Surname
Room number
Date of treatment start
Nurse visit Table:
Patient’s name
Surname
Date of visit
Patient’s address
Provision Table:
Patient’s name
Surname
Date of provision
address
Date of delivery
And achieve table for each of these ones
For the GUI I will use eel module for python, which allows me write GUI on
HTML+CSS+JAVASCRIPT
So I’m going to write all operations with databases and date in python file and I will
call it from Javascript file, so I can use it on my HTML page.
As a source of knowledge I’ll use sqlite documentation and datetime documentation.
PLAN
1. Create a database with all tables
2. Create functional to book a doctor appointment
3. Enable editing this appointment and delete it.
4. Create functional to book a surgery for the patient.
5. Enable hospital treatment after surgery
6. Enable discharging from hospital
7. Enable nurse visit after discharging
8. Enable home provision after surgery
9. Create auto achieving and deleting no longer needed records.
10. As I finished all modules I will put them together in one program
11. Final testing
NOT FUNCTIONAL REQUIREMENTS
As we store people data, it has to be safe.
Program has to be easy to use for everyone
RISKS
Weak cyber security. I can’t provide strong security with my knowledge.
If data is not accurate it will be a problem, so we have to validate it
REPORT
Firstly I did the pthon console program with that functionality: