Final Flashcards
(183 cards)
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