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 ________________________________);

ComputerScienceExpert

(11)

Status NEW Posted 24 May 2017 04:05 AM My Price 8.00

-----------

Attachments

file 1495599526-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer