selfcommit/hospipal

A Simple DataBase System for a Simple Hospital (Graduate Work Requirement for CS631)

• 👋 Hi, I’m @selfcommit
• You can follow at selfcommit.com

hospipal's Issues

2/17 Comments on HospiPal Data Model

1. Is an entity for Allergy needed? Are you just using Illness for that?

2. Shouldn't Patient and Prescription have a many to many relationship?

3. Shouldn't "year_to_date" in Medication be an IntegerField type?

4. Is Corporation missing a field for "percentage ownership of each clinic"?

5. Is Nurse missing a field for "Grade"?

6. Shouldn't Nurse and Skill have a many to many relationship?

7. How are you going to join Surgeon, Skill, Surgery_Type, and Surgery? Nothing in the spec says a Skill is unique to an individual Surgeon i.e. some surgeons may have the same skill. As such I'm not sure if the current setup will satisfy the DB spec's necessary ER requirements for joining an individual Surgeon with the other entities . I may be wrong.

8. Is Patient missing a field for "Risk" (for the cholesterol program)?

9. There a number of unnecessary fields in multiple tables - I think this is already known so I won't point them out individually.

Can't Commit - Permission Denied to ad479

Hi Dan,

I tried to create a branch off of Master for my dev repo but received the following message:

remote: Permission to selfcommit/HospiPal.git denied to ad479.
fatal: unable to access 'https://github.com/selfcommit/HospiPal.git/': The reque
sted URL returned error: 403

Do you want to give me credentials to commit?

Best regards.
Bobby

2/17 Comments on HospiPal App/Data Logic Requirements Given Current Model

Hi Dan - here's a list of logical requirements given the current data model. You've probably identified a number of these but I thought I'd just dump the whole list I came up with in my review. Most of this is verbiage copied from the DB spec. As you probably know, some of these can be implemented by way of constraints and triggers in the data model. Others will have to be implemented through the app.

1. A nurse attends to several in-patients, but must have at least 5

2. No more than 20 patients are allotted to a physician

3. Every physician serves as a primary care physician for at least 7 patients

4. It is the policy of the clinic that all types of surgery have at least 2 nurses

5. Need to have a constraint for "salary_amount" ($25,000-$300,000 and can be missing)

6. If a physician leaves the clinic, temporarily assign the physician's patients to the clinic's chief of staff

7. In order to qualify as a patient, a patient must have at least one illness

8. Some inpatients may not have any nurse attending to them

9. If a nurse leaves the clinic, temporarily remove the association of all in-patients previously attended by that nurse in order to allow these patients to be transferred to another nurse at a later time

10. No 2 physicians can prescribe the same medication to the same patient

11. If a physician leaves the clinic, all prescriptions prescribed by that physician should also be removed because this information is also retained in the archives

12. In order for a patient to take a medicine the medicine must be prescribed to that patient

13. Cholesterol Program

• Total cholesterol = HDL + LDL + 1/5(triglycerides)
• Total cholesterol < 4 suggest no risk of heart disease due to cholesterol (i.e. risk is N)
• Total cholesterol > 4 and < 5 reflects low risk (i.e. L)
• Total cholesterol > 5 is moderate risk (i.e. M)
• High risk (i.e. H) is not coded as a function of cholesterol