☑Kizspy.me
AppointmentDate of the appointment corresponding to the inserted medical record.
- The PatientID of the inserted medical record is equal to the PatientID of the appointment
corresponding to the inserted medical record.
8 of 8
Paper No: 12
- The DoctorID of the inserted medical record is equal to the DoctorID of the appointment
corresponding to the inserted medical record.
Zoom
For example, if we execute the following statements to insert 4 medical records and then
select these medical records from "Medical Records" table, we can see that only the first row
is inserted as shown in the following figure. The second row is not inserted because the
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
+ 100%
Close
