Trucking and Hospital Company

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