Midterm Prep Flashcards

1
Q

what is LAN

A

local area network: links personal computers together

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

what is WAN

A

wide area network: internet, email

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

vertical vs horizontal market application softwares

A

horizontal does things that every market needs, vertical is specific to the market

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

proprietary vs open source softwares

A

proprietary: source code not open to the public
open source: source code available to the public

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

client vs server computers

A

client computers connect to servers to process information
server computers serve resources to client computers

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

three components of information systems

A

people, process, technology

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

three things managers need for decision making

A

knowledge (knowledge gained)
information (processed data)
data (raw facts)

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

what are operational decisions

A

day to day activities

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

what are composite primary keys

A

consists of more than one field

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

what are atomic primary keys

A

consists of only one field

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

difference between dimensions and measures in tableau

A

dimensions are qualitative, measures are quantitative

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

what colour are dimensions in tableau

A

blue

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

what colour are measures in tableau

A

green

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

what is an innovator

A

first individual to adopt new technology

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

what are early adopters

A

adopt new technology soon after release, after innovators

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

what are early majority

A

adopt new technology after a period of time, after early adopters

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

what are late majority

A

adopt new technology after the average member of society, after early majority

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

what are laggards

A

last to adapt to an innovation, after late majority

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

what is a software

A

computer program or set of programs

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

what are the two types of software

A

application software and operating system

21
Q

how can software be obtained

A

bought or made

22
Q

what is text (data type)

A

for storing brief, non numeric data

23
Q

what is number (data type)

A

for storing number

24
Q

what is number (data type)

A

for storing number`

25
Q

what is boolean (data type)

A

data with only two possible values

26
Q

what is date / time (data type)

A

subsection of number data type that can be interpreted as a time

27
Q

what is currency (data type)

A

subsection of number data type that can be interpreted as a currency

28
Q

what is paragraph text (data type)

A

data allows for text longer than 256 character

29
Q

what is object (data type)

A

inserts image or music file

30
Q

Define the term Database and identify the steps to creating one

A

organized collection of related information, created by collecting and relating data tables to one another

31
Q

Describe the role of a Database Management System

A

software for creating, storing and accessing database files

32
Q

Describe the fundamental concepts of the Relational Database

A

organizes data into inter-related tables, information is simple and easy to use

33
Q

Describe the difference between a data warehouse and a data mart

A

data warehouse is a large database used for management decision making. data mart is a data collection that is a subset of a data warehouse

34
Q

Understand the function of Business Intelligence and Data Analytics

A

business intelligence is the processes organizations take to collect and analyze data. data analytics looks at the past to understand what happened and make future predictions

35
Q

Distinguish between the types of decisions by organizational level and type

A

operational decisions: employees
managerial decisions: general management
strategic decisions: business executives

36
Q

Explain the differences between systems development methodologies

A

SDLC is long, with each sequence after one another like a waterfall
RAD is about putting out a product quickly and revising using feedback from users

37
Q

Describe the phases of the System Development Life Cycle (SDLC)

A

1) preliminary analysis
2) system analysis
3) system design
4) programming
5) testing
6) implementation
7) maintenance

38
Q

Compare the build vs buy decision

A

buying is less expensive, but may not fit the exact mold the company is looking for.
building is more expensive, but can be tailor made to a companies needs

39
Q

Identify the four primary implementation policies

A

direct cutover (immediate switch)
pilot implementation (one section switches and tests)
parallel operation (both run simultaneously)
phased implementation (functions of new application are gradually implemented)

40
Q

Explain the fundamentals of Project Management

A

1) initiation
2) planning
3) execution
4) monitoring and controlling
5) closing

41
Q

Define E-Business and E-Commerce and explain the difference between them

A

e-commerce generates revenue whereas e-business refers to all aspects of running a business online

42
Q

Describe different types of E-Commerce

A

B2B
B2C
C2C
C2B
B2G
C2G

43
Q

Understand the link between Organizational Strategy and Information Systems

A

people use information systems to gather the data necessary to make effective organizational strategy

44
Q

OLAP vs OLTP

A

OLTP collects raw data, OLAP uses data to make decisions

45
Q

types of project managament

A

traditional project management (TPM) and agile project management (APM)

46
Q

what uses transaction processing systems

A

operational decisions

47
Q

what uses management information systems

A

managerial decisions

48
Q

what uses executive information systems

A

strategic decisions