In this question we ask you to apply.....

Apply constraint checking to database

ask you to apply constraint checking to a database. The database manages customer orders, a common commercial application of database systems, and consists of three relations, defined as follows: CREATE TABLE CustomersdI INTEGER name CHAR(40), email CHAR(64), PRIMARY KEY (id), UNIQUE (email) CREATE TABLE Orders INTEGER custID INTEGER, saledate PRIMARY KEY (id), FOREIGN KEY (custID) REFERENCES Customers DATE, ON DELETE NO ACTION ON UPDATE CASCADE) CREATE TABLE Lineltems( INTEGER, orderlD INTEGER, item CHAR(64), quantityINTEGER, cost REAL, PRIMARY KEY (id, orderlD), FOREIGN KEY (orderlD) REFERENCES Orders ON DELETE CASCADE ON UPDATE CASCADE) Customers name email 1 Thomas Jefferson 2 George Washington 3 John Kenne 4 George H. W. Bush ti@monticello.com vernon.net bush41@kennebunkport.us id custlD saledate 03/05/1801 07/04/1961 04/06/200 Lineltems id orderID cost 3.50 3.88 23.00 4.20 3.90 65.00 6.99 item uantit 12 Quills Parchment Pens Broccoli Sushi Cuban C 12 12 Candles ask you to apply constraint checking to a database. The database manages customer orders, a common commercial application of database systems, and consists of three relations, defined as follows: CREATE TABLE CustomersdI INTEGER name CHAR(40), email CHAR(64), PRIMARY KEY (id), UNIQUE (email) CREATE TABLE Orders INTEGER custID INTEGER, saledate PRIMARY KEY (id), FOREIGN KEY (custID) REFERENCES Customers DATE, ON DELETE NO ACTION ON UPDATE CASCADE) CREATE TABLE Lineltems( INTEGER, orderlD INTEGER, item CHAR(64), quantityINTEGER, cost REAL, PRIMARY KEY (id, orderlD), FOREIGN KEY (orderlD) REFERENCES Orders ON DELETE CASCADE ON UPDATE CASCADE) Customers name email 1 Thomas Jefferson 2 George Washington 3 John Kenne 4 George H. W. Bush ti@monticello.com vernon.net bush41@kennebunkport.us id custlD saledate 03/05/1801 07/04/1961 04/06/200 Lineltems id orderID cost 3.50 3.88 23.00 4.20 3.90 65.00 6.99 item uantit 12 Quills Parchment Pens Broccoli Sushi Cuban C 12 12 Candles