This preview shows page 1. Sign up to view the full content.
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