1.Trucking Company: Using the business rules listed below, develop a database model for an application to track trucks, drivers and their driving assignments. You are encouraged to identify additional business rules and assumptions to help identify entities and attributes. State all such additional business rules and assumptions that you make. Use the Crows Foot notation. Clearly indicate primary keys, foreign keys, relationship type, relationship strengths, mandatory attributes, optional attributes and cardinalities.

  • The company owns multiple trucks
  • The company also rents trucks from multiple rental companies
  • The company operates trucks amongst multiple cities
  • Each route is assigned a primary driver and a backup driver
  • A truck owned by the company must be serviced after 50 trips

2.Hospital: Using the business rules listed below, develop a database model for an application to track doctors and patients at a hospital. You are encouraged to identify additional business rules and assumptions to help identify entities and attributes. State all such additional business rules and assumptions that you make. Use the Crows Foot notation. Clearly indicate primary keys, foreign keys, relationship type, relationship strengths, mandatory attributes, optional attributes and cardinalities.

  • The hospital employs multiple doctors
  • The hospital employs multiple nursing staff
  • A doctor can have multiple degrees but must have a minimum of one degree
  • A doctor can be a general physician or a specialist
  • A patient can be treated as in-patient or out-patient
  • In-patients are assigned hospital rooms.
  • Patient rooms can be of type: single, shared, suite
  • Out-patients are assigned beds
  • Each patient is assigned a primary nurse and a secondary nurse
  • Each patient is assigned a primary doctor.
  • A patient can be seen by multiple doctors
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.