Question
You have been asked to help maintain a database where you work. The DBA has approached you with a report that shows some mismatches. For
You have been asked to help maintain a database where you work. The DBA has approached you with a report that shows some mismatches. For instance in the CUSTOMER table, the CUSTOMERID 2010 belongs to Edward Hampton, however, the DBA knows for certain Edward Hampton has not placed any orders. However his CUSTOMERID is showing up in the ORDER table. What would be your suggestion?
Step by Step Solution
3.47 Rating (147 Votes )
There are 3 Steps involved in it
Step: 1
In this situation I would suggest the following steps to address the mismatch between the CUSTOMER t...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing A Practical Approach with Data Analytics
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
1st edition
1119401747, 978-1119401742
