How to solve

Step #$4$: As you dive d

you are not happy with the names of the fields not having part of the table name. $($Fro use your coding skills to correct each table for every field name to have a part of the table name foreign keys Il$!$ 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 code from the input area and the right side of the screen with Avarilable 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 Micrasoft 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$

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

tep #$7$: Base on Step #$6.$ Which order did not get invoiced to customers? And do you see an issue with ultiple orders are shipped to the same customer on different dates? What type of relationship does th ble to invoice table create? One to one, one to many, or many to many?

ater your answer in the Microsoft Form