Test I Flashcards

1
Q

The _______ key of the _______ becomes the _______ key of the many

A

Primary key; one; foreign key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the five management principles

A

Mobilize
Translate
Align
Motivate
Govern

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

In terms of management, what is vision

A

Where an organization is desired to be in the future (typically five years)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are strategic objectives

A

Strategic objectives are the ways/processes that a company will use to achieve its vision

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are key performance indicators

A

KPIs are key measures that are used to quantify a company’s progress towards its vision

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are two key types of metrics

A

Lagging indicators
Leading indicators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What kind of indicators/results are based on past actions that are usually too late to adjust to

A

Lagging indicators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What kind of indicators/results are based on current results and can influence future actions

A

Leading indicators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

If you measure _________, you measure _________

A

Everything; nothing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Evaluation strategies

Single loop learning: ________ good and ________ bad

Double loop learning: _________ good and _______ bad

A

Strategy good and execution bad; execution good strategy bad

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the five main perspectives of the balanced scorecard

A

Mission
Fiduciary
Customer
Internal Perspectives
Learning and growth

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Of the five main perspectives, which one is a leading indicator

A

Learning and growth

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is realized strategy

A

A blend of proactive initiatives and reactive responses in an organization’s typical strategy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does deliberate strategy revolve around

A

Proactive elements
Planned initiatives
‘Happy path’

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does emergent strategy revolve around

A

Reactive elements
Responses to unanticipated developments
Developed on the fly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is a business process

A

A collection of linked tasks that once completed will accomplish an organizational goal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What does DCOVA stand for

A

Define
Collect
Organize
Visualize
Analyze

18
Q

What does D in DCOVA stand for

A

Define what you need to measure

19
Q

What does C in DCOVA stand for

A

Collect: Locate the data

20
Q

What does O in DCOVA stand for

A

Organize: Extract data and create databases for it

21
Q

What does V in DCOVA stand for

A

Visualize: Create reports

22
Q

What does A in DCOVA stand for

A

Analyze: Answer questions

23
Q

What is an entity

A

A person, place, or thing an individual wants to collect data about

24
Q

What is a variable

A

A characteristic of an entity

25
Q

If a variable is unknown, it’s value is stored as ________

A

NULL

26
Q

What are two major types of variables

A

Categorical variables
Numerical variables

27
Q

___________ variables are qualitative
Numerical variables are __________

A

Categorical variables; quantitative

28
Q

What are two types of quantitative variables

A

Discrete
Continuous

29
Q

What is a domain

A

A set of values from which one or more fields draw their actual values

Eg. Car type
-Sedan
-SUV
-Compact

30
Q

What do domain integrity constraints require

A

Values must be part of the domain

31
Q

What is cardinality

A

The number of unique values in a domain

32
Q

What is are examples of low cardinality and high cardinality

A

Low cardinality: car engine type
-Petrol
-Electric
-Hydrogen
-Solar

High cardinality: car brands
-BMW
-Mercedes
-Audi
-Porsche
-Toyota
-Nissan
-Honda
-Ferrari
-Citroen
-Dodge
-Mazda
-Chevy
-Mitsubishi

33
Q

What is a record

A

A set of field values that represent instances of an entity

Eg. rows in excel or real databases

34
Q

What are keys

A

Unique identifiers of an instance of an entity

35
Q

What are three types of keys

A

Primary Key
Foreign Key
Surrogate Key

36
Q

How is a foreign key created

A

A primary key from one table is added to another table to form a relationship between the two tables

37
Q

What is a surrogate key

A

A system-generated key

38
Q

What is a table

A

A two-dimensional structure of rows and columns

39
Q

(Yes or False) In a heap, the order of rows is important

A

False, the order of rows in a heap is not important

40
Q

(True or false) Order of columns in a table is important

A

False, order of columns in a table is not important

41
Q

What is a resolution to ‘many-to-many’ entity relationships

A

Intersection tables