06. Examine the Following Tables and Answer the question ba COURSE Course_name Introduction to computing Programming 11 Data Structures Statistics Database Credits CCT 205 CCCS 203 CCCS 204 STAT 110 CCCS 215 11 3 3 3 SECTION STA 1 PREREQUISTE Sestion ID Course_num 85 STAT 110 92 COIT 201 102 CCCS 204 112 STAT 110 CCIT 201 CCCS 215 Semester Year Instructor F 15 Spring Mohmmad Fall Farid Spring 18 Fall 18 Mohmmad Soring 19 CCCS 204 CCCS 204 CEIT 200 OCCS 201 CCCS 204 119 135 Almalla Alami A) For each of the following DML operations, specify whether the operation will be accepted or rejected. In the case of rejection, explain why by specifying which constraint from below is violated? A. Domain Constraint (Assume the domain of a column is limited to the values present in that column) B. Primary Key Constraint C. Entity Integrity Constraint D. Referential (Foreign Key) Constraint DML Operation Accepted Rejected 1. INSERT into Course Values ('Technical Writing'. 'CCT 201,3, IT'); Explanation: 2. INSERT Into Prerequisite values ('CCCS 382', 'COCS 381'); Explanation: 3. UPDATE SECTION set Semester = 'Winter' where Section_ID = 92; Explanation: 4. INSERT into Course Values l'Advanced DB, 'CCCS 501', 3, 'CS'); Explanation: Page 17 B) Given the following trigger using the tables above, check the code of this trigger: CREATE OR REPLACE TRIGGER RejectOrder BEFORE INSERT ON Orders FOR EACH ROW DECLARE currentBalance NUMBER; creditLimit NUMBER; BEGIN SELECT Cr_limit, Cr_balance INTO creditLimit, currentBalance FROM Customers WHERE Cust_no = new.Cust_no; IF creditLimit