Project 1 - Vaccination Records
• The design requires five entities: PATIENT, INSURANCE, VACCINATION, LOCATION and SHOT_IN_ARM, an intersection entity to handle the relationship between PATIENT, VACCINATION, and LOCATION.
Professional quality ERD with the five entities using the ERD style taught in the Oracle Academy.
o Indicators to the left of each field name: # UID, mandatory, o optional
Relationship lines showing
Correct and complete sentences following the ERDish syntax taught in the Oracle Academy curriculum.
Step By Step Answers with Explanation
Entity Relationship Diagram (ERD) for Vaccination Records Database
In designing the Vaccination Records database system, we need to create an Entity Relationship Diagram (ERD) that represents the various entities and their relationships within the system. The ERD will help us understand the structure of the database and how data flows between different components. Below is the ERD for the Vaccination Records database:
- #UID (Unique Patient ID)
- First Name
- Insurance ID
- Location Name
- Vaccination Date
- Lot Number
- Relationship Name: Is Insured By
Explanation: Each patient may or may not have insurance coverage. If they have insurance, it is associated with the patient's record.
Explanation: Patients can receive multiple vaccinations, and each vaccination they receive is recorded in the SHOT_IN_ARM entity.
3. VACCINATION - SHOT_IN_ARM
4. LOCATION - SHOT_IN_ARM
- Cardinality: One Location can have (may have) One or More Shots
- Cardinality: One Vaccine can be provided at (may be provided at) One or More Locations
- Optionality: A vaccine can be available at multiple locations
1. Patient - Insurance Relationship:
- The "Administers" relationship signifies that a particular vaccine can be administered to multiple patients. Each administration is recorded with the vaccination date and lot number.
4. Location - Shot_in_Arm Relationship: