Question: Need help designing a database for the hospital form in this picture: This database needs to include - -An ERD in IE notation. --Name all
Need help designing a database for the hospital form in this picture:

This database needs to include-
-An ERD in IE notation. --Name all Relationships, Entities and Attributes. --Specify Cardinality, including one-to-one, one-to-many, many-to-many, optional and mandatory. --Identify the Primary Key, including any composite keys. --Identify Foreign Keys. --Make sure your design is Normalized to the 4th Form.
Also I need help identifying tables such as-
--Identify if tables are Data, Subset, Validation, or Linking/Associative. --Identify if tables are strong or weak --Identify if tables are idon-id dependent.
St. Joseph Medical Center - Emplovee Parking Permit Registration Fo Employee Information Permit A: Office Use Only Permit B: Office Use Only Last First Middle Department Extension Last 4 digits of SS# St. Joseph Medical Center Employee Parking Permit Policy Circle Classification Employee Admin/Manager Physician Volunteer 1. Rearview mirror permit must be displayed on primary or alternate vehicle with control number facing the windshield at all times when parked on campus Primary Vehicle information Make Model Year Lic. Tag # 2. Vehicle must be parked in designated employee parking areas. Altermate Vehicle Infonmation 3. Violation of the policy can result in impoundment of the vehicle at the vehicle owner's risk and expense, parking charges, disciplinary action and/or termination of employment. Make Model Year Lic. Tag # Alternate Vehicle Infonmation 4. Employees are prohibited from parking in the patient/visitor paid parking areas. Employees who enter these parking areas via daily tickets or fail to badge "in and out', in sequence are subject to a non- refundable exit fec of $10.00 Make Model Year Lic. Tag # As a condition of employment, I have read and understand the parking permit policy of St. Joseph Medical Center 5. Lost permit replacement fee $20.00 Employee Signature Date St. Joseph Medical Center - Emplovee Parking Permit Registration Fo Employee Information Permit A: Office Use Only Permit B: Office Use Only Last First Middle Department Extension Last 4 digits of SS# St. Joseph Medical Center Employee Parking Permit Policy Circle Classification Employee Admin/Manager Physician Volunteer 1. Rearview mirror permit must be displayed on primary or alternate vehicle with control number facing the windshield at all times when parked on campus Primary Vehicle information Make Model Year Lic. Tag # 2. Vehicle must be parked in designated employee parking areas. Altermate Vehicle Infonmation 3. Violation of the policy can result in impoundment of the vehicle at the vehicle owner's risk and expense, parking charges, disciplinary action and/or termination of employment. Make Model Year Lic. Tag # Alternate Vehicle Infonmation 4. Employees are prohibited from parking in the patient/visitor paid parking areas. Employees who enter these parking areas via daily tickets or fail to badge "in and out', in sequence are subject to a non- refundable exit fec of $10.00 Make Model Year Lic. Tag # As a condition of employment, I have read and understand the parking permit policy of St. Joseph Medical Center 5. Lost permit replacement fee $20.00 Employee Signature Date
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
