☑Kizspy.me
18
Hypertension
2021 3
19
Infection
2019 1
20 Infection
2020 7
21
Infection
2021 1
22
Migraine
2019 3
23
Migraine
2020 9
24
Migraine
2021 2
Picture 8.1
Zoom
Question 9:
Create a trigger named Tr1 for the INSERT statement on the "Medical Records" table so that
when we execute an insert statement to add one or more rows to the "Medical Records"
table, only valid rows will be inserted into the "Medical Records" table, all invalid rows will be
ignored. A row to be inserted is valid if all the following requirements are satisfied:
- The RecordDate of the inserted medical record is greater than or equal to the
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.
+100%
Close
