YOU HAVE A TABLE NAMED CUSTOMERS. WHEN A NEW CUSTOMER IS ADDED, YO...

14. You have a table named Customers. When a new customer is added, you must check the CreditRating table for the proposed customer’s credit rating. If the credit rating is below a certain value, you must not allow the customer to be added to the Customers table. What is the best way to achieve this?A. Create a FOR INSERT trigger.B. Create an AFTER INSERT trigger.C. Create an INSTEAD OF INSERT trigger.D. Create a CHECK constraint.