Drop the ItemIndex3 index from the Item table. Assume the Item table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only...



Drop the ItemIndex3 index from the Item table.



Assume the Item table has been created, but there are no integrity constraints. Create the necessary integrity


constraint to ensure that the only allowable values for the Category field are PZL, GME, and TOY. Ensure that


the ItemNum field is the primary key and that the ItemNum field in the OrderLine table is a foreign key that must


match the primary key of the Item table.



May 26, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here