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 Item->price 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 1 insert statement that is successful and 1 insert statement that is unsucessful
Write the following ALTER TABLE statements
Updates name in Menu Item to allow 15 characters
Fix the "descriptoin" column in Menu Item
Update zip in Store Location to be char(6) instead of int
 Using the diagram above, do the following: Write CREATE TABLE statements

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!