Assume the Item table has been created, but there are no integrity constraints. Create the necessary integrity
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Concepts of Database Management
ISBN: 978-111182591
7th edition
Authors: Philip J. Pratt, Joseph J. Adamski
Posted Date: