part 11 question 3,4,5,6,7 please

Part 1 2. Create a Table called INS containing the following: Field name INS code Insurance name Address City State Zipcode Feld properties 5 30 30 2 5 Add the following records to the fable: Code GHI BC AHS description Group Health Insurance Blue Cross American Health System 2. Create a Table called Patients containing information regarding patients in a Hospital Must be from INS table Field Name Code Name Ins company Code Address line / Address line 2 City State Zip Field Property Character 5 Character 30 Character 5 Character 30 Character 30 Character 15 Character 2 Character 5 Add the following records to the table: Code jagazine Name: Frank your last name) Rosi (your last name) Alex your last name Albert (pour last name) Sve your last name) Richard your last name) Ins GHI BC BC BC GHI AHS 3. Create a Table called MDS containing information regarding doctors and dentists: Field Name Code Name Address City State Zip Field Property Character 5 Character 30 Character 30 Character 15 Character 2 Character 5 make up the rest of the data) Code MI 12 M3 M4 MS Name Dr. Anthony Our last name) Dr. Jack (your last name) Dr. Jane your last name) Dr. Louis our last name) Dr. Kate your last name) Create a Table called Medical containing the following: Field name Mp code description Price Field properties 5 30 Numerie with 2 decimal places Add the following records to the table: Code price 2222 3333 4444 5555 6666 7777 8888 description Throat culture Routine blood test Ingrown toenail removal Fill a cavity Dental x-ray Dental cleaning Nose bleed treatment Splinter removal 2.22 3.33 4.44 5.55 6.66 7.77 8.88 5. Create a Table called Treatments containing information regarding treatments received by patients Field name Patient code Md code Mp code Date of treatment Field properties 5 5 5 date 6. You cannot have the same treatment twice in a given date for a specific patient 7. A patient can have the same medical procedure on different days. 8. There are 6 patients. The Patient codes are: P1, P2, P3, P4, P5, P6 9. There are 5 Doctors, The Doctor codes are: MI, M2, M3, M4, M5 For Patient P/ For Patient P2 For Patient P3 For Patient P4 Add 2 treatments from one MD Add 5 treatments from 2 different MDS Add no treatments Add 4 treatments for one MD. Two of the treatments must be the same But on different days Add 5 treatments from 3 different MDS Add I treatment For Patient P5 For Patient P6 Part I7 Create a Query for each of the following questions and print out the result Query I. Print all INS records for State - "NY" Query 2.- Print the cpr (Mp_code) record that has the highest price Ouery 3.-Print the name of the patient that has the most treatments of records in the treatments file) Ouery 4 Print the name of the patient that cost the most money fie sum of all treatment costs was highest) Query 5. Print the name of the patient that did not have treatment 11111 Query 6. - Print the name of the INS company that had to pay the most money, Query 7. Print the name of the MD that prescribed the treatments that cost the most money, Part III - Extra Credit ( 5 points - Web pages connected to the database) 1. Generate the following report for all patients-one report per patient. Name of the patient Address of the patient Date of service name of md car cpt description price Total 2. Generate the following report for all MDs one report per MD Name of MD Address of MD Date of service name of patient cpf cpr-description price EL *** Total This report should be in DATE order- subtotaling after each date. 3. Generate the following report for all CPTs - one report per cpt CPT code and description Date of service name of patient name of MD Price + Total This report should be in md order-subtotaling after each md. 4. Generate the following report for all INSURANCE companies - one report per INS Insurance Company name Insurance Company address r price name of patient name of MD cpt description Date of service LE 3 ***