Question: 1. You're exploring data in the Customers and Orders tables and you're discovering that there are customers without orders in the last three months. As

1. You're exploring data in the Customers and Orders tables and you're discovering that there are customers without orders in the last three months. As a manager, what's the action you'll take for this fact? 2. You're also discovering that there are orders without associated customers. What's the action you'll take for this fact? 3. Corporate rules state that no two customers can have identical last and first names. What will you do to prevent this issue from happening? 4. Finally, you see that there are some null values in the country field. The country is always USA. What will you do to solve this issue?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!