1. Write a set of SQL statements (hint: Use the SQL ALTER TABLE command) to add a...
Question:
1. Write a set of SQL statements (hint: Use the SQL ALTER TABLE command) to add a Full Fee Paid 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. Amount Paid to determine data values.)
2. Write a set of SQL statements (hint: Use the SQL ALTER TABLE command) to add a Full Fee Paid column to ENROLLMENT and populate the column, assuming 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 determine data values.) What is the difference between the statements for #1 and #2?
3. Write an ALTER TABLE statement to add a CHECK constraint to the ENROLLMENT table to ensure that the value of Full Fee Paid is either Yes or No.