July Release Confetti
150+ New Courses, Hands‑On Labs, And
Interactive Learning Activities
Learn More

LiNUX Lab

Order Entry Databases Are Missing Records

We deploy the real environment, you take the scenario-based labs on us. Hands-on, from anywhere, at any time.

Time required: 3 Hours

Objectives

Update the customer and order database tables in the order entry database to reflect records that were inadvertantly deleted by the accounting staff.

Overview

This lab will require you to download and install a preconfigured database instance populated with the latest copy of the customer order entry database. You will be required to add the provided records to both tables and then display the results to verify.

Scenarios

The accounting department in your shipping company has inadvertent deleted several customer and associated order records from the order entry database while you are on vacation. Fortunately, they were able to save the values in each row from a screen print you have been sent.

You have been asked to download the latest database from the remote server and add the records directly (if they do it, it will attempt to ship the products again and skew this week's financial summary). You need to add two customers and a single order for each one to the appropriate database tables. Once completed, execute a query that will show all the orders along with the customer information to verify the data is there.

Customer Data
=============
Customer Number: 111
Name: Jason Smith
Customer Age: 41

Customer Number: 112
Customer Name: Sheila Jones
Customer Age: 33

Order Data
=========
Order Number: 505
Customer Number: 111
Item Description: Fuzzy Slippers
Item Price: $14

Order Number: 506
Customer Number: 112
Item Description: Umbrella
Item Price: $99

Share our Labs
Start Your Free Trial

We have the longest and most in depth courses about cloud and engineering topics on the web. All of our training content is included with every membership.