Business Intelligence Exam 1 UPDATED
Exam Questions and CORECT Answers
database development life cycle - CORRECT ANSWER initiation
analysis
design
implementation
maintenance
entity - CORRECT ANSWER aggregation of # of data elements that naturally belong together
relationship - CORRECT ANSWER association between 2+ entities that is of particular
interest
attribute - CORRECT ANSWER each data element
cardinality - CORRECT ANSWER number of instances that entity can be associated with
each instance of another entity
identifiers - CORRECT ANSWER key attributes that identify particular facts in an entity
primary key - CORRECT ANSWER attribute that can uniquely ID a complete record within
an entity
foreign key - CORRECT ANSWER copy of a primary key that exists in another entity in
order to form a relationship between the entities
OLAP - CORRECT ANSWER user queries system and conducts analysis and examines many
data types
Exam Questions and CORECT Answers
database development life cycle - CORRECT ANSWER initiation
analysis
design
implementation
maintenance
entity - CORRECT ANSWER aggregation of # of data elements that naturally belong together
relationship - CORRECT ANSWER association between 2+ entities that is of particular
interest
attribute - CORRECT ANSWER each data element
cardinality - CORRECT ANSWER number of instances that entity can be associated with
each instance of another entity
identifiers - CORRECT ANSWER key attributes that identify particular facts in an entity
primary key - CORRECT ANSWER attribute that can uniquely ID a complete record within
an entity
foreign key - CORRECT ANSWER copy of a primary key that exists in another entity in
order to form a relationship between the entities
OLAP - CORRECT ANSWER user queries system and conducts analysis and examines many
data types
