Final Flashcards
A _________-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.
data
A ____________ 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.
foriegn
A ____________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer. Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule
business
A ______________ is a collection of related data elements (in the MUSICIANS table these include)
record
A ________________ key is a field (or group of fields) that uniquely identifies a given record in a table
primary
A ___________database model stores information in the form of logically related two-dimensional tables
relational
A content ________ is the person responsible for updating and maintaining website content
editor
A content _________ is the person responsible for creating the original website content
creator
A data __________ is the smallest or basic unit of information
element
A data driven _________ is an interactive website kept constantly updated and relevant to the needs of its customers using a database
website
A database management system or _________creates, reads, updates, and deletes data in a database while controlling access and security
DBMS
A relational database management system allows users to create, read, update, and delete data in a relational _______________
database
A relational database model stores information in the form of logically related _________-dimensional tables
two
An __________________ stores information about a person, place, thing, transaction, or event
entity
Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships
detection
broadly defined, a __________ maintains information about various types of objects, events, people, and places.
database
Business intelligence ____________ track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis
dashboards
Business-critical ___________ constraints enforce business rules vital to an organization’s success and often require more insight and knowledge than relational integrity constraints
integrity
Businesses collect a tremendous amount of _____________ information as part of their routine operations
transactional
Companies can gain valuable business knowledge by viewing the data accessed and analyzed from their ________
website
Data ___________ are logical data structures that detail the relationships among data elements using graphics or pictures
models
Data _____________ tools move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more
visualization
Data ______________ compiles all of the metadata about the data elements in the data model
dictionary
Data _______________ refers to the overall management of the availability, usability, integrity, and security of company data
governance
Data ___________________ describes technologies that allow users to “see” or visualize data to transform information into a business perspective
visualization
Data mining is the process of analyzing data to extract information not offered by the raw _______ alone
data
Data mining occurs on ____________ data that are already in a database or a spreadsheet
structured
Data warehouses can _____________ information like the example of gender
standardize
Databases today scale to exceptional levels, allowing all types of users and programs to perform _____________ processing and information-searching tasks
information
Dynamic __________ information is stored in a dynamic catalog , or an area of a website that stores information about products in a database
website
Extraction, transformation, and ___________ is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
loading
Information __________ issues occur when a system produces incorrect, inconsistent, or duplicate data
integrity
Information ___________ is a measure of the quality of information
integrity
Information ____________ occurs when the same data element has different values
inconsistency
Information ______________ is the duplication of data, or the storage of the same data in multiple places
redundancy
Information cleansing or __________ is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
scrubbing
Information is everywhere in an organization. Information ____________ refers to the extent of detail within the information
granularity
Integrity _________ are rules that help ensure the quality of information
constraints
Many firms complete data ___________ audits to determine the accuracy and completeness of its data
quality
Many organizations find themselves in the position of being data ___________ and information poor. Even in today’s electronic world, managers struggle with the challenge of turning their business data into business intelligence
rich
Of the two primary tools available for retrieving information from a DBMS, the first is a _______by example tool that helps users graphically design the answer to a question against a database
query
Organizations using business intelligence can find the cause to many issues and problems simply by asking the question _________
why
Real-time _______ means immediate, up-to-date information
information
Real-time ___________ provide real-time information in response to requests
systems
Relational _____________ constraints are rules that enforce basic and fundamental information-based constraints
integrity
0.15873 out of 0.15873 points
Relational _______________ constraints are rules that enforce basic and fundamental information-based constraints
integrity
The __________ view of information deals with the physical storage of information on a storage device
physical
The ___________ view of information focuses on how individual users logically access information to meet their own business needs
logical
The five common characteristics of high-quality include accurate, complete, __________, timely and unique
consistent
The primary purpose of a data ___________ is to combine information, specifically, strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis
warehouse
Time-series information is time-stamped information collected at a particular _______
frequency
Two of the challenges businesses faced before data warehouses were lack of data standards and poor data ______
quality
Unstructured __________ does not exist in a fixed location and can include text documents, PDFs, voice messages, emails, and so on
data
Zappos credits its success as an online _________ retailer to its vast inventory of nearly 3 million products available through its dynamic data-driven website
shoe
______ information includes data that change based on user actions
dynamic
_______ information includes fixed data incapable of change in the event of a user action
static
_______ mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation
web
_______ visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized
data
_________ displays information graphically so it can be easily understood
infographics
___________ provides details about data
metadata
______________ can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time
infographics
_________ is accessing large amounts of data from different management information systems
informing
___________ are the data elements associated with an entity
attributes
A _________ is a single unit of binary data routed through a network
packet
A __________ is software that prevents direct communication between a sending and receiving computer and is used to monitor packets for security reasons
proxy
A ___________ area network connects a group of computers in close proximity, such as in an office building, school, or home
local
A ___________ area network is a large computer network usually spanning a city, and is used by colleges, universities, and large companies that span their campuses
metropolitan
A ___________ is a space station that orbits the Earth receiving and transmitting signals from Earth-based stations over a wide area
satellite
A ___________ is a standard that specifies the format of data as well as the rules to be followed during transmission
protocol
A ___________ metropolitan area network uses radio signals to transmit and receive data
wireless
A ____________ receives and repeats a signal extending its attenuation or range
repeater
A _____________ is a round coin-sized object, is uniquely numbered and hidden in geocache
geocoin
A metropolitan area network (MAN) is a large computer network usually spanning a _______
city
