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
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
Step by Step Solution
3.37 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
Based on the relational schema provided well create three tables TERRITORY SALESREP and SALESTRANSACTION The TERRITORY table will hold the information ...
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
12th edition
133544613, 978-0133544619
