Create the database tables per the relational schema provided. What does this foreign key constraint status mean?
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: