Chaper 11
Field
A category of information in a database
Which best describes a data warehouse?
A collection of all the data from an organization's databases
What is the difference between a data warehouse and a data mart?
A data warehouse is a large collection of data from multiple sources in an organization and a data mart is data extracted from a data warehouse that pertains to a single component of the business
What is the difference between a record and a field?
A field is a single piece of information in a record
Primary key
A field that has a value unique to each record
Record
A group fo related fields
Table
A group fo related records
Relationship
A link between tables that defines how the data is connected
What is an example of a record in the Windows Media Player database?
A song
How do I create fields in a database?
Actually, you can create the fields manually by assigned field names
Which of the following is a TRUE statement when considering using databases instead of lists?
All of the above (data integrity can be ensured with a database, data can be easily shared among users, and data-entry errors can be minimized with databases)
How do I get started on creating a database?
Before creating a database, you need to know the three main components of a database. These include fields, records, and tables
Artificial intelligence
Branch of a computer science that attempts to create computers that think like humans
__ systems are used mostly at the executive level to improve business decision making with databases and other fact-based support systems
Business intelligence
Which type of information system is used mainly by executive managers and gathers data from data warehouse and data marts?
Business intelligence system
Two lists showing different values for the same data in different places of a database is an example of?
Data inconsistency
A small subset of data from a data warehouse is knowns as
Data mart
The process by which great amounts of data are analyzed and investigated is known as?
Data mining
__ is the process by which great amounts of data are analyzed and investigated for significant patterns or trends within the data
Data mining
What kind of processes are used to spot trends in large sets of data?
Data mining is used to analyze large amounts of data to help identify trends
Extracting and reformatting data from each sources so all data is consistent and then storing the data is known as
Data staging
Extracting, transforming, and storing data are processes associated with which of the following?
Data staging
Time-variant data
Data that is not limited to particular time period
A large-scale collection of data that consolidated data from various operational systems is known as a?
Data warehouse
What kind of data is captured in a data warehouse?
Data warehouse data is time-variant, and it gets its data from sources inside and outside the business, as well as from clickstream data from websites
Knowledge-based and model management systems are used in which type of business information system?
Decision support systems can be enhanced and made more effective by using knowledge-based and/or model management systems
A __ system is a large software system that gathers information from all parts of a business and integrates it to make is readily available for decision making
Enterprise resource planning
Which of the following is NOT a typical data source for data warehouses
Hyperlink data
An __ is a software that is used to gather and analyze data
Information system
_ systems include expert systems and natural language processing as part of a DSS
Knowledge-based
Exception report
MIS report generated to show unusual situations that require attention
A _ provides timely and accurate information for critical business decisions
Management information system
Which type of database organizes data by measure and feature attributes?
Multidimensional database
Is one table in a database enough to enter all my information in it and store all the fields?
No, you need to create different tables and categorize data to be stored in them
___ software provides flexible viewing and manipulation of data in a data warehouse
OLAP
____ fields hold things such as pictures and video clips
OLE object
Which type of relationship should be used to connect a Password table to a User Account table?
One-to-one relationship
The field that has a unique entry for each record in a database is called the?
Primary key
Which tool is used to search for information in a database?
Query
A __ is a type of Information system that tracks transactions
Real-time processing
What are the three main types of databases?
Relational databases, object-oriented databases, and multidimensional databases
Which of the following is NOT a data mining technique
Reporting
Data mart
Small slice of related data from a data warehouse
What process does source data need to go through to be useable in a data warehouse?
Source data must go through a process called data staging and be extracted, reformatted, and then stored in a data warehouse
What are the different types of databases and which is the most common?
There are relational, object-oriented, and multidimensional databases. Of these, the relational database is most common
__ day is data that doesn't pertain to on period of time
Time-variant
A system that is designed to help keep track of everyday business activities is a(n)?
Transaction-processing system
Which kind of business information system is used at an operational-level of an organization and helps to keep track of daily activities?
Transaction-processing systems are used to keep track of daily operational-level activities
As a business grows it needs to?
Use a database management system that can collect and store data from multiple sources
Fuzzy logic
Used probabilities to inject experimental learning in knowledge-based systems
But, if I include the primary key of one table in the other table, won't I have two primary keys for a record?
When the primary key of one table is included in another table to establish a relationship between the two tables, it is called a foreign key in the related table
What is used to indicate a search term can be anywhere in a string of text?
Wildcards
What else can I store in a field besides text, numeric values, and contents of a calculation?
You can store pictures and video clips using OLE Object fields
What data type can I use for a field if I have to store a page of text?
You can use memo fields. They are text fields that are used to hold long pieces of text
How do I create relationships between tables?
You use primary and foreign key fields to create relationships between tables
In a table, if you need to store the extended price (number of units sold times the price per unit) of an order, you would store the data in a ____ field.
calculated
The results of multiplying the Hours field times the Rate field would be store in a(n) ____ field.
calculated
A(n) ____ is a collection of related data that can be stored, organized, and queried.
database
A category of information about students, such as their phone numbers, would be stored in a(n) ____.
field
In terms of databases, a table is also referred to as a(n) ____.
file
To establish a relationship between two tables, the primary key in one table is associated with the ____ in the other table.
foreign key
Which of the following is NOT a database component?
list
In a database, a text field capable of holding complete paragraphs has a ____ data type.
long text
A(n) ____ database stores data in more than two dimensions.
multidimensional
To ensure that there are no duplicate records in a database table, you need to establish a ____.
primary key
A group of related fields is called a ____.
record
The information about a single student would be stored in a ____.
record
Most small businesses use ____ database as they are reliable and less costly.
relational
To combine data from more than one table, you need to create a(n) ____ between the tables.
relationship
A group fo related records is called a(n) ____.
table
What is the Access object that organizes data into fields and records?
table
