Write a set of SQL statements ( Hint: Use the SQL ALTER TABLE command.) to add a

Question:

Write a set of SQL statements (Hint: Use the SQL ALTER TABLE command.) to add a FullFeePaid column to ENROLLMENT and populate the column, assuming that the column is NULL. The only possible values for this column are Yes and No (Compare COURSE.Fee to ENROLLMENT.AmountPaid to determine data values.)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Concepts

ISBN: 978-0133544626

7th edition

Authors: David M. Kroenke, David J. Auer

Question Posted: