These projects together allow a student to develop a database application from scratch. Analysis Provide students with a description of a simple application, such as the hospital application below. Have them create an ORM diagram for the application. If possible, have them use Allegro to produce their diagrams. The hospital ward in which a person stays determines the daily rate, and thus there is one one rate for each ward.
Patient accounts are for a single hospital stay per patient.
Each patient has one and only one account. Each account has zero or more account records. Each account record has an entry for a date and a medical procedure such as an appendectomy. It may also have an entry for a facility such as an operating room, and it may also have entries for items used such as gauze bandages. Each medical procedure, facility, and item has a certain cost.