Page 1 of 2 . Database System, eth Ed. Rob/Coronel / Type ot so s0t Server/ CREA

Question

Page 1 of 2 . Database System, eth Ed. Rob/Coronel / Type ot so s0t Server/ CREATE TABLE DOCTOR DOC ID varchar(51 DOC LNNME varchar (152 DOC FNAME varchar(15) DOC INITIAL varchar(21, DOC SPECIALTY varchar (15) INSERT INTO DOCTOR VALUES29827, SanehezJulio',Dermatol INSERT INTO DOCTOR VALUES32445*,Jorgensen'.Annelise'G.'Neuro ENSERT INTO DOCTOR VALUES133456'Korenski', Anatoly', 'A", "Urology) INSERT NTO DOCTOR VALUES33989,LeGrande','George",Pediatrics' INSERT INTO DOCTOR VALUES ('34409Kashington.Dennis'F.Orthopaedics) INSERT INTO DOCTOR VALUES[ 6221','McPherson . ''Katy','H Dermatology'); INSERT INTO DOCTOR VALUES ('36722. Dreifag', 'Herman',G.'Psychiatey') INSERT INTO DOCTOR VALUES38995Ninh" TrSn'Neurology1 INSERT INTO DOCTOR VALUES40004, Chin', 'Ming,D,Orthopaedics* INSERT INTO DOCTOR VALUES 40028,Feinatein', 'Denise.Gynecology') CREATE TABLE DRUG DRUG CODE varchar (5), DRUG NAME varchar (25), DRUG_PRICE numeric INSERT INTO DRUG VALUES'AF15','Afgapan-15,*25' INSERT INTO DRUG VALUES(AF25,'Afgapan-25, 35' INSERT INTO DRUG VALUES(DRO","Droalene Chloride'.111.89* INSERT INTO DRUG VALUES('DRZDruzocholar Cryptolene18.99' INSERT INTO DRUG VALUES'015'.'Koliabar Oxyhexalene","65.75') INSERT INTO DRIG VALUES&"OLE, Oleander-Drizapan'.123.95 INSERT INTO DROG VALUES('TRYP', 'Tryptolac Heptadimetric','79-45 CREATE TABLE PATIENT PAT NUM varchar (5), PAT TITLE varchar (4), PAT LNAME varchar (151, PAT FNAME varchar (15) PAT INITIAL varchar (1) PAT DOB datetime, PAT AREACODE varchar (3), PAT PHONE varchar (8) INSERT INTO FATIENT VALUES('100','Mr.., 'Kolmycz*, 'George',D 6/15/1942, 615,324 5456') INSERT rNTO PATIENT VALUES ( . 101','Hs.','Lewis", Rhonda','G.,'3/19/2005",'615,,'324-4472.); INSERT INTO PATIENT VALUES(102",'Mr.', 'VanDam', 'Rhett',,'11/14/1958,901, 675-8993'1 INSERT INTO PATIENT VALUES (103', 'Ms. ','Jones','Anne','M', 10/16/31974', *615', 898-3456") i INSERT INTO PATIENT VALUES('104',Mr.'Lange', John", P,11/8/1971', 901','504-4430') INSERT INTO PATIENT VALUES 105,'Mr. ', 'wi1iams', 'Robert', D, 3/14/1975','615', 890- 3220'11 INSERT INTO PATIENT VALUES('106','Mes.', 'Smith', 'Jeanine', 'K','2/12/2003, 615, 324- 7883) INSERT INTO PATIENT VALUES(107', 'Mr.','Diante', 'Jorge' 'D'8/21/1974 INSERT INTO PATIENT VALUES(108,'Mr.','Wiesenbach','Paul''R2/14/1966, *615, 897 4358"); 4,615*,890-4567') INSERT INTO PATIENT VALUES (i09","Mr..,'Smith','George','K', '6/18/1961','901.,'504-3339');

Explanation / Answer

1.
select * from prescriptions;

2.
select * from doctor where DOC_LNAME = 'DR. MINH';

3.
select * from doctor where doc_speciality='dermatology';

4.

select * from patient where pat_areacode='901';

5.
select pat_lname, pat_fname, pat_dob from patient where year(pat_dob)<1945;

6.
select drug_name, max(drug_price) from drug;

7.
select doc_lname from doctor, prescriptions where drug_code='droaene' and doctor.doc_id=prescription.doc_id;

8.
select doc_lname, pat_lname from doctor, prescriptions, patients where drug_code='oleander drizapan' and doctor.doc_id=prescription.doc_id and patients.pat_num=prescription.pat_num;

9.
select lname from prescription, patient where count(prescription.pat_num)>2 and patient.pat_num=prescription.pat_num;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.