Task $3$ Create tables $[25$ marks$]$

Create the tables in Oracle$\mathrm{.}1$ Write SQL scripts defining each table. The table definitions should include

$$ All attributes with appropriate data types

$$ All appropriate constraints, such as primary key, foreign keys, and check statements

$($CHECK constraints$).$

$$ All constraints must be given names. Naming standards must be used