Unformatted text preview: b) For all Parts, no other Supplier has a lower price than the Supplier with “sid” = 1. (25 marks) Assignment 4.2 Consider again the product database from Assignment 4.1 Formulate the following integrity constraint as a set of SQL triggers: No Supplier may supply red and green Parts. (50 marks) Make sure that you formulate one trigger for each of the DB modifications that can potentially violate the integrity constraint. Your trigger(s) should explicitly undo the database modification that violated the integrity constraint....
View Full Document
- Spring '09
- Database management system, Database trigger, Martin Ester TA, Gustavo Frigo Assignment