Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need a correct answer for those questions please Titus tells his supervisor that he believes their company's information is error free but that much of

need a correct answer for those questions please
image text in transcribed
image text in transcribed
image text in transcribed
Titus tells his supervisor that he believes their company's information is error free but that much of what they are reporting is not important to making business decisions. Titus is saying that their information is accessible but not secure verifiable but not timely accurate but not relevant reliable but not complete Accurate information is error free. Relevant information is important to the decision maker. Data normalization involves dividing a relational database into two or more tables and defining relationships between them detecting and then correcting or deleting incomplete, inaceurate, or irrelevant recorda defining proeenses for ensuring that data cau be trusted and used by the entire osganization developing a data riodel that can be used to analyze und coummumicate data needin Data nonmalization is a rigorous multieitep process that ensures that relational databaves take up minimal storage space, resulting in improved database performance. This involves dividing a relational database into two or more tables and defining relationahips between the tablei. Each attribute in a relational database model can be constrained to a range of allowable values called a domain bandwidth ulot: An attribute is a characteristic of an entity. For example, employee number, last name, first name, hire date, and department number are attributes for an employee. Each attribute can be constrained to a range of allowable values called its domain. For instance, the domain for an attribute such as type of employee could be limited to the three characters F (full-time). P (par-time), or C (contractor). If someone tried to enter a " 1 " in the type of employee field, the data would not be accepted

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

1 2 3 Data Base Techniques

Authors: Dick Andersen

1st Edition

0880223464, 978-0880223461

More Books

Students also viewed these Databases questions

Question

Draft a proposal for a risk assessment exercise.

Answered: 1 week ago