Midterm Prep

Question 1

what is LAN

Answer 1

local area network: links personal computers together

Question 2

what is WAN

Answer 2

wide area network: internet, email

Question 3

vertical vs horizontal market application softwares

Answer 3

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

Question 4

proprietary vs open source softwares

Answer 4

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

Question 5

client vs server computers

Answer 5

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

Question 6

three components of information systems

Answer 6

people, process, technology

Question 7

three things managers need for decision making

Answer 7

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

Question 8

what are operational decisions

Answer 8

day to day activities

Question 9

what are composite primary keys

Answer 9

consists of more than one field

Question 10

what are atomic primary keys

Answer 10

consists of only one field

Question 11

difference between dimensions and measures in tableau

Answer 11

dimensions are qualitative, measures are quantitative

Question 12

what colour are dimensions in tableau

Answer 12

blue

Question 13

what colour are measures in tableau

Answer 13

green

Question 14

what is an innovator

Answer 14

first individual to adopt new technology

Question 15

what are early adopters

Answer 15

adopt new technology soon after release, after innovators

Question 16

what are early majority

Answer 16

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

Question 17

what are late majority

Answer 17

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

Question 18

what are laggards

Answer 18

last to adapt to an innovation, after late majority

Question 19

what is a software

Answer 19

computer program or set of programs

Question 20

what are the two types of software

Answer 20

application software and operating system

Question 21

how can software be obtained

Answer 21

bought or made

Question 22

what is text (data type)

Answer 22

for storing brief, non numeric data

Question 23

what is number (data type)

Answer 23

for storing number

Question 24

what is number (data type)

Answer 24

for storing number`

Question 25

what is boolean (data type)

Answer 25

data with only two possible values

Question 26

what is date / time (data type)

Answer 26

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

Question 27

what is currency (data type)

Answer 27

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

Question 28

what is paragraph text (data type)

Answer 28

data allows for text longer than 256 character

Question 29

what is object (data type)

Answer 29

inserts image or music file

Question 30

Define the term Database and identify the steps to creating one

Answer 30

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

Question 31

Describe the role of a Database Management System

Answer 31

software for creating, storing and accessing database files

Question 32

Describe the fundamental concepts of the Relational Database

Answer 32

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

Question 33

Describe the difference between a data warehouse and a data mart

Answer 33

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

Question 34

Understand the function of Business Intelligence and Data Analytics

Answer 34

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

Question 35

Distinguish between the types of decisions by organizational level and type

Answer 35

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

Question 36

Explain the differences between systems development methodologies

Answer 36

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

Question 37

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

Answer 37

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

Question 38

Compare the build vs buy decision

Answer 38

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

Question 39

Identify the four primary implementation policies

Answer 39

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)

Question 40

Explain the fundamentals of Project Management

Answer 40

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

Question 41

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

Answer 41

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

Question 42

Describe different types of E-Commerce

Answer 42

B2B B2C C2C C2B B2G C2G

Question 43

Understand the link between Organizational Strategy and Information Systems

Answer 43

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

Question 44

OLAP vs OLTP

Answer 44

OLTP collects raw data, OLAP uses data to make decisions

Question 45

types of project managament

Answer 45

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

Question 46

what uses transaction processing systems

Answer 46

operational decisions

Question 47

what uses management information systems

Answer 47

managerial decisions

Question 48

what uses executive information systems

Answer 48

strategic decisions