Midterm 1 Flashcards

1
Q

What is Disruptive Technology?

A

Can cause a paradigm shift, makes current technology not as efficient or affordable, may create opportunities for a change in the market in the future

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

Who normally creates new paradigms?

A

People outside of the current industry

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

What are six key observations of paradigms?

A
  1. Paradigms are common
  2. Paradigms are useful means of understanding; focus our attention
  3. Sometimes your paradigm can become THE only paradigm you recognize; Paradigm paralysis
  4. The people who create new paradigms are usually outsiders of the prevailing paradigm
  5. Those practitioners who choose to adopt a new paradigm, the “paradigm pioneers,” must be very courageous, have faith, trust in their judgment, and be willing to take risks
  6. You can choose to change your rules and regulations – your paradigm
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What does it mean to go back to zero?

A

When a paradigm shift occurs, the playing field is leveled so that everyone (even leading companies in the old paradigm) starts from ground zero. Past success guarantees nothing.

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

What are the measures of information quality?

A
  1. Accuracy
  2. Completeness
  3. Consistency – does summary data equal the aggregation of the parts
  4. Uniqueness
  5. Timeliness
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is an entity?

A

Table of information; represents an object

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

What is an attribute?

A

Describes data

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

What are the different types of cardinalities?

A

One to one, One to Many, Many to Many

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

In One to Many cardinality where does the Primary Key go as a Foreign Key?

A

In the Many Entity as a Foreign Key

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

What do you need to do if it is a Many to Many Cardinality Relationship?

A

Create a linking table where each primary key from both entities become foreign keys in the new table

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

What is the textual representation of the ERD?

A
Entity Name (Primary Key (PK), Attribute, Attribute)
Ex: Crew(CrewID(PK), FName, LName, PhoneNum)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does PK stand for?

A

Primary Key

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

What does FK stand for?

A

Foreign Key

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

What is the efficiency ratio?

A

Output / Input (remember that bad/defective outputs don’t count
Ex: 100 Input, 90 Output with 10 Defective 90/100 = 90%

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

What is the Defect rate?

A

Defective / Output

Ex: Output was 100 with 10 Defective 10/100 = 10%

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

What is Gross Profit?

A

Sales – Costs (COGS)

17
Q

What is Gross Profit Margin?

A

Gross Profit / Sales

18
Q

What is Percentage of Difference?

A

((New – Old) / Old) * 100

19
Q

What is Paradigm paralysis?

A

Being afraid to change to the new paradigm

20
Q

What is the fastest cord and most expensive cord?

A

Fiber Optic

21
Q

What is VoIP?

A

Voice over Internet Protocol

22
Q

What is Cache Memory?

A

Primary Storage, processing memory

23
Q

What is Hard Drive?

A

Secondary Storage

24
Q

How many cores do you need to be able to multi-thread?

25
What are the different parts of SQL statements?
``` Select From Where Group By Order By ```
26
What symbol do you need when you use dates?
#1/1/2011#
27
What is the format for Like?
Like “*…”
28
If you have more than one table in SQL what do you have to do?
You have to link the tables with primary keys
29
In solver you can either _, _, or _ a certain formula?
Maximize, Minimize or set a certain value
30
What is transactional data?
Data in a row, raw information with no analysis
31
What is analytical data?
Data that has been analyzed in order to give you a clearer picture
32
What is hyper threading?
Using one core to perform two processes continuously without having to time slice either process
33
How do you know if a measure is a good measure?
It can be repeated by someone else and get the same results