Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. part 1: your company is concerned there is a probl

Part 1: Your company is concerned there is a problem with the data in one...

80.2K

Verified Solution

Question

Accounting

image Part 1: Your company is concerned there is a problem with the data in one of the database tables. They want you to look at the data and determine if there is a problem. They have stressed it is important to have correct data as it is used for making decisions, and as a basis for reports for various departments. 1. Examine the data in the STUDENT table above and identify column(s) that contain data consistencies or inconsistences. For each column listed below indicate whether the data is consistent or inconsistent. The first one is filled in for you. a. STUDENT_ID - INCONSISTENT b. STUDENT_NAME - consistent c. ADDRESS - consistent d. CITY - inconsistent e. STATE - f. PHONE - inconsistent

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students