AIU Online Sql Table Statements Paper

Complete the following exercise:

• Use the cis305 database you previously created.
• Use T-SQL to alter the booth and machine tables. Add a foreign key constraint to each table for the product_id referencing product_id in the product table.
• Use T-SQL to alter the booth and machine tables. Add a check constraint to each table for the booth_price in the booth table and the machine_price in the machine table. The check criteria should be booth_price > 0.00 and machine_price > 0.00 respectively.
• Now, right click on the check constraint for booth price under constraints in the booth table. Select Script To…Clipboard. You may now perform a paste (from the clipboard) into your submission document as verification of both the foreign key constraint add and the check constraint add.
• Repeat the previous step for the check constraint in the machine table.
• When you have successfully added the constraints to the table, ensure that you have copied and pasted all of the T-SQL statements and verification results into your assignment submission.

Once you have completed your assignment, copy and paste the script into a Word document and submit it.