SQL/PSM Assignment Answer the following questions on pages 10C-106 to 10C-107: 10C.36 F. Procedure to add a new artist. 10C.36 H. Procedure to update customer phone. 10C.36 I. Procedure to add a new artist while checking whether his/her nationality is valid.

ServiceDescription UnitPrice Men's Shirt Dress Shirt Women's Shirt Blouse FIGURE 10C-106 Sample Data for the MDC Database SERVICE Table ServicelD $1.50 $2.50 $1.50 $3.50 $5.00 $6.00 $5.00 $6.00 $9.00 $8.50 $10.00 $10.00 10 15 16 20 25 30 31 40 45 50 60 Slacks-Men's Slacks-Women's Skirt Dress Skirt Suit-Men's Suit-Women's Tuxedo Formal Gown ServiceDescription UnitPrice Men's Shirt Dress Shirt Women's Shirt Blouse FIGURE 10C-106 Sample Data for the MDC Database SERVICE Table ServicelD $1.50 $2.50 $1.50 $3.50 $5.00 $6.00 $5.00 $6.00 $9.00 $8.50 $10.00 $10.00 10 15 16 20 25 30 31 40 45 50 60 Slacks-Men's Slacks-Women's Skirt Dress Skirt Suit-Men's Suit-Women's Tuxedo Formal Gown