Hi,

I am using MindTap on Cengage for my DAT 380 course. I need help with the following problems:

Problem 37

Modify the CHARTER table to add the attributes shown in the following table.

Use the following precision for each row:

Attribute Name	Attribute Precision
CHAR_WAIT_CHG	6,2
CHAR_FLT_CHG_HR	6,2
CHAR_FLT_CHG	10,2
CHAR_TAX_CHG	6,2
CHAR_TOT_CHG	10,2
CHAR_PYMT	10,2
CHAR_BALANCE	10,2

Problem 38

Write the sequence of commands required to update the CHAR_WAIT_CHG attribute values in the CHARTER table.

Hint: Use either an updatable view or a stored procedure.

Problem 39

Write the sequence of commands required to update the CHAR_FLT_CHG_HR attribute values in the CHARTER table.

Hint: Use either an updatable view or a stored procedure.

Problem 40

Write the command required to update the CHAR_FLT_CHG attribute values in the CHARTER table.