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
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.
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
Step by Step Solution
3.47 Rating (160 Votes )
There are 3 Steps involved in it
1 ALTER TABLE ENROLLMENT ADD Full Fee Paid CHARACT... View full answer
Get step-by-step solutions from verified subject matter experts
100% Satisfaction Guaranteed-or Get a Refund!
See step-by-step solutions with expert insights and AI powered tools for academic success
-
Access 30 Million+ textbook solutions.
-
Ask unlimited questions from AI Tutors.
-
Order free textbooks.
-
100% Satisfaction Guaranteed-or Get a Refund!
Claim Your Hoodie Now!
Database Concepts
Authors: David M. Kroenke, David J. Auer
7th edition
133544621, 133544626, 0-13-354462-1, 978-0133544626
Study Smart with AI Flashcards
Access a vast library of flashcards, create your own, and experience a game-changing transformation in how you learn and retain knowledge
Explore Flashcards
Study Help
