PLEASE PROVIDE SCREENSHOTS WITH YOUR EXPLANATIONS OR I WILL GIVE A THUMBS DOWN

Question: 1) Insert 6 dummy records into the PHARMACY table (you can use SQL statements or directly type ...

(1 bookmark)

1) Insert 6 dummy records into the PHARMACY table (you can use SQL statements or directly type in the value, you can use unique values of your choosing for the PK )

Try to use actual values of the NPICode from National NPI Number Registry

http://www.npinumberlookup.org/, enter Walgreens into Last Name field and sele ct State as KS to get NPI codes, 1205188281 will be the value for Emporia Walgreens .

2) ) Add values to the FK PharmacyID in PRESCRIPTION (Note that any value you enter must already be present as a PK value in PHARMACY)

3) Insert 6 dummy records int o the CONSULTATION table (you can use SQL statements or directly type in the value, you can use unique values of your choosing for the PK ). Note that PatientID and PhysicianID are FKs and the values you enter here must already be present as PK values in PATIENT and PHYSICIAN respectively (i.e. the referential integrity condition).

4) Insert 6 dummy records into the PRES_DRUG table (you can use SQL statements or directly type in the value, you can use unique values of your choosing for the PK ). Note that y ou have to meet referential integrity conditions.

5) Implement the M : N allergy relationship between PATIENT and DRUG by using PAT_DRUG_ALGY as the junction table . A junction table will have the PKs of the tables they are connecting as FKs in this case PA T_DRUG_ALGY has PatientID ( which is the PK of PRESCRIPTION) and DrugID ( which is the PK of DRUG) as FKs . Use the ALTER TABLE SQL statements to implement PatientID and DrugID as FKs in PAT_DRUG_ALGY .

6) Insert 6 dummy records into the PAT_DRUG_ALGY table (you can use SQL statements or directly type in the value, you can use unique values of your choosing for the PK ). Note that you have to meet referential integrity conditions.

7) Create a NURSE table using the CREATE TABLE SQL statement .

8) Implement the 1 : 1 relationship between NURSE and OFFICE (OfficeID is an FK in NURSE) .

9) Insert 6 dummy records into the NURSE table (you can use SQL statements or directly type in the value, you can use unique values of your choosing for the PK ).

10) Create the junction table NUR_SCH table using the CREATE TABLE SQL statement .

11) I mplement the two FK relationships of the NUR_SCH table .

12) Insert 6 dummy records into the NUR_SCH table (you can use SQL statements or directly type in the value, you can use unique values of your choo sing for the PK ).

13) Create and populate the INGREDIENT table .

14) Create and populate the DRUG_INGDT table .

15) P r o v i d e a n E - R d i a g r a m