Project #1Hospital DatabaseProject #1 ReportPROJECT # 1HOSPITAL DATABASEDATABASE SYSTEMSPREPARED BYXXYYYE-mail Address0Project #1 ReportProject #1HOSPITAL DATABASE INPUT DATABASEhospital(id, x, y)This relation contains the addresses of the various hospitals in the Lincoln area. There arefive hospitals with IDs 1 through 5.zip(id, x, y)This relation contains the various zip codes and their area within the Lincoln area. Thereare seven zip codes with IDs 1 through 7.pat_add(id, x, y)This relation contains the addresses of the patients admitted in any one of the hospitals inthe Lincoln area. There are 30 patients.pat_info(id, age, place)This relation contains the age of the patients in the Lincoln area.doc_add(id, x, y)This relation contains the addresses of the doctors working in the hospitals in the Lincolnarea. There are 15 doctors.doc_info(id, age, spec, hosp)This relation contains the doctor’s age, his specialty and the hospital where he works. Thespecialties are as follows:1Cardiology2Urology3Gynaecology4Neurology5Radiology6Paediatrics7ENTtemperature(id, x, y)This relation gives the temperature y of a patient id at any given time x in minutes. x canhave values 0 through 1440, and y can have values 90 through 105.low_bp(id, x, y)This relation gives the low blood pressure y of a patient id at any given time x in minutes.x can have values 0 through 1440, and y can have values 50 through 110.1Project #1 Reporthigh_bp(id, x, y)This relation gives the high blood pressure y of a patient id at any given time x inminutes. x can have values 0 through 1440, and y can have values 90 through 160.treat(docid, patid)This relation contains the information as to which doctor treats which patient.SQL QUERIESFollowing are the queries that we have executed successfully.Iconic:For each iconic query provide the following:The iconic query Such as:INTERSECT: Find the address of those doctors who are also patients.Describe the process The output relationSample of basic queryBasic:1. Find the age of the patient whose id is 3.Click [Qs], click SQL – Basic.Enter the following the respective fields.Actual query!Output?Continue with the rest of the answers!!!
View Full Document
Unlocking...