Question $7$

$($Marks: $30)$

Provide relevant code examples, with code comments based on this case study of how to implement the following:

Note: Provide your own code examples with comments and the achieved output for each question. The reuse of codes from the previous questions $($Q$.1-$Q$\mathrm{.}6)$ will be awarded a $0.$

Q$\mathrm{.}7\mathrm{.}1\%$TYPE attribute;

$(5)$

Q$\mathrm{.}7\mathrm{.}2\%$ROWTYPE attribute

$(5)$

Q$\mathrm{.}7\mathrm{.}3$ System defined exception.

$(10)$

Q$\mathrm{.}7\mathrm{.}4$ User defined exception

$(10)$