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

Question:

Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values for the Class field are AP, HW, and SG. Ensure that the PartNum field is the primary key and that the PartNum field in the OrderLine table is a foreign key that must match the primary key of the Part table.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-111182591

7th edition

Authors: Philip J. Pratt, Joseph J. Adamski

Question Posted: