Write an ALTER table statement to add a new column named StdBalance to STUDENT table

Business Rule #1: The maximum number of students per class allowed is 30.

Business Rule #2 : Prevent a student from registering a class if his or her unpaid balance is more than

$ 500 (StdBalance value)

Write two triggers to enforce Business Rules # 1 & #2. For ease of the triggers testing assume the maximum numbers of students allowed in any class for business rule #1 is 4 instead of 30.

STUDENT SI ID SAFN SIC Suastate su 10 Eau Clare 18121 102 Mebe MN 56142 103 Robinson Sarnell MN 98042 104 56301 105 Robinson St. Paul MN 55103 MKTG COURSE Course No Ces Dese CSCI 200 Elements of Computing IS 250 Application Program Dev. I IS 251 Application Program Dev. II IS 454 Data Mining for Decision Support IS 356 Systems Analysis and Design I IS 460 Project Management ACCT 291 Accounting Principles II IS 443 Database Design STUDENT SI ID SAFN SIC Suastate su 10 Eau Clare 18121 102 Mebe MN 56142 103 Robinson Sarnell MN 98042 104 56301 105 Robinson St. Paul MN 55103 MKTG COURSE Course No Ces Dese CSCI 200 Elements of Computing IS 250 Application Program Dev. I IS 251 Application Program Dev. II IS 454 Data Mining for Decision Support IS 356 Systems Analysis and Design I IS 460 Project Management ACCT 291 Accounting Principles II IS 443 Database Design