1. Modify the EMPLOYEE table so that JobClass column can store data up to two characters only.

2. Modify the EMPLOYEE table so that EndDate column is deleted

3. Create a new Table BOOK_PRICING containing 3 columns ISBN, Cost, CatCode by selecting these columns from the existing BOOK table.

4. In the Book_Pricing Table, add the primary key constraint on the field ISBN. Make sure to give a name to the constraint.

5. In the Book_Pricing Table, add the foreign key constraint on the field CatCode which reference CATEGORY table.

6. In the Book_Pricing Table, drop the foreign key constraint that you created in above question.

Answer rating: 100% (QA)

1 Modify the EMPLOYEE table to limit the JobClass column to two characters sql ALTER TABLE EMPLOYEE ... View the full answer