the table PATIENT (PatientID, PatientEmail, PatientAddress

1. For the table PATIENT (PatientID, PatientEmail, PatientAddress, PatientCity, PalientState, Physician),it is desired to know if PatientEmails are unique, i.e., there are no two patients who share the same email address, since, if this is so, PatientEmail could possibly be a candidate (alternate) key. In the following correlated subquery which was designed to see if PatientEmail are unique, fill in the SELECT and FROM in the lower query.

SELECT P1.PatientEmail

FROM PATIENT P1

WHERE P1.patientEmail IN

(SELECT ________________________
FROM ________________________
WHERE P1.PatientEmail = P2.PatientEmail
AND P1.PatientID <> P2.PatientlD);

2. Insurance Company A has just acquired Insurance Company B, and in Company B’s database there are two tables of interest: PEOPLE and INSURANCEPOLICY. Company A wishes to determine if Company B enforced referential integrity between its PEOPLE and INSURANCE policy tables, and wrote the SQL code below to determine if any policies In PEOPLE had policyIDs which violated referential Integrity, and, if so, the names of the people and the violating policylDs. Fill in the WHERE clause in the inner subquery.

PEOPLE (PersonID, PersonName, PersonPhone, PolicylD)
INSURANCEPOLICY (PolicylD, YearIssued, Amount)

SELECT PersonName, PEOPLE.PolicyID
FROM PEOPLE
WHERE PEOPLE.PolicylD NOT IN

(SELECT INSURANCEPOLICY.PolicyID
FROM INSURANCEPOLICY, PEOPLE
WHERE ________________________________);

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.