Based on the data given (shown below) for the Academic Database, complete the following:

Create the SQL DML statements for inserting rows into the tables for the Academic Database. Save these statements in a script called M10_LastNameFirstName_InsertInto (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express.

Create the SQL DML statements for inserting data into the Student Details table in the Academic Database. Save these statements in a script called M10_LastNameFirstName_Update (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express.

In each script created above, include the following comments:

At the beginning of the script include your name, the date, and the name of the script and a summary of what the script will do.

Throughout the script, include comments to describe briefly what each section of script will do.

*Note: Data Entry is time consuming; be sure to allot enough time complete this assignment. In order for your insert statements in your script to work, use the same table names that you used in the M09 Assignment; if you didn't complete the M09 Assignment, you will need to complete it before attempting this assignment. When entering data, consider data that is dependent on each other (i.e. primary key data must always be added before foreign keys). Required fields must have data.

Academic Session Details