This needs to be done in Oracle SQL Database thank you. $==============================================$ Task $4$ Create tables $[15$ marks$)$ Create the tables in Oracle. Write SQL scripts defining each table. The table definitions should include $(1)$ All attributes with appropriate data types $(2)$ all appropriate constraints such as primary key, foreign keys, and check statements. All constraints must be given names. Naming standards must be used. Task $5$ Populate data $(10$ marks$]$ Insert a small sample of realistic test data $(5-10$ rows min.$)$ into each table. Refer to case study document for examples of sample data. All test data must be meaningful in order to demonstrate your understanding of the data. For Part B$,$ you must include the following for each table in your database: SQL table creation script SQL insert script Sample data $($include results of SELECT statements for each table$)|$offers Department deptnum deptname fax phone location hod employs FH$-$ Student studentid firstname lastname financialloan $>$ enrolls $----$ manages Course coursecode duration coursetitle deptnum staffid AcademicStaff staffid firstname lastname qualifications phone extension officenumber address position address sex dob coursecode sex $1$ salary deptn um $1$ has consists of $!!$ undertakes NextOfkin Paper firstname Assessment result papercode papertitle startdate lastname relationship phone address tstudentid enddate score papercode studentid resources coursecode $18$