Question: Using the diagram above, do the following: Write CREATE TABLE statements for each ( mistakes are intentional ) Make sure to include key constraints for
Using the diagram above, do the following:
Write CREATE TABLE statements for each mistakes are intentional
Make sure to include key constraints for each table
For Menu Itemprice column, add a check constraint to ensure price is not negative zero is allowed
Write insert statements to test your constraints primary keys and foreign keys
You need at least insert statement that is successful and insert statement that is unsucessful
Write the following ALTER TABLE statements
Updates name in Menu Item to allow characters
Fix the "descriptoin" column in Menu Item
Update zip in Store Location to be char instead of int
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
