Hello all
I have studied databases over the years, but am trying to actually build this one from scratch. I hope to be able to set this up by creating the tables, forms, etc. I know i will run into trouble with relationships as I get stuck there everytime. I have tried using sample databases, but to no avail.
Here is the logic of my database and I am attaching a picture of the tables. I did not create any forms as I need to be sure the tables are correct. As i look at this picture I think, surely I am on the right track, but then something happens and I feel lost again. I am not sure of my relationships. I get stuck here time and time again. What am I missing? Here goes . . .
- I work at a hospital and must track all of the patient meals that are delivered. A group of people called the Catering Associates (CAs) deliver the meals. They submit to me a paper report that shows what meals are delivered. The meals are delivered three times a day, Breakfast, Lunch and Dinner. The meals can be regular meals, tube feedings or supplements.
- Exhibit 1 - is the spreadsheet the CAs use to report what is delivered.
- Exnibit 2 is the spreadsheet I use to combine on three meals. These meals are delivered every day and at the end of the month, I must submit a report showing several breakdowns:
- How many tubefeedings
- How many supplements
- How many regular meals
- To which department or floor were these items delivered
- How many NOW trays did we serve for the day - NOW trays are trays that are called for when a person is admitted to the hospital late after a meal has been served or it can be a tray that was delivered because a patient has returned from x-ray or something and is NOW ready to eat. NOW trays can be sent to the Emergency dept if they decide to keep a patient overnight.
- how many LTACH meals have been served - LTACH are the long term acute patients
- how many Out Patient meals we serve - Out Patients or OPPU and OPO are patients who eat but won't spend the night
- how many Observation meals we serve - OBS Meals are patients who have a procedure done and they are being