Question: Data and Information Activity 2 Goals: Identify anomalies and flaws in tables. Identify problems that anomalies in data 1. Bad Database Design is why we

Data and Information Activity 2 Goals: Identify anomalies and flaws in tables. Identify problems that anomalies in data 1. Bad Database Design is why we spend so much time on modeling Consider the following table of information Pet Information DOB Type Owner Hucky ?? Dog Mike Koenig Sumi 6/6/20 dog Michael Koenig Peanut 15/7/1995 Dog MIKE Koenig Sumi 1/1/2025 Mixed Breed Asumi Taga Pet Pet Vet Clinic Appointment Information Visit Client Doctor Dec 24 Mike Koenig Hucky Jones 12/12 Mike Koeinnig Hucky, Peanut, Jones yearly Sumi checkup, treatment for a cut 11/11/20 Koenig Both Nail Trimming 11/11/11 Sumi Vaccine, Initial Visit. Sumi is a cute puppy List as many problems as detected, and why that is an issue. (One line per problem please) 2. Describe some of the "downstream" problems if the flaws remain in the data model? Please be specific

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 Databases Questions!

financial Analysis: Ithemba Engineering ( Pty ) Ltd ( Ithemba ) manufactures and distributes specialised products to customers in the construction industry. Every year, Ithemba invests significantly...

PepsiCo is a giant consumer foods corporation with 2005 sales of $32.5 billion and a net profit of $4 billion. Its main divisions are PepsiCo Beverages North America, with soft drink sales of more...

hi expert help me answer section 1 and section 2 thank you Abstract Purpose: Little research has been contributed to how the behaviors associated with emotional intelligence may be practically...

THE GREAT TRAINING ROBBERY Corporations are victims of the great training robbery. American companies spend enormous amounts of money on employee training and education-S160 billion in the United...

Assignment #2 - Data Modeling Assignment 40 Points Possible Part 1: (20 points) Use Microsoft Visio to create and ERD. Julia, a recent graduate of UToledo has launched her own web design company:...

24-Seven: Missing information relevant to payables processing Question that Kiran should have asked or pursued further Reason for asking the question 1 How do you know suspended transactions are...

Using Graphical Representations of Business Processes in Evaluating Internal Control A. Faye Borthick, Gary P. Schneider, and Anthony Vance ABSTRACT: In this case, students (1) extend business...

7. INTERNAL CONTROLS ASSESSMENT AND ELECTRONIC DATA INTERCHANGE: GRESKO TOYS FACTORY (Prepared by Robertos Karahannas, Lehigh University) Mr. and Mrs. Gresko started Gresko Toys in the early 1960s....

Internal Controls Assessment and Electronic Data Interchange: Gresko Toys Factory (Prepared by Robertos Karahannas, Lehigh University) Mr. and Mrs. Gresko started Gresko Toys in the early 1960s....

Mr. and Mrs. Gresko started Gresko Toys in the early 1 960s. Initially, the company was small and few toys were produced. The talent and skills of Mr. Gresko were by far the major assets of the...

What are various payroll information that can be defined in the payroll ledger settings. What information must you record as historical information for an employee when you set up the Payroll Ledger?...

1 Express in terms of sine only 1+tan?x

Under Securities and Exchange Commission regulations, who may be a member of an audit committee for a listed company? Multiple Choice Any member of the corporate board of directors Any member of the...

General Electric Company had cash of $14,000 on hand on January 1. During the year, the company expected the following cash collections from customers by quarter: (06) First Second Third Fourth Cash...

11-10 Expert systems typically use a large number of rules. This project has been simplified to reduce the number of rules, but it will give you experience working with a series of rules to develop...

11-11 This project will give you experience using shopping bots to search online for products, find product information, and find the best prices and vendors. Select a digital camera you might want...

11-9 Canadian Tire is one of Canadas largest companies, with 50,000 employees and 1,100 stores and gas bars (gas stations) across Canada selling sports, leisure, home products, apparel, and financial...