From the diagram below. answer the questions below.

• Technical design - includes screenshots and/or descriptions of all tables, fields, and description of the data contained in the fields (metadata (i.e., field data types), and example data contained with each field)
• At least 8 tables -  each table should have no less than 2 fields and no more than 8 fields
• Entity-relationship diagram, with cardinality - includes showing the nature of relationships between related tables
• A new diagram with 1:1 or 1:M or ..... on it. Screenshots .
•  

* 2 3 4 @ FYS FYE YE YE Diagram 80 N 1:1 1:n 1:1 1:n n:m Patients Patient_id INT Name VARCHAR(45) Age INT Gender VARCHAR(45) Occupation VARCHAR(45) Indexes 0 V 0 Vaccination_campaigns Campaign_id INT Campaign_name VARCHAR(45) Start_date DATE End_date DATE Indexes 0 0 >Target_population VARCHAR(45) Vaccination_appointments Appointment_id INT Patient_id INT Site_id INT Appointment_date DATE Appointement_time TIME Indexes Vaccination_sites Site_id INT Site_name VARCHAR(45) Location VARCHAR(45) Control_info VARCHAR(45) Indexes Vaccines Vaccines_id INT Vaccine_name VARCHAR(45) Manufacturer VARCHAR(45) Dosage INT Description TEXT Indexes Vaccination_effect Effect_id INT > Effect_name VARCHAR(45) >Severity VARCHAR(45) >Description TEXT Indexes Vaccination_records Record_id INT Vaccine_id INT Site_id INT Date_administered DATE Dose_number INT >Patient_id INT Batch_num ber VARCHAR(45) Indexes Vaccination_side_effects V Vaccination_side effect_id INT >Record_id INT Effect_id INT Date_reported DATE >Severity_level VARCHAR(45) Indexes