Question: Step # 3 : You found another error in your database. Customer # 5 has a shipment but no order number in the table of
Step #: You found another error in your database. Customer # has a shipment but no order number in the table of Orders. Very odd. You talked to the company's Customer Service manager, they confirmed there was an order for Betty Doe but somehow was deleted from their system due the enforcement of referential not existing.
Part a: Betty is located in the USA. You need to run the code to correct her country in the appropriate table.
Part b: Enter an order for Betty. She ordered cables for $ This order will be the next order for the table.
Once completed, submit your screenshot that includes BOTH codes from the input area and the right side of the screen with Available Table to Microsoft Forms. When you code two statements on the same screen, YOU MUST INCLUDE THE ot the end of each statement! Always get in the habit of ending your SQL statements with the;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
