Question

35. 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.)

36. 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.)

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

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

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

40. Modify the PILOT table to add the attribute shown in the following table.

Answer 1

Solution

1)

Updation of the record .

Syntax :

Update TABLE_NAME

SET COLUMN = [QUERY or 'VALUE']

WHERE CONDITION;

Updation of the table Charter

Update Charter

Set CHAR_WAIT_CHG =

( SELECT MOD_WAIT_CHG FROM MODEL,AIRCRAFT WHERE MODEL.MOD_CODE = AIRCRAFT.MOD_CODE

and AIRCRAFT.AC_NUMBER = CHARTER.AC_NUMBER);

2)

Update CHARTER

Set CHAR_FLT_CHG_HR =

( SELECT MOD_CHG_MILE FROM MODEL,AIRCRAFT WHERE MODEL.MOD_CODE = AIRCRAFT.MOD_CODE

and AIRCRAFT.AC_NUMBER = CHARTER.AC_NUMBER);

3)

UPDATE CHARTER

SET CHAR_FLT_CHG:=CHAR__HOURS_FLOWN*CHAR_FLT_CHG_HR;

4)

UPDATE CHARTER

SET CHAR_TAX_CHG := CHAR_FLT_CHG*0.08;

5)

UPDATE CHARTER

SET CHAR_TOT_CHG = CHAR_FLT_CHG + CHAR_TAX_CHG;

6)

ALTER TABLE PILOT

ADD PIL_PIC_HRS NUMBER;

Feel free to reach out regarding any queries . And please do rate the answer . Thank you .