[SOLVED] SQL Homework - Programming

Solving a basic homework in SQL. The homework are related to homework #1 and #2, homework# 1& 2 questions and solutions are attached. All the files are attached.Homework 1
Please create E-R or Enhanced E-R model for the following problem.
This is about database design related to healthcare practices. In reality, the health systems usually have
multiple database systems including Electronic Health Record (EHR), Picture Archiving and
Communication Systems (PACS), Radiology Information Systems (RIS) and more. In this exercise,
let us focus on “Interventional Radiology (IR)” related activities only which has a specific system
(HiiQ, http://hi-iq.com/) to storage and manage IR related data and information.
Now, here is the assignment problem description:
1. In the hospital, there are several IR rooms for IR operations. Each room has an ID (e.g.,
IR1, IR2, Cath1, Cath2, etc.). There are general description of each room about its
equipment and capability (e.g., what types of exams to be scheduled). Each room can be
scheduled with multiple exams. And each IR exam will be scheduled and conducted in
only one IR room.
2. For each exam, we know the encounter number (consider this as the key). We also have
detailed time stamps for the exam activities (e.g., when patient gets on the table, and
when patient is wheeled out the room). For simplicity, we only record the exam start time,
and exam finish time. We can gather the exam duration which can be later used to
calculate the room utilization. Please note some exams will require anesthesia before the
exams start.
3. Now, for simplicity, let’s focus on performing physician only in this homework. For each
physician (MD), we know the ID, name, pager number, phone number, working address.
In addition, we know the specialty (e.g., IR radiologist, neurologist). Each MD is
scheduled with none to multiple IR operations (exams). We assume each exam will have
only one physician (we will not consider MD residence/fellow here).
4. Each patient will have one or multiple IR exams scheduled. For the patient, we know the
patient ID (accession number), name, gender, address. In addition, we consider two types
of patients here: inpatient (IP) and outpatient (OP). For IP, we will record the Bay area
where the patient is transported to and get prepared for the exam. For OP, we will record
the scheduled exam time.
Homework 2
This HW is partially based on HW1. We propose the solution for HW1 is as following:
1. Based on the E-R model provided above, please design the relations (tables) accordingly.
Clearly define your table name, data fields, and primary keys. Also, please specify the
relationship between the tables (foreign key vs. primary key).
E.g., MD (SSN, Attribute 2, Attribute 3…)
2. For this question, you will need to use MySQL. Please write the SQL command to create
tables you identified in question 1 in MySQL.
E.g.,
create table tbldummy (ID Integer, …PRIMARY KEY(ID), FOREIGN KEY
(…)REFERENCES …);
3. For this question, you will need to use MySQL. Due to the availability and sensitivity of
the data, we are only able to provide partial (but most important and relevant) information in
four excel spreadsheets (see attached). Please use the information provided in the excel to
insert the data into the tables. Note for the missing information, you can use dummy data.
4. For this question, you will need to use MySQL. Please write the SQL commands for the
following queries. (Run the commands and submit the screenshots of your query results)
a. The manager is interested in the patient composition. Please create query to get the #
of IP (inpatient) exams and the # of OP (outpatient) exams.
b. The manager is also interested in the number of exams conducted after working
hours. So please create query to get the # of exams done after 5pm per room (IR
Room 1, IR Room 2 and IR Room 3)
c. The third question is the exam duration. For each of the three rooms, please get the
Average, Min, and Max exam durations.
d. The fourth question is related to specialty. The manager is interested in the number of
exams from each specialty. Please write the query to get the number of exams in each
specialty (heart failure, cardiovascular – in short Card, IR, Neuro interventional,
Vascular surgery, Neuro Surgery, Eletro psychologiy). Note you will need to get
information gathered from multiple tables.
e. The manager is now interested in the room allocated for IR specialty only. The last
question is please get the # of “IR” specialty exams in each room.
Homework 2 Solution
This is an individual homework. It is due Oct. 14th 5:00pm. You have 2 weeks to finish the
homework due to the scope of the work. Do allocate your time wisely to make a timely
submission. Please submit it through blackboard.
This HW is partially based on HW1. We propose the solution for HW1 is as following:
1. Based on the E-R model provided above, please design the relations (tables) accordingly.
Clearly define your table name, data fields, and primary keys. Also, please specify the
relationship between the tables (foreign key vs. primary key).
IR Room
Room ID
Equipment
Capability
Exam
Exam ID
Start time
Finish time
MD
Patient
MD ID
Name Pager number
Patient ID
Patient_Schedule Patient ID
Treat
Exam ID
Name
Room ID
Phone number Working address Specialty
Gender
Scheduled exam time
Patient ID
Anesthesia
MD ID
Address
IP_OP
Bay area
2. For this question, you will need to use MySQL. Please write the SQL command to create
tables you identified in question 1 in MySQL.
CREATE TABLE IR_Room (
RoomID VARCHAR(10) PRIMARY KEY NOT NULL,
Equipment VARCHAR(100) NULL,
Capability VARCHAR(200) NULL);
CREATE TABLE Exam (
ExamID INT PRIMARY KEY NOT NULL,
StartTime TIME NULL,
FinishTime TIME NULL,
Anesthesia CHAR(1) NULL,
RoomID VARCHAR(10) NULL,
FOREIGN KEY (RoomID) REFERENCES IR_Room (RoomID));
CREATE TABLE MD (
MDID INT PRIMARY KEY NOT NULL,
Name VARCHAR(50) NULL,
PagerNumber VARCHAR(20) NULL,
PhoneNumber VARCHAR(20) NULL,
WorkingAddress VARCHAR(200) NULL,
Specialty VARCHAR(50) NULL);
CREATE TABLE Patient (
PatientID INT PRIMARY KEY NOT NULL,
Name VARCHAR(50) NULL,
Gender VARCHAR(10) NULL,
Address VARCHAR(200) NULL,
IPOP VARCHAR(10) NOT NULL,
BayArea INT NULL);
CREATE TABLE Patient_Schedule (
PatientID INT NOT NULL,
ScheduledExamTime TIME NOT NULL,
PRIMARY KEY (PatientID, ScheduledExamTime),
FOREIGN KEY (PatientID) REFERENCES Patient (PatientID));
CREATE TABLE Treat (
ExamID INT NOT NULL,
PatientID INT NOT NULL,
MDID INT NOT NULL,
PRIMARY KEY (ExamID, PatientID, MDID),
FOREIGN KEY (ExamID) REFERENCES Exam (ExamID),
FOREIGN KEY (PatientID) REFERENCES Patient (PatientID),
FOREIGN KEY (MDID) REFERENCES MD (MDID));
3. For this question, you will need to use MySQL. Due to the availability and sensitivity of
the data, we are only able to provide partial (but most important and relevant) information in
four excel spreadsheets (see attached). Please use the information provided in the excel to
insert the data into the tables. Note for the missing information, you can use dummy data.
INSERT INTO IR_Room (RoomID) VALUES (‘IR1’);
INSERT INTO IR_Room (RoomID) VALUES (‘IR2’);
INSERT INTO IR_Room (RoomID) VALUES (‘IR3’);
INSERT INTO MD VALUES (1, ‘MD1’, ‘90001’, ‘480710668’, ‘PHOENIX’, ‘Heart Failure’);
INSERT INTO MD VALUES (2, ‘MD2’, ‘90002’, ‘480719369’, ‘PHOENIX’, ‘Heart Failure’);
INSERT INTO MD VALUES (3, ‘MD3’, ‘90003’, ‘480724592’, ‘PHOENIX’, ‘Heart Failure’);
INSERT INTO MD VALUES (4, ‘MD4’, ‘90004’, ‘480726531’, ‘PHOENIX’, ‘Heart Failure’);
INSERT INTO MD VALUES (5, ‘MD5’, ‘90005’, ‘480728388’, ‘PHOENIX’, ‘Heart Failure’);
INSERT INTO MD VALUES (6, ‘MD6’, ‘90006’, ‘480717173’, ‘PHOENIX’, ‘Card’);
INSERT INTO MD VALUES (7, ‘MD7’, ‘90007’, ‘480726723’, ‘PHOENIX’, ‘Card’);
INSERT INTO MD VALUES (8, ‘MD8’, ‘90008’, ‘480724687’, ‘PHOENIX’, ‘Card’);
INSERT INTO MD VALUES (9, ‘MD9’, ‘90009’, ‘480706196’, ‘PHOENIX’, ‘Card’);
INSERT INTO MD VALUES (10, ‘MD10’, ‘90010’, ‘480702515’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (11, ‘MD11’, ‘90011’, ‘480719119’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (12, ‘MD12’, ‘90012’, ‘480705519’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (13, ‘MD13’, ‘90013’, ‘480729618’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (14, ‘MD14’, ‘90014’, ‘480709455’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (15, ‘MD15’, ‘90015’, ‘480717245’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (16, ‘MD16’, ‘90016’, ‘480725188’, ‘PHOENIX’, ‘Neuro IR’);
INSERT INTO MD VALUES (17, ‘MD17’, ‘90017’, ‘480710166’, ‘PHOENIX’, ‘Vascular
surgery’);
INSERT INTO MD VALUES (18, ‘MD18’, ‘90018’, ‘480714475’, ‘PHOENIX’, ‘Vascular
surgery’);
INSERT INTO MD VALUES (19, ‘MD19’, ‘90019’, ‘480708427’, ‘PHOENIX’, ‘Vascular
surgery’);
INSERT INTO MD VALUES (20, ‘MD20’, ‘90020’, ‘480700346’, ‘PHOENIX’, ‘Neuro
surgery’);
INSERT INTO MD VALUES (21, ‘MD21’, ‘90021’, ‘480708453’, ‘PHOENIX’, ‘Neuro
surgery’);
INSERT INTO MD VALUES (22, ‘MD22’, ‘90022’, ‘480717145’, ‘PHOENIX’, ‘Eletro
psychologiy’);
INSERT INTO MD VALUES (23, ‘MD23’, ‘90023’, ‘480728302’, ‘PHOENIX’, ‘Eletro
psychologiy’);
INSERT INTO MD VALUES (24, ‘MD24’, ‘90024’, ‘480707733’, ‘PHOENIX’, ‘Eletro
psychologiy’);
INSERT INTO MD VALUES (25, ‘MD25’, ‘90025’, ‘480708684’, ‘PHOENIX’, ‘Eletro
psychologiy’);
INSERT INTO MD VALUES (26, ‘MD26’, ‘90026’, ‘480726594’, ‘PHOENIX’, ‘Eletro
psychologiy’);
INSERT INTO MD VALUES (27, ‘MD27’, ‘90027’, ‘480718318’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (28, ‘MD28’, ‘90028’, ‘480711336’, ‘PHOENIX’, ‘Neuro IR’);
INSERT INTO MD VALUES (29, ‘MD29’, ‘90029’, ‘480712411’, ‘PHOENIX’, ‘IR’);
INSERT INTO MD VALUES (30, ‘MD30’, ‘90030’, ‘480717248’, ‘PHOENIX’, ‘Eletro
psychologiy’);
INSERT INTO MD VALUES (31, ‘MD31’, ‘90031’, ‘480710599’, ‘PHOENIX’, ‘Card’);
INSERT INTO MD VALUES (32, ‘MD32’, ‘90032’, ‘480701415’, ‘PHOENIX’, ‘Eletro
psychologiy’);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (1, ‘MALE’,
‘Phoenix’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (2, ‘MALE’,
‘Scottsdale’, ‘IP’, 1);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (3, ‘MALE’,
‘Phoenix’, ‘IP’, 2);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (4, ‘MALE’,
‘Scottsdale’, ‘IP’, 2);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (5, ‘MALE’,
‘Phoenix’, ‘IP’, 3);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (6, ‘MALE’,
‘Scottsdale’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (7, ‘MALE’,
‘Phoenix’, ‘IP’, 3);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (8, ‘MALE’,
‘Scottsdale’, ‘IP’, 1);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (9, ‘MALE’,
‘Phoenix’, ‘IP’, 2);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (10,
‘MALE’, ‘Scottsdale’, ‘IP’, 1);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (11,
‘MALE’, ‘Phoenix’, ‘IP’, 1);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (12,
‘MALE’, ‘Scottsdale’, ‘IP’, 5);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (13,
‘MALE’, ‘Phoenix’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (14,
‘MALE’, ‘Scottsdale’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (15,
‘MALE’, ‘Phoenix’, ‘IP’, 5);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (16,
‘MALE’, ‘Scottsdale’, ‘IP’, 3);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (17,
‘MALE’, ‘Phoenix’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (18,
‘MALE’, ‘Scottsdale’, ‘IP’, 2);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (19,
‘MALE’, ‘Phoenix’, ‘IP’, 5);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (20,
‘MALE’, ‘Scottsdale’, ‘IP’, 2);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (21,
‘MALE’, ‘Phoenix’, ‘IP’, 5);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (22,
‘MALE’, ‘Scottsdale’, ‘IP’, 5);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (23,
‘MALE’, ‘Phoenix’, ‘IP’, 3);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (24,
‘MALE’, ‘Scottsdale’, ‘IP’, 5);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (25,
‘MALE’, ‘Tempe’, ‘IP’, 1);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (26,
‘FEMALE’, ‘Mesa’, ‘IP’, 1);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (27,
‘FEMALE’, ‘Tempe’, ‘IP’, 3);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (28,
‘FEMALE’, ‘Mesa’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (29,
‘FEMALE’, ‘Tempe’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (30,
‘FEMALE’, ‘Mesa’, ‘IP’, 4);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (31,
‘FEMALE’, ‘Tempe’, ‘IP’, 5);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (32,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (33,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (34,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (35,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (36,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (37,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (38,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (39,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (40,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (41,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (42,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (43,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (44,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (45,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (46,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (47,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (48,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (49,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (50,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (51,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (52,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (53,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (54,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (55,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (56,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (57,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (58,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (59,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (60,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (61,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (62,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (63,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (64,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (65,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (66,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (67,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (68,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (69,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (70,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (71,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (72,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (73,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (74,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (75,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (76,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (77,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (78,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (79,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (80,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (81,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (82,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (83,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (84,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (85,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (86,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (87,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (88,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (89,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (90,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (91,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (92,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (93,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (94,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (95,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (96,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (97,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (98,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (99,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (100,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (101,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (102,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (103,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (104,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (105,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (106,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (107,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (108,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (109,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (110,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (111,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (112,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (113,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (114,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (115,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (116,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (117,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (118,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (119,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (120,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (121,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (122,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (123,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (124,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (125,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (126,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (127,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (128,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (129,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (130,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (131,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (132,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (133,
‘FEMALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (134,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (135,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (136,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (137,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (138,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (139,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (140,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (141,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (142,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (143,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (144,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (145,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (146,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (147,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (148,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (149,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (150,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (151,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (152,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (153,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (154,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (155,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (156,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (157,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (158,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (159,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (160,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (161,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (162,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (163,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (164,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (165,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (166,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (167,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (168,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (169,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (170,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (171,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (172,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (173,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (174,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (175,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (176,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (177,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (178,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (179,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (180,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (181,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (182,
‘FEMALE’, ‘Mesa’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (183,
‘MALE’, ‘Tempe’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (184,
‘FEMALE’, ‘Chandler’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (185,
‘MALE’, ‘Chandler’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (186,
‘FEMALE’, ‘Chandler’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (187,
‘MALE’, ‘Chandler’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (188,
‘FEMALE’, ‘Chandler’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (189,
‘MALE’, ‘Chandler’, ‘OP’, NULL);
INSERT INTO Patient (PatientID, Gender, Address, IPOP, BayArea) VALUES (190,
‘MALE’, ‘Chandler’, ‘OP’, NULL);
INSERT INTO Patient_Schedule VALUES (32, ‘4:06:19′);
INSERT INTO Patient_Schedule VALUES (33, ’12:32:57′);
INSERT INTO Patient_Schedule VALUES (34, ’14:52:49’);
INSERT INTO Patient_Schedule VALUES (35, ‘3:45:30′);
INSERT INTO Patient_Schedule VALUES (36, ’12:32:12′);
INSERT INTO Patient_Schedule VALUES (37, ’13:05:12′);
INSERT INTO Patient_Schedule VALUES (38, ’15:11:07′);
INSERT INTO Patient_Schedule VALUES (39, ’15:22:07’);
INSERT INTO Patient_Schedule VALUES (40, ‘4:53:38’);
INSERT INTO Patient_Schedule VALUES (41, ‘8:20:13′);
INSERT INTO Patient_Schedule VALUES (42, ’21:47:33′);
INSERT INTO Patient_Schedule VALUES (43, ’17:48:13′);
INSERT INTO Patient_Schedule VALUES (44, ’16:13:18′);
INSERT INTO Patient_Schedule VALUES (45, ’15:43:19′);
INSERT INTO Patient_Schedule VALUES (46, ’13:53:48′);
INSERT INTO Patient_Schedule VALUES (47, ’18:52:03’);
INSERT INTO Patient_Schedule VALUES (48, ‘7:20:03’);
INSERT INTO Patient_Schedule VALUES (49, ‘9:51:17′);
INSERT INTO Patient_Schedule VALUES (50, ’19:13:02′);
INSERT INTO Patient_Schedule VALUES (51, ’11:42:37′);
INSERT INTO Patient_Schedule VALUES (52, ’20:45:11’);
INSERT INTO Patient_Schedule VALUES (53, ‘1:41:57′);
INSERT INTO Patient_Schedule VALUES (54, ’21:09:25’);
INSERT INTO Patient_Schedule VALUES (55, ‘3:55:10’);
INSERT INTO Patient_Schedule VALUES (56, ‘4:30:25’);
INSERT INTO Patient_Schedule VALUES (57, ‘1:58:14’);
INSERT INTO Patient_Schedule VALUES (58, ‘4:58:55’);
INSERT INTO Patient_Schedule VALUES (59, ‘5:37:07′);
INSERT INTO Patient_Schedule VALUES (60, ’10:29:46’);
INSERT INTO Patient_Schedule VALUES (61, ‘1:36:18′);
INSERT INTO Patient_Schedule VALUES (62, ’12:18:49′);
INSERT INTO Patient_Schedule VALUES (63, ’14:28:34′);
INSERT INTO Patient_Schedule VALUES (64, ’16:50:57’);
INSERT INTO Patient_Schedule VALUES (65, ‘6:07:43′);
INSERT INTO Patient_Schedule VALUES (66, ’15:03:39′);
INSERT INTO Patient_Schedule VALUES (67, ’10:23:20′);
INSERT INTO Patient_Schedule VALUES (68, ’16:12:32′);
INSERT INTO Patient_Schedule VALUES (69, ’23:05:42′);
INSERT INTO Patient_Schedule VALUES (70, ’20:33:12’);
INSERT INTO Patient_Schedule VALUES (71, ‘6:38:00′);
INSERT INTO Patient_Schedule VALUES (72, ’18:00:34′);
INSERT INTO Patient_Schedule VALUES (73, ’23:15:49′);
INSERT INTO Patient_Schedule VALUES (74, ’10:57:41’);
INSERT INTO Patient_Schedule VALUES (75, ‘4:59:53′);
INSERT INTO Patient_Schedule VALUES (76, ’14:40:06’);
INSERT INTO Patient_Schedule VALUES (77, ‘6:12:30’);
INSERT INTO Patient_Schedule VALUES (78, ‘2:34:39′);
INSERT INTO Patient_Schedule VALUES (79, ’15:18:56’);
INSERT INTO Patient_Schedule VALUES (80, ‘3:08:08’);
INSERT INTO Patient_Schedule VALUES (81, ‘3:00:05’);
INSERT INTO Patient_Schedule VALUES (82, ‘7:29:50’);
INSERT INTO Patient_Schedule VALUES (83, ‘2:29:54’);
INSERT INTO Patient_Schedule VALUES (84, ‘5:47:21’);
INSERT INTO Patient_Schedule VALUES (85, ‘7:40:55’);
INSERT INTO Patient_Schedule VALUES (86, ‘5:45:56’);
INSERT INTO Patient_Schedule VALUES (87, ‘8:52:21′);
INSERT INTO Patient_Schedule VALUES (88, ’19:43:35’);
INSERT INTO Patient_Schedule VALUES (89, ‘5:09:29′);
INSERT INTO Patient_Schedule VALUES (90, ’19:27:34′);
INSERT INTO Patient_Schedule VALUES (91, ’10:55:27’);
INSERT INTO Patient_Schedule VALUES (92, ‘8:02:13′);
INSERT INTO Patient_Schedule VALUES (93, ’18:27:39’);
INSERT INTO Patient_Schedule VALUES (94, ‘3:27:22′);
INSERT INTO Patient_Schedule VALUES (95, ’12:54:56’);
INSERT INTO Patient_Schedule VALUES (96, ‘5:33:33′);
INSERT INTO Patient_Schedule VALUES (97, ’22:59:26′);
INSERT INTO Patient_Schedule VALUES (98, ’17:29:43′);
INSERT INTO Patient_Schedule VALUES (99, ’11:33:27’);
INSERT INTO Patient_Schedule VALUES (100, ‘1:19:54’);
INSERT INTO Patient_Schedule VALUES (101, ‘7:50:40′);
INSERT INTO Patient_Schedule VALUES (102, ’23:52:13′);
INSERT INTO Patient_Schedule VALUES (103, ’12:05:49′);
INSERT INTO Patient_Schedule VALUES (104, ’19:49:09′);
INSERT INTO Patient_Schedule VALUES (105, ’17:14:58′);
INSERT INTO Patient_Schedule VALUES (106, ’20:32:55’);
INSERT INTO Patient_Schedule VALUES (107, ‘2:57:50′);
INSERT INTO Patient_Schedule VALUES (108, ’12:20:31′);
INSERT INTO Patient_Schedule VALUES (109, ’10:00:50’);
INSERT INTO Patient_Schedule VALUES (110, ‘4:16:26′);
INSERT INTO Patient_Schedule VALUES (111, ’15:40:42’);
INSERT INTO Patient_Schedule VALUES (112, ‘2:40:53’);
INSERT INTO Patient_Schedule VALUES (113, ‘9:08:49’);
INSERT INTO Patient_Schedule VALUES (114, ‘3:17:03′);
INSERT INTO Patient_Schedule VALUES (115, ’11:52:58’);
INSERT INTO Patient_Schedule VALUES (116, ‘3:36:44’);
INSERT INTO Patient_Schedule VALUES (117, ‘5:47:15′);
INSERT INTO Patient_Schedule VALUES (118, ’21:23:38′);
INSERT INTO Patient_Schedule VALUES (119, ’12:40:12’);
INSERT INTO Patient_Schedule VALUES (120, ‘1:39:57’);
INSERT INTO Patient_Schedule VALUES (121, ‘5:22:28′);
INSERT INTO Patient_Schedule VALUES (122, ’22:53:27’);
INSERT INTO Patient_Schedule VALUES (123, ‘7:42:43′);
INSERT INTO Patient_Schedule VALUES (124, ’14:45:25’);
INSERT INTO Patient_Schedule VALUES (125, ‘1:09:32′);
INSERT INTO Patient_Schedule VALUES (126, ’17:49:45’);
INSERT INTO Patient_Schedule VALUES (127, ‘6:01:34′);
INSERT INTO Patient_Schedule VALUES (128, ’15:39:13′);
INSERT INTO Patient_Schedule VALUES (129, ’17:48:50′);
INSERT INTO Patient_Schedule VALUES (130, ’23:42:32′);
INSERT INTO Patient_Schedule VALUES (131, ’12:04:02’);
INSERT INTO Patient_Schedule VALUES (132, ‘7:11:28’);
INSERT INTO Patient_Schedule VALUES (133, ‘7:33:45′);
INSERT INTO Patient_Schedule VALUES (134, ’12:27:14′);
INSERT INTO Patient_Schedule VALUES (135, ’21:20:51′);
INSERT INTO Patient_Schedule VALUES (136, ’13:45:03’);
INSERT INTO Patient_Schedule VALUES (137, ‘5:31:45′);
INSERT INTO Patient_Schedule VALUES (138, ’19:12:17′);
INSERT INTO Patient_Schedule VALUES (139, ’12:33:05’);
INSERT INTO Patient_Schedule VALUES (140, ‘5:34:57’);
INSERT INTO Patient_Schedule VALUES (141, ‘9:09:45′);
INSERT INTO Patient_Schedule VALUES (142, ’18:26:32’);
INSERT INTO Patient_Schedule VALUES (143, ‘7:02:47’);
INSERT INTO Patient_Schedule VALUES (144, ‘7:49:27′);
INSERT INTO Patient_Schedule VALUES (145, ’20:19:36′);
INSERT INTO Patient_Schedule VALUES (146, ’14:31:42’);
INSERT INTO Patient_Schedule VALUES (147, ‘3:23:40’);
INSERT INTO Patient_Schedule VALUES (148, ‘1:17:49′);
INSERT INTO Patient_Schedule VALUES (149, ’12:38:59′);
INSERT INTO Patient_Schedule VALUES (150, ’19:07:20′);
INSERT INTO Patient_Schedule VALUES (151, ’14:37:34’);
INSERT INTO Patient_Schedule VALUES (152, ‘3:58:19′);
INSERT INTO Patient_Schedule VALUES (153, ’16:52:03′);
INSERT INTO Patient_Schedule VALUES (154, ’22:11:46′);
INSERT INTO Patient_Schedule VALUES (155, ’11:35:44′);
INSERT INTO Patient_Schedule VALUES (156, ’10:25:29′);
INSERT INTO Patient_Schedule VALUES (157, ’15:02:01′);
INSERT INTO Patient_Schedule VALUES (158, ’13:00:55′);
INSERT INTO Patient_Schedule VALUES (159, ’19:36:24′);
INSERT INTO Patient_Schedule VALUES (160, ’22:46:51′);
INSERT INTO Patient_Schedule VALUES (161, ’15:11:57’);
INSERT INTO Patient_Schedule VALUES (162, ‘8:46:43’);
INSERT INTO Patient_Schedule VALUES (163, ‘6:46:12′);
INSERT INTO Patient_Schedule VALUES (164, ’12:39:47′);
INSERT INTO Patient_Schedule VALUES (165, ’15:49:07′);
INSERT INTO Patient_Schedule VALUES (166, ’13:52:21′);
INSERT INTO Patient_Schedule VALUES (167, ’13:24:28’);
INSERT INTO Patient_Schedule VALUES (168, ‘2:46:40′);
INSERT INTO Patient_Schedule VALUES (169, ’14:24:52′);
INSERT INTO Patient_Schedule VALUES (170, ’22:48:16’);
INSERT INTO Patient_Schedule VALUES (171, ‘5:53:01′);
INSERT INTO Patient_Schedule VALUES (172, ’10:52:04′);
INSERT INTO Patient_Schedule VALUES (173, ’18:33:00’);
INSERT INTO Patient_Schedule VALUES (174, ‘5:36:53′);
INSERT INTO Patient_Schedule VALUES (175, ’21:28:03′);
INSERT INTO Patient_Schedule VALUES (176, ’16:52:31’);
INSERT INTO Patient_Schedule VALUES (177, ‘9:22:09’);
INSERT INTO Patient_Schedule VALUES (178, ‘9:11:31′);
INSERT INTO Patient_Schedule VALUES (179, ’12:45:55′);
INSERT INTO Patient_Schedule VALUES (180, ’18:57:33’);
INSERT INTO Patient_Schedule VALUES (181, ‘6:21:33′);
INSERT INTO Patient_Schedule VALUES (182, ’21:02:53′);
INSERT INTO Patient_Schedule VALUES (183, ’13:53:28′);
INSERT INTO Patient_Schedule VALUES (184, ’22:33:03’);
INSERT INTO Patient_Schedule VALUES (185, ‘9:04:00′);
INSERT INTO Patient_Schedule VALUES (186, ’13:30:43′);
INSERT INTO Patient_Schedule VALUES (187, ’10:24:13′);
INSERT INTO Patient_Schedule VALUES (188, ’17:01:36′);
INSERT INTO Patient_Schedule VALUES (189, ’15:13:04′);
INSERT INTO Patient_Schedule VALUES (190, ’20:12:23′);
INSERT INTO Exam VALUES (1, ’23:37:26′, ’00:19:47’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (2, ’08:25:05′, ’08:49:40’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (3, ’09:10:04′, ’09:50:36’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (4, ’10:09:45′, ’10:28:29’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (5, ’08:41:17′, ’12:07:42’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (6, ’12:28:09′, ’12:58:43’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (7, ’13:13:43′, ’13:29:47’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (8, ’12:49:35′, ’13:38:51’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (9, ’13:54:27′, ’14:24:24’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (10, ’15:15:43′, ’15:56:41’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (11, ’14:30:46′, ’17:13:30’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (12, ’16:01:49′, ’16:42:17’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (13, ’18:06:46′, ’18:39:29’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (14, ’08:32:11′, ’09:12:45’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (15, ’09:04:41′, ’09:45:58’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (16, ’08:19:03′, ’09:50:48’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (17, ’10:15:36′, ’10:22:49’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (18, ’10:00:56′, ’10:55:34’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (19, ’10:38:39′, ’11:26:17’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (20, ’11:00:13′, ’12:30:36’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (21, ’13:05:17′, ’14:10:58’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (22, ’14:03:26′, ’14:10:38’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (23, ’14:05:19′, ’16:25:32’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (24, ’15:00:29′, ’15:24:05’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (25, ’15:14:05′, ’15:45:56’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (26, ’16:09:11′, ’16:32:27’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (27, ’17:28:59′, ’18:11:43’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (28, ’16:56:02′, ’18:45:11’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (29, ’08:48:17′, ’09:01:28’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (30, ’08:27:54′, ’08:56:27’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (31, ’09:39:29′, ’10:09:11’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (32, ’09:12:50′, ’10:36:00’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (33, ’11:37:31′, ’12:00:32’, ‘Y’, ‘IR1′);
INSERT INTO Exam VALUES (34, ’12:35:12′, ’13:38:24’, ‘Y’, ‘IR2′);
INSERT INTO Exam VALUES (35, ’14:37:51′, ’15:09:38’, ‘Y’, ‘IR2′);
INSERT INTO Exam VALUES (36, ’14:10:34′, ’15:17:27’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (37, ’15:29:14′, ’16:09:31’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (38, ’16:07:45′, ’16:46:31’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (39, ’08:31:00′, ’08:58:53’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (40, ’08:48:39′, ’09:30:57’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (41, ’08:42:58′, ’09:16:28’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (42, ’10:06:30′, ’10:32:03’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (43, ’10:40:09′, ’11:50:07’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (44, ’11:41:48′, ’12:12:54’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (45, ’11:54:26′, ’12:51:33’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (46, ’13:09:19′, ’13:22:31’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (47, ’13:40:55′, ’14:34:14’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (48, ’15:12:33′, ’15:37:16’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (49, ’15:18:05′, ’15:37:11’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (50, ’15:36:38′, ’16:16:51’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (51, ’16:07:47′, ’16:44:59’, ‘Y’, ‘IR2′);
INSERT INTO Exam VALUES (52, ’19:47:07′, ’20:19:52’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (53, ’14:13:05′, ’15:00:19’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (54, ’08:57:16′, ’10:46:35’, ‘Y’, ‘IR1′);
INSERT INTO Exam VALUES (55, ’10:58:05′, ’11:23:14’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (56, ’11:41:03′, ’12:04:36’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (57, ’12:21:20′, ’13:46:13’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (58, ’13:36:58′, ’14:21:47’, ‘Y’, ‘IR2′);
INSERT INTO Exam VALUES (59, ’14:08:45′, ’15:03:06’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (60, ’15:27:55′, ’17:39:55’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (61, ’13:47:16′, ’17:19:30’, ‘Y’, ‘IR1′);
INSERT INTO Exam VALUES (62, ’16:19:58′, ’17:23:48’, ‘Y’, ‘IR3′);
INSERT INTO Exam VALUES (63, ’08:30:10′, ’09:20:08’, ‘Y’, ‘IR1′);
INSERT INTO Exam VALUES (64, ’08:11:39′, ’09:11:59’, ‘Y’, ‘IR2′);
INSERT INTO Exam VALUES (65, ’09:20:05′, ’09:46:38’, ‘Y’, ‘IR3′);
INSERT INTO Exam VALUES (66, ’11:08:28′, ’11:39:09’, ‘Y’, ‘IR1′);
INSERT INTO Exam VALUES (67, ’11:28:49′, ’12:18:47’, ‘Y’, ‘IR2′);
INSERT INTO Exam VALUES (68, ’12:29:18′, ’12:49:38’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (69, ’13:21:36′, ’14:06:32’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (70, ’14:22:10′, ’15:17:17’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (71, ’15:16:21′, ’15:49:23’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (72, ’17:10:59′, ’17:32:38’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (73, ’08:29:22′, ’08:52:20’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (74, ’08:25:13′, ’09:22:46’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (75, ’09:38:24′, ’10:01:02’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (76, ’09:44:47′, ’10:49:46’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (77, ’10:40:05′, ’11:22:59’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (78, ’11:27:15′, ’11:58:22’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (79, ’11:46:30′, ’12:16:40’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (80, ’13:33:43′, ’14:01:23’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (81, ’13:30:46′, ’14:11:15’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (82, ’13:26:42′, ’14:54:53’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (83, ’15:44:26′, ’16:42:34’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (84, ’14:58:50′, ’16:58:07’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (85, ’08:18:02′, ’08:42:33’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (86, ’09:33:17′, ’10:35:24’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (87, ’10:59:15′, ’11:46:39’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (88, ’08:50:02′, ’12:28:32’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (89, ’13:42:43′, ’14:01:10’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (90, ’12:18:45′, ’14:40:59’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (91, ’13:53:03′, ’14:38:40’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (92, ’14:52:44′, ’15:21:06’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (93, ’15:18:07′, ’16:55:12’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (94, ’08:27:27′, ’08:49:10’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (95, ’09:30:43′, ’09:55:24’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (96, ’09:47:57′, ’10:16:58’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (97, ’11:10:06′, ’11:56:55’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (98, ’10:05:48′, ’13:01:54’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (99, ’13:31:26′, ’14:06:10’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (100, ’14:15:40′, ’15:00:40’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (101, ’15:35:05′, ’15:59:19’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (102, ’16:03:16′, ’16:53:51’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (103, ’16:14:13′, ’16:43:51’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (104, ’14:10:31′, ’18:20:00’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (105, ’10:46:46′, ’11:11:55’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (106, ’08:37:08′, ’09:13:39’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (107, ’10:01:08′, ’10:27:09’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (108, ’10:53:39′, ’11:16:42’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (109, ’10:09:48′, ’12:56:12’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (110, ’08:59:10′, ’11:36:41’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (111, ’11:41:58′, ’11:57:33’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (112, ’12:30:28′, ’13:15:12’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (113, ’13:35:33′, ’13:59:14’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (114, ’12:30:28′, ’13:54:03’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (115, ’14:39:08′, ’15:17:16’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (116, ’15:40:00′, ’16:14:11’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (117, ’14:00:52′, ’15:17:01’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (118, ’08:29:11′, ’08:51:02’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (119, ’09:20:57′, ’10:01:49’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (120, ’10:05:29′, ’11:34:32’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (121, ’11:46:49′, ’12:11:47’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (122, ’14:07:22′, ’14:28:36’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (123, ’13:19:50′, ’14:08:59’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (124, ’15:06:43′, ’16:39:26’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (125, ’15:09:29′, ’15:42:34’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (126, ’15:09:35′, ’15:42:39’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (127, ’15:05:48′, ’16:39:31’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (128, ’21:48:06′, ’22:46:10’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (129, ’08:38:10′, ’09:49:12’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (130, ’08:22:38′, ’09:43:38’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (131, ’09:28:05′, ’10:11:19’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (132, ’10:52:42′, ’12:27:36’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (133, ’13:14:24′, ’13:44:46’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (134, ’14:22:17′, ’15:01:52’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (135, ’14:09:32′, ’15:08:06’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (136, ’14:44:38′, ’15:40:39’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (137, ’14:09:36′, ’15:08:10’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (138, ’15:46:24′, ’16:13:47’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (139, ’08:26:35′, ’09:36:26’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (140, ’09:16:53′, ’09:42:21’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (141, ’08:35:58′, ’10:07:57’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (142, ’11:34:30′, ’12:07:23’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (143, ’11:24:26′, ’12:24:01’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (144, ’12:40:12′, ’13:10:59’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (145, ’13:35:55′, ’13:53:21’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (146, ’14:19:37′, ’14:35:56’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (147, ’14:57:07′, ’15:32:44’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (148, ’15:12:34′, ’15:38:56’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (149, ’09:47:27′, ’10:58:54’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (150, ’08:53:39′, ’09:33:01’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (151, ’10:13:57′, ’10:44:30’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (152, ’09:30:33′, ’11:26:29’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (153, ’12:05:19′, ’13:01:44’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (154, ’12:06:00′, ’12:48:01’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (155, ’13:33:03′, ’14:00:14’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (156, ’13:59:06′, ’14:34:28’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (157, ’14:32:38′, ’15:23:21’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (158, ’17:58:10′, ’19:19:45’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (159, ’17:12:12′, ’17:39:43’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (160, ’18:22:05′, ’19:31:51’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (161, ’09:11:01′, ’09:29:34’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (162, ’09:59:48′, ’10:23:39’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (163, ’08:58:31′, ’10:53:40’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (164, ’10:34:35′, ’10:53:35’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (165, ’11:08:00′, ’11:25:30’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (166, ’13:58:53′, ’14:34:32’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (167, ’15:10:54′, ’15:47:00’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (168, ’15:09:27′, ’18:06:50’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (169, ’08:55:43′, ’12:41:41’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (170, ’11:03:10′, ’13:28:29’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (171, ’14:16:01′, ’15:33:12’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (172, ’15:09:42′, ’16:24:42’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (173, ’09:02:47′, ’09:48:51’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (174, ’09:53:56′, ’10:20:29’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (175, ’10:27:57′, ’11:15:56’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (176, ’10:55:08′, ’11:33:32’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (177, ’13:27:35′, ’13:53:47’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (178, ’14:07:37′, ’15:28:47’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (179, ’08:21:58′, ’08:50:37’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (180, ’08:26:57′, ’09:56:45’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (181, ’09:57:19′, ’10:19:01’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (182, ’09:53:42′, ’10:35:12’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (183, ’10:33:08′, ’10:58:03’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (184, ’12:34:23′, ’12:54:51’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (185, ’11:23:45′, ’12:51:40’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (186, ’12:19:52′, ’12:34:49’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (187, ’13:39:09′, ’14:16:34’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (188, ’14:43:08′, ’16:37:24’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (189, ’16:01:24′, ’16:56:41’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (190, ’16:11:43′, ’16:37:47’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (191, ’16:48:50′, ’17:09:45’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (192, ’17:42:32′, ’18:43:06’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (193, ’08:26:00′, ’09:18:17’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (194, ’09:44:47′, ’10:23:18’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (195, ’10:02:33′, ’12:00:21’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (196, ’12:41:07′, ’12:56:17’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (197, ’13:59:28′, ’14:20:26’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (198, ’15:04:51′, ’18:15:42’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (199, ’14:57:17′, ’15:33:03’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (200, ’18:11:27′, ’20:52:17’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (201, ’22:37:03′, ’00:34:19’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (202, ’08:21:35′, ’10:09:06’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (203, ’10:05:57′, ’10:30:36’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (204, ’08:46:05′, ’09:26:22’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (205, ’11:10:04′, ’11:30:35’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (206, ’12:09:04′, ’13:27:20’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (207, ’14:11:39′, ’15:15:55’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (208, ’14:44:38′, ’15:01:20’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (209, ’15:19:43′, ’15:45:42’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (210, ’16:00:39′, ’17:01:59’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (211, ’16:19:58′, ’17:15:00’, ‘N’, ‘IR2′);
INSERT INTO Exam VALUES (212, ’17:20:07′, ’17:54:04’, ‘N’, ‘IR3′);
INSERT INTO Exam VALUES (213, ’16:40:58′, ’19:39:46’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (214, ’08:08:29′, ’08:34:56’, ‘N’, ‘IR1′);
INSERT INTO Exam VALUES (215, ’08:45:06′, ’09:03:25’, ‘N’, ‘IR3′);
INSERT INTO Treat VALUES(1, 109, 4);
INSERT INTO Treat VALUES(2, 35, 4);
INSERT INTO Treat VALUES(3, 108, 30);
INSERT INTO Treat VALUES(4, 46, 28);
INSERT INTO Treat VALUES(5, 163, 24);
INSERT INTO Treat VALUES(6, 75, 19);
INSERT INTO Treat VALUES(7, 43, 15);
INSERT INTO Treat VALUES(8, 57, 13);
INSERT INTO Treat VALUES(9, 77, 23);
INSERT INTO Treat VALUES(10, 140, 17);
INSERT INTO Treat VALUES(11, 160, 27);
INSERT INTO Treat VALUES(12, 141, 16);
INSERT INTO Treat VALUES(13, 45, 1);
INSERT INTO Treat VALUES(14, 148, 25);
INSERT INTO Treat VALUES(15, 32, 23);
INSERT INTO Treat VALUES(16, 159, 17);
INSERT INTO Treat VALUES(17, 162, 16);
INSERT INTO Treat VALUES(18, 123, 27);
INSERT INTO Treat VALUES(19, 74, 12);
INSERT INTO Treat VALUES(20, 66, 22);
INSERT INTO Treat VALUES(21, 57, 18);
INSERT INTO Treat VALUES(22, 77, 29);
INSERT INTO Treat VALUES(23, 119, 2);
INSERT INTO Treat VALUES(24, 53, 13);
INSERT INTO Treat VALUES(25, 124, 17);
INSERT INTO Treat VALUES(26, 167, 15);
INSERT INTO Treat VALUES(27, 85, 5);
INSERT INTO Treat VALUES(28, 155, 16);
INSERT INTO Treat VALUES(29, 104, 10);
INSERT INTO Treat VALUES(30, 160, 6);
INSERT INTO Treat VALUES(31, 23, 14);
INSERT INTO Treat VALUES(32, 41, 20);
INSERT INTO Treat VALUES(33, 65, 7);
INSERT INTO Treat VALUES(34, 76, 17);
INSERT INTO Treat VALUES(35, 13, 1);
INSERT INTO Treat VALUES(36, 59, 8);
INSERT INTO Treat VALUES(37, 139, 12);
INSERT INTO Treat VALUES(38, 94, 10);
INSERT INTO Treat VALUES(39, 22, 7);
INSERT INTO Treat VALUES(40, 166, 22);
INSERT INTO Treat VALUES(41, 2, 19);
INSERT INTO Treat VALUES(42, 139, 24);
INSERT INTO Treat VALUES(43, 30, 29);
INSERT INTO Treat VALUES(44, 164, 12);
INSERT INTO Treat VALUES(45, 4, 26);
INSERT INTO Treat VALUES(46, 60, 22);
INSERT INTO Treat VALUES(47, 105, 26);
INSERT INTO Treat VALUES(48, 98, 27);
INSERT INTO Treat VALUES(49, 26, 20);
INSERT INTO Treat VALUES(50, 31, 18);
INSERT INTO Treat VALUES(51, 76, 23);
INSERT INTO Treat VALUES(52, 120, 7);
INSERT INTO Treat VALUES(53, 16, 30);
INSERT INTO Treat VALUES(54, 169, 6);
INSERT INTO Treat VALUES(55, 58, 29);
INSERT INTO Treat VALUES(56, 60, 19);
INSERT INTO Treat VALUES(57, 13, 12);
INSERT INTO Treat VALUES(58, 123, 29);
INSERT INTO Treat VALUES(59, 8, 8);
INSERT INTO Treat VALUES(60, 99, 30);
INSERT INTO Treat VALUES(61, 85, 9);
INSERT INTO Treat VALUES(62, 54, 19);
INSERT INTO Treat VALUES(63, 175, 29);
INSERT INTO Treat VALUES(64, 151, 6);
INSERT INTO Treat VALUES(65, 16, 22);
INSERT INTO Treat VALUES(66, 113, 14);
INSERT INTO Treat VALUES(67, 154, 27);
INSERT INTO Treat VALUES(68, 52, 25);
INSERT INTO Treat VALUES(69, 20, 22);
INSERT INTO Treat VALUES(70, 93, 11);
INSERT INTO Treat VALUES(71, 157, 26);
INSERT INTO Treat VALUES(72, 54, 4);
INSERT INTO Treat VALUES(73, 140, 15);
INSERT INTO Treat VALUES(74, 135, 19);
INSERT INTO Treat VALUES(75, 163, 1);
INSERT INTO Treat VALUES(76, 171, 3);
INSERT INTO Treat VALUES(77, 122, 29);
INSERT INTO Treat VALUES(78, 1, 22);
INSERT INTO Treat VALUES(79, 179, 15);
INSERT INTO Treat VALUES(80, 19, 6);
INSERT INTO Treat VALUES(81, 152, 17);
INSERT INTO Treat VALUES(82, 16, 1);
INSERT INTO Treat VALUES(83, 172, 10);
INSERT INTO Treat VALUES(84, 76, 14);
INSERT INTO Treat VALUES(85, 80, 9);
INSERT INTO Treat VALUES(86, 41, 21);
INSERT INTO Treat VALUES(87, 152, 13);
INSERT INTO Treat VALUES(88, 60, 2);
INSERT INTO Treat VALUES(89, 87, 20);
INSERT INTO Treat VALUES(90, 44, 26);
INSERT INTO Treat VALUES(91, 138, 8);
INSERT INTO Treat VALUES(92, 71, 22);
INSERT INTO Treat VALUES(93, 7, 15);
INSERT INTO Treat VALUES(94, 164, 26);
INSERT INTO Treat VALUES(95, 71, 21);
INSERT INTO Treat VALUES(96, 120, 5);
INSERT INTO Treat VALUES(97, 46, 13);
INSERT INTO Treat VALUES(98, 83, 7);
INSERT INTO Treat VALUES(99, 115, 22);
INSERT INTO Treat VALUES(100, 158, 30);
INSERT INTO Treat VALUES(101, 102, 4);
INSERT INTO Treat VALUES(102, 98, 15);
INSERT INTO Treat VALUES(103, 109, 24);
INSERT INTO Treat VALUES(104, 126, 12);
INSERT INTO Treat VALUES(105, 59, 16);
INSERT INTO Treat VALUES(106, 93, 30);
INSERT INTO Treat VALUES(107, 109, 2);
INSERT INTO Treat VALUES(108, 14, 11);
INSERT INTO Treat VALUES(109, 165, 22);
INSERT INTO Treat VALUES(110, 120, 19);
INSERT INTO Treat VALUES(111, 87, 21);
INSERT INTO Treat VALUES(112, 14, 15);
INSERT INTO Treat VALUES(113, 122, 8);
INSERT INTO Treat VALUES(114, 3, 6);
INSERT INTO Treat VALUES(115, 156, 12);
INSERT INTO Treat VALUES(116, 2, 24);
INSERT INTO Treat VALUES(117, 96, 30);
INSERT INTO Treat VALUES(118, 86, 29);
INSERT INTO Treat VALUES(119, 164, 1);
INSERT INTO Treat VALUES(120, 160, 26);
INSERT INTO Treat VALUES(121, 120, 24);
INSERT INTO Treat VALUES(122, 41, 3);
INSERT INTO Treat VALUES(123, 177, 14);
INSERT INTO Treat VALUES(124, 10, 17);
INSERT INTO Treat VALUES(125, 151, 11);
INSERT INTO Treat VALUES(126, 61, 19);
INSERT INTO Treat VALUES(127, 153, 19);
INSERT INTO Treat VALUES(128, 152, 20);
INSERT INTO Treat VALUES(129, 175, 2);
INSERT INTO Treat VALUES(130, 46, 12);
INSERT INTO Treat VALUES(131, 171, 26);
INSERT INTO Treat VALUES(132, 81, 19);
INSERT INTO Treat VALUES(133, 65, 26);
INSERT INTO Treat VALUES(134, 159, 7);
INSERT INTO Treat VALUES(135, 97, 20);
INSERT INTO Treat VALUES(136, 63, 2);
INSERT INTO Treat VALUES(137, 117, 16);
INSERT INTO Treat VALUES(138, 134, 16);
INSERT INTO Treat VALUES(139, 66, 28);
INSERT INTO Treat VALUES(140, 66, 5);
INSERT INTO Treat VALUES(141, 174, 5);
INSERT INTO Treat VALUES(142, 124, 30);
INSERT INTO Treat VALUES(143, 74, 7);
INSERT INTO Treat VALUES(144, 100, 4);
INSERT INTO Treat VALUES(145, 96, 15);
INSERT INTO Treat VALUES(146, 94, 17);
INSERT INTO Treat VALUES(147, 153, 20);
INSERT INTO Treat VALUES(148, 90, 28);
INSERT INTO Treat VALUES(149, 162, 27);
INSERT INTO Treat VALUES(150, 172, 20);
INSERT INTO Treat VALUES(151, 23, 24);
INSERT INTO Treat VALUES(152, 81, 15);
INSERT INTO Treat VALUES(153, 161, 17);
INSERT INTO Treat VALUES(154, 82, 14);
INSERT INTO Treat VALUES(155, 39, 29);
INSERT INTO Treat VALUES(156, 119, 5);
INSERT INTO Treat VALUES(157, 104, 13);
INSERT INTO Treat VALUES(158, 114, 8);
INSERT INTO Treat VALUES(159, 101, 16);
INSERT INTO Treat VALUES(160, 61, 7);
INSERT INTO Treat VALUES(161, 70, 16);
INSERT INTO Treat VALUES(162, 57, 5);
INSERT INTO Treat VALUES(163, 149, 20);
INSERT INTO Treat VALUES(164, 144, 21);
INSERT INTO Treat VALUES(165, 171, 7);
INSERT INTO Treat VALUES(166, 176, 24);
INSERT INTO Treat VALUES(167, 80, 13);
INSERT INTO Treat VALUES(168, 133, 28);
INSERT INTO Treat VALUES(169, 33, 18);
INSERT INTO Treat VALUES(170, 167, 16);
INSERT INTO Treat VALUES(171, 172, 13);
INSERT INTO Treat VALUES(172, 30, 2);
INSERT INTO Treat VALUES(173, 30, 17);
INSERT INTO Treat VALUES(174, 148, 7);
INSERT INTO Treat VALUES(175, 57, 12);
INSERT INTO Treat VALUES(176, 45, 11);
INSERT INTO Treat VALUES(177, 34, 16);
INSERT INTO Treat VALUES(178, 156, 4);
INSERT INTO Treat VALUES(179, 17, 20);
INSERT INTO Treat VALUES(180, 27, 10);
INSERT INTO Treat VALUES(181, 42, 1);
INSERT INTO Treat VALUES(182, 47, 18);
INSERT INTO Treat VALUES(183, 177, 22);
INSERT INTO Treat VALUES(184, 11, 17);
INSERT INTO Treat VALUES(185, 147, 28);
INSERT INTO Treat VALUES(186, 115, 1);
INSERT INTO Treat VALUES(187, 86, 24);
INSERT INTO Treat VALUES(188, 45, 7);
INSERT INTO Treat VALUES(189, 158, 26);
INSERT INTO Treat VALUES(190, 72, 28);
INSERT INTO Treat VALUES(191, 83, 14);
INSERT INTO Treat VALUES(192, 17, 17);
INSERT INTO Treat VALUES(193, 15, 15);
INSERT INTO Treat VALUES(194, 153, 24);
INSERT INTO Treat VALUES(195, 148, 27);
INSERT INTO Treat VALUES(196, 8, 27);
INSERT INTO Treat VALUES(197, 121, 30);
INSERT INTO Treat VALUES(198, 76, 16);
INSERT INTO Treat VALUES(199, 57, 8);
INSERT INTO Treat VALUES(200, 59, 14);
INSERT INTO Treat VALUES(201, 158, 29);
INSERT INTO Treat VALUES(202, 45, 4);
INSERT INTO Treat VALUES(203, 42, 8);
INSERT INTO Treat VALUES(204, 54, 25);
INSERT INTO Treat VALUES(205, 61, 17);
INSERT INTO Treat VALUES(206, 117, 15);
INSERT INTO Treat VALUES(207, 34, 22);
INSERT INTO Treat VALUES(208, 38, 23);
INSERT INTO Treat VALUES(209, 15, 17);
INSERT INTO Treat VALUES(210, 7, 25);
INSERT INTO Treat VALUES(211, 44, 9);
INSERT INTO Treat VALUES(212, 20, 8);
INSERT INTO Treat VALUES(213, 131, 1);
INSERT INTO Treat VALUES(214, 69, 29);
INSERT INTO Treat VALUES(215, 160, 26);
4. For this question, you will need to use MySQL. Please write the SQL commands for the
following queries. (Run the commands and submit the screenshots of your query results)
a. The manager is interested in the patient composition. Please create query to get the #
of IP (inpatient) exams and the # of OP (outpatient) exams.
b. The manager is also interested in the number of exams conducted after working
hours. So please create query to get the # of exams done after 5pm per room (IR
Room 1, IR Room 2 and IR Room 3)
c. The third question is the exam duration. For each of the three rooms, please get the
Average, Min, and Max exam durations.
d. The fourth question is related to specialty. The manager is interested in the number of
exams from each specialty. Please write the query to get the number of exams in each
specialty (heart failure, cardiovascular – in short Card, IR, Neuro interventional,
Vascular surgery, Neuro Surgery, Eletro psychologiy). Note you will need to get
information gathered from multiple tables.
e. The manager is now interested in the room allocated for IR specialty only. The last
question is please get the # of “IR” specialty exams in each room.
# 4.a
SELECT COUNT(*) AS Num_of_IP FROM Patient WHERE IPOP=’IP’;
SELECT COUNT(*) AS Num_of_OP FROM Patient WHERE IPOP=’OP’;
# 4.b
SELECT IR_Room.RoomID, COUNT(ExamID) FROM IR_Room
LEFT JOIN Exam ON Exam.RoomID=IR_Room.RoomID
WHERE StartTime>’17:00:00′
GROUP BY IR_Room.RoomID;
# 4.c
SELECT IR_Room.RoomID, MAX(IF(TIMESTAMPDIFF(minute,StartTime,FinishTime)>0,
TIMESTAMPDIFF(minute,StartTime,FinishTime),
TIMESTAMPDIFF(minute,StartTime,FinishTime)+1440)) AS Max_Diff,
MIN(IF(TIMESTAMPDIFF(minute,StartTime,FinishTime)>0,
TIMESTAMPDIFF(minute,StartTime,FinishTime),
TIMESTAMPDIFF(minute,StartTime,FinishTime)+1440)) AS Min_Diff,
AVG(IF(TIMESTAMPDIFF(minute,StartTime,FinishTime)>0,
TIMESTAMPDIFF(minute,StartTime,FinishTime),
TIMESTAMPDIFF(minute,StartTime,FinishTime)+1440)) AS Avg_Diff FROM IR_Room
LEFT JOIN Exam ON Exam.RoomID=IR_Room.RoomID
GROUP BY IR_Room.RoomID;
# 4.d
SELECT MD.Specialty, COUNT(Exam.ExamID) FROM MD
LEFT JOIN Treat ON Treat.MDID=MD.MDID
JOIN Exam ON Exam.ExamID=Treat.ExamID
GROUP BY MD.Specialty;
# 4.e
SELECT IR_Room.RoomID, COUNT(Exam.ExamID) FROM IR_Room
LEFT JOIN Exam ON Exam.RoomID=IR_Room.RoomID
JOIN Treat ON Exam.ExamID=Treat.ExamID
JOIN MD ON Treat.MDID=MD.MDID
WHERE MD.Specialty=’IR’
GROUP BY IR_Room.RoomID;
Homework 3
This is an individual homework. It is due Nov. 20th 5:00pm. You have 2 weeks to finish the
homework due to the scope of the work. Do allocate your time wisely to make a timely
submission. Please submit it through blackboard.
Based on the Homework 2, please generate the following three reports in Excel by VBA.
NOTE: For the convenience of grading, please run the Homework 3.sql to create the database on
MySQL. By doing so, we will all have the same database name, table name and column name. I
will execute your Excel workbook by simply changing the password and the username (if it is
not “root”). Please submit your work in the excel file through BB. Please put each report in a
separate excel sheet.
The report should fetch data from the MySQL database you have created. Please put each report
in a separate excel sheet. The functions of the reports are
1. List the Name, Pager number, Phone number, Working address of each MD whose specialty is
IR.
2. Given a Room ID, list the number of exams conducted after working hours (i.e., exams that
were done after 5:00 PM).
3. List the AVERAGE, MIN, and MAX exam duration for each of the three IR rooms.
For each of the above three reports, (there is one sample on the next page)
(1) Design the user interface, including the report title, execution button, user input field if
necessary (e.g. in the 2nd report, user needs to input the Room ID), report display area.
(2) Write VBA to fulfil the reports.
Hints:
a) read user inputs if necessary;
b) connect to the MySQL database and run SQL queries to gain the required data;
c) clear any old data in report content area, and display new data.
(3) Link the VBA Code to the execution button. Thus, once the button is clicked, the report
should be automatically shown in the report content area.
Sample (An empty report):

Purchase answer to see full
attachment

Why Choose Us

100% non-plagiarized Papers
24/7 /365 Service Available
Affordable Prices
Any Paper, Urgency, and Subject
Will complete your papers in 6 hours
On-time Delivery
Money-back and Privacy guarantees
Unlimited Amendments upon request
Satisfaction guarantee

How it Works

Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
Fill in your paper’s requirements in the "PAPER DETAILS" section.
Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.

[SOLVED] SQL Homework – Programming

Why Choose Us

How it Works

Recent Posts

Recent Comments