CIS 205 Chapter 6.1
Which of the following represent the five common characteristics of high-quality data?
-Accurate -Complete -Consistent -Timely -Unique
Select the four primary reasons low-quality data occurs in a system.
-Different systems have different data entry standards and formats. -Online customers intentionally enter inaccurate data to protect their privacy. -Third-party and external data contains inconsistencies and errors. -Data-entry personnel enter abbreviated data to save time.
Which of the following represent analytical data?
-Future growth forecasts -Product Statistics -Trends -Sales projections
Select the three accurate statements reflecting the business advantages of a relational database.
-Increased data integrity -Reduced data redundancy -Increased data security
Which of the following are the business advantages of a relational database?
-Increased flexibility -Increased scalability -Reduced data redundancy -Increased data integrity
Which of the following represent the data levels in an organization?
-enterprise -department -individual
What are the primary concepts of a relational database model?
-entities -attributes -primary key -foreign key
1.Transactional data 2.Analytical data
1.Encompasses all of the data contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks. 2.Encompasses all organizational data, and its primary purpose is to support the performing of managerial analysis tasks.
1.Accurate 2.Complete 3.Consistent 4.Timely 5.Unique
1.Is there an incorrect value in the data? 2.Is a value missing from the data? 3.Is aggregate or summary data in agreement with detailed data? 4.Is the data current with respect to business needs? 5.Is each transaction and event represented only once in the data?
A(n) _________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.
Business
__________ critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.
Business
What is the ultimate outcome of a data warehouse?
Data Marts
What is the smallest or basic unit of data?
Data element
Select a term that is a synonym for data element, the smallest or basic unit of data in a database.
Data field
What occurs when a system produces incorrect, inconsistent, or duplicate data?
Data integrity issues
Who is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business?
Data steward
Select the four primary traits of the value of data.
Data timeliness Data quality Data governance Data type
What maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)?
Database
What creates, reads, updates, and deletes data in a database while controlling access and security?
Database management system
Select the statement that accurately defines the relationship between entities and attributes in a relational database.
Each attribute of an entity occupies a separate column of a table.
Which data element stores a single piece of data about a person, place, thing, transaction, or event?
Entity
Data ___________ refers to the extent of detail within the data (fine and detailed or coarse and abstract).
Granularity
What are rules that help ensure the quality of data?
Integrity constraints
Data ________ is the time it takes for data to be stored or retrieved.
Latency
Identity ____________ is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity.
Management
What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?
Master data management
___________ provides details about data.
Metadata
What deals with the physical storage of data on a storage device?
Physical view of data
What is a field that uniquely identifies a given record in a table?
Primary key
Which tool helps users graphically design the answer to a question against a database?
Query-by-example
__________ -time data means immediate, up-to-date data.
Real
What is a collection of related data elements?
Records
__________ integrity constraints are rules that enforce basic and fundamental information-based constraints.
Relational
What stores data in the form of logically related two-dimensional tables?
Relational database model
Which of the following are examples of analytical data?
Sales projections Product statistics
Which of the following are examples of transactional data? (Check all that apply.)
Sales receipt Airline ticket
Data ___________ is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.
Stewardship
What is the tool that consists of lines of code (in contrast to a graphical design) for answering questions against a database?
Structured query language
T/F: Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.
True
Select the four functions that a database management system can perform on data in a database?
Update data Read data Create data Delete data
When do data integrity issues occur?
When a system produces incorrect, inconsistent, or duplicate data.
Select the statement below that accurately reflects a database.
While a database has only one physical view, it can easily support multiple logical views that provides for flexibility.
Why does a database offer increased information security?
Why does a database offer increased information security?
A data ____________ compiles all of the metadata about the data elements in the data model.
dictionary
Attributes are the data elements associated with an ________.
entity
A(n) __________ key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
foreign
A data ________ analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.
gap
Data ___________ refers to the overall management of the availability, usability, integrity, and security of company data.
governance
Data ___________ occurs when the same data element has different values.
inconsistency
Data _________ is a measure of the quality of data.
integrity
The __________ view of data focuses on how individual users logically access data to meet their own particular business needs.
logical
Data ___________ are logical data structures that detail the relationships among data elements using graphics or pictures.
models
One primary goal of a database is to eliminate data redundancy by recording each piece of data in _______ place(s) in the database.
only one
Data __________ is the duplication of data, or the storage of the same data in multiple places.
redundancy
A(n) __________ database management system allows users to create, read, update, and delete data in a relational database.
relational
Which constraint does not allow someone to create an order for a nonexistent customer?
relational integrity constraint
A(n) __________ query language asks users to write lines of code to answer questions against a database.
structured
Real-time __________ provide real-time data in response to requests.
systems
Data ________ includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.
validation