INVENTORY

SALES

SALES Table create statement:

Create Table SALES $($

ID int,

Amt decimal $(12,2),$

INV$\_$ID int,

Primary key $($ID$),$

Foreign Key $($INV$\_$ID$)$ references INVENTORY $($ID$)$

ON DELETE RESTRICT

ON UPDATE CASCADE$)$;

DELETE FROM INVENTORY WHERE ID

$[$ Choose $]$

Data will update$/$delete in only in the table referenced in the SQL statement

Data will update$/$delete in both tables

$=2$;

$$ Referential integrity ERROR

UPDATE INVENTORY SET QTY $=25$

WHERE ID $=2$;

DELETE FROM SALES WHERE ID $=30$;

UPDATE INVENTORY SET ID $=5$

WHERE ID $=3$ ;

DELETE FROM INVENTORY WHERE ID

$=1$;

INVENTORY

SALES

SALES Table create statement:

Create Table SALES $($

ID int,

Amt decimal $(12,2),$

INV$\_$ID int,

Primary key $($ID$),$

Foreign Key $($INV$\_$ID$)$ references INVENTORY $($ID$)$

ON DELETE RESTRICT

ON UPDATE CASCADE$)$;

DELETE FROM INVENTORY WHERE ID

$[$ Choose $]$

Data will update$/$delete in only in the table referenced in the SQL statement

Data will update$/$delete in both tables

$=2$;

$$ Referential integrity ERROR

UPDATE INVENTORY SET QTY $=25$

WHERE ID $=2$;

DELETE FROM SALES WHERE ID $=30$;

UPDATE INVENTORY SET ID $=5$

WHERE ID $=3$ ;

DELETE FROM INVENTORY WHERE ID

$=1$;