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.

Transcribed Image Text:

1 1 2 1 3 VAGAW 7 8 CustomerNumber 1 2 3 4 5 6 7 COURSE: CourseNumber 1 2 2 3 3 2345 2345 5 5 CourseNumber CourseNumber 1 3 2 1 1 2 5 4 Course_name Adv Pastels Beg Oils Int Pastels Beg Oils Adv Pastels Amountpaid 250 350 350 500 500 350 250 0 Course Date 10/1/2011 9/15/2011 Fee 500 350 3/15/2011 350 10/15/2011 350 11/15/2011 500 CUSTOMER: 11 22 CustomerNumber 3 234567 567 4 3 7 CustomerLastName Johnson Green Jackson Pearson Sears Kyle Myers CustomerFirstName Ariel Robin Charles Jeffry Miguel Leah Lynda Phone 206-567-1234 425-678-8765 360-789-3456 206-567-2345 360-789-4567 425-678-7654 360-789-5678 1 1 2 1 3 VAGAW 7 8 CustomerNumber 1 2 3 4 5 6 7 COURSE: CourseNumber 1 2 2 3 3 2345 2345 5 5 CourseNumber CourseNumber 1 3 2 1 1 2 5 4 Course_name Adv Pastels Beg Oils Int Pastels Beg Oils Adv Pastels Amountpaid 250 350 350 500 500 350 250 0 Course Date 10/1/2011 9/15/2011 Fee 500 350 3/15/2011 350 10/15/2011 350 11/15/2011 500 CUSTOMER: 11 22 CustomerNumber 3 234567 567 4 3 7 CustomerLastName Johnson Green Jackson Pearson Sears Kyle Myers CustomerFirstName Ariel Robin Charles Jeffry Miguel Leah Lynda Phone 206-567-1234 425-678-8765 360-789-3456 206-567-2345 360-789-4567 425-678-7654 360-789-5678

Answer rating: 100% (QA)

1 ALTER TABLE ENROLLMENT ADD Full Fee Paid CHARACT... View the full answer