☑Kizspy.me
RecordDate is not valid, the third row is not inserted because the DoctorID is not valid and
the 4th row is not inserted because the PatientID is not valid.
insert into Medical Records (RecordID, PatientID, DoctorID, AppointmentID, Diagnosis,
Treatment, Notes, RecordDate)
values(200,16,9,28, 'Migraine', 'Dietary changes','Diagnosed with Migraine', '2021-08-14
10:30:00.000'),
(201,7,19,45,'Arthritis', 'Regular monitoring', 'Monitoring', '2019-03-07 00:00:00.000'),
(202,40,21,60, 'Flu', 'Medication', 'Medication', '2022-01-20 10:00:00.000'),
(203,58,1,70, 'Flu', 'Medication', 'Medication', '2021-01-12 10:00:00.000')
select from Medical Records
where RecordID>= 200
1
RecordID PatientID DoctorID AppointmentID Diagnosis Treatment
200
16
Migraine
9
28
Notes
RecordDate
Dietary changes Diagnosed with Migraine 2021-08-14 10:30:00.000
Picture 9.1
Question 10:
Write statements to delete from the Appointments table two appointments with
AppointmentID=159 and AppointmentID=160. You must delete also the rows from the
Prescriptions, Billing and Medical Records tables corresponding to the deleted appointments.
Zoom
+ 100%
Close
