Query to show customers were missing for existing orders

Assignment Help PL-SQL Programming

Reference no: EM1350660

Q1) As the DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Upon inspection, you observe that the customer table is joined in a one-to-many relationship with orders.

Write a query that would shows which customers were missing for existing orders. Use a join or a subquery.

Propose a solution to your manager for how to correct the problem. There are several alternatives. Present at least one per post, and explain in detail how this data anomaly could happen. Describe your short- and long-term proposal to correct it.

Reference no: EM1350660

Questions Cloud

Nonissurer internal control-financial reporting : Which of the following conditions is necessary for a practioner to accept an attest engagemetn to examine and report on a nonissuer's internal control over financial reporting?

Difference between breakeven points for two machines : Suppose that you and your brother plan to open a business that will make and sell a newly designed type of sandal. Two robotic machines are available to make the sandals, Machine A and B.

Characterize your parental style : How would you characterize your parents' (or someone else's parents that you know well enough, if you prefer) parenting style? How did the parenting style you experienced affect your feelings and behavior?

Internal control-not-for-profit organization : A not-for-profit organization periodically conducts focus groups of employees, service beneficiaries and governance board members to reevaluate its mission, vision, and values to determine the accuracy of the strategic statements to refine them wh..

Query to show customers were missing for existing orders : As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

Develop hypothetical supply and demand schedules : Develop hypothetical supply and demand schedules for your good or service. Plot the schedules onto your graph and label the curves with D for demand and S for supply.

Internal control procedures : Which of the following internal control procedures would prevent an employee from being paid an inappropriate hourly wage?

Explain the various transfers of energy that take place : A person with perfect pitch sits on a bus bench listening to the 445 Hz horn of an approaching car. If the person detects the frequency of 488 Hz, how fast is the car moving.

Determine the projects roe : Your corporation, which is financed entirely with common equity, plans to manufacture a new item, a cell phone that can be worn like a wristwatch.

User Account

All Pages