Create the database tables per the relational schema provided.

What does this foreign key constraint status mean? Please provide your answer as a "comment" to your sql code and tag your answer with 1.1.1 (similar to the way I explain each line of code).

Which foreign key constraint status do you prefer in your database: RESTRICT DELETE (Default Status) vs. 'ON DELETE CASCADE' and 'ON UPDATE CASCADE'? Please provide your reasons as a "comment" to your sql code and tag your answer with 1.1.2.

 

SALES TRANSACTION STransactionID Qty Sales SysDate Time SalesRepID (FK) SALES REP SalesRepID RepName TerritoryID (FK) TERRITORY TerritoryID TerritoryName