Step #$4$: As you dive deep into the design on each table, you are not happy with the names of the fields not having part of the table name. $($From Chapter #$2).$ You need to use your coding skills to correct each table for every field name to have a part of the table name. Be careful with your foreign keys!!! The field name of the foreign key should be from the original table, they were the primary key. You know how to do this from Step #$2$ by using the RENAME command.

Once completed, submit your screenshot that includes your last cade from the input area and the right side of the screen with Available Tables to Microsoft Forms.

Step #$5$: Time to create a table for all the invoices that you are sending out on the shipments. This new table needs to include a primary key, foreign key to the shipment primary key, foreign key to the order primary key and a field for invoice date. Primary key cannot be null, must be unique. Invoice date must have a named constraint to check that the date entered is greater than Jan $1,2024$ and not null. Both foreign keys may not be null. You must enforce referential entity in your code with the $"$ON DELETE CASCADE". $($HINT: use your Chapter #$8$ provided reference sheet$)$

Once completed, submit your screenshot that includes your code from the input area and the right side of the screen with Available Tables to Microsoft Forms.

NOTE: if you take a break and refresh your browser or close the coding website, you must enter all your coding in again before you continue.

Step #$6$: You need to update the INVOICE table to include all the missed invoices that were sent to customers. Add the following records to the table.

First invoice was mailed to Robert Luna for order #$5$ on Jan $5,2024$

Second invoice was mailed to John Reinhardt for order #$1$ on Jan $7,2024$

Third invoice was mailed to David Robinson for order #$3$ on Jan $9,2024$

Fourth invoice was mailed to Betty Doe for order #$6$ on Jan $11,2024$

Fifth invoice was mailed to John Doe for order #$4$ on Jan $13,2024$