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

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, assum- ing that the column is NOT NULL. The only possible values for this column are Yes and No. (Compare COURSE.Fee to ENROLLMENT.Amount Paid to deter- mine data values.) What is the difference between your answer to this question and your answer to question 3.59?

AppendixLO1

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: 9780133544886

6th Edition

Authors: David M Kroenke, David J Auer

Question Posted: