Midterm Prep Flashcards
what is LAN
local area network: links personal computers together
what is WAN
wide area network: internet, email
vertical vs horizontal market application softwares
horizontal does things that every market needs, vertical is specific to the market
proprietary vs open source softwares
proprietary: source code not open to the public
open source: source code available to the public
client vs server computers
client computers connect to servers to process information
server computers serve resources to client computers
three components of information systems
people, process, technology
three things managers need for decision making
knowledge (knowledge gained)
information (processed data)
data (raw facts)
what are operational decisions
day to day activities
what are composite primary keys
consists of more than one field
what are atomic primary keys
consists of only one field
difference between dimensions and measures in tableau
dimensions are qualitative, measures are quantitative
what colour are dimensions in tableau
blue
what colour are measures in tableau
green
what is an innovator
first individual to adopt new technology
what are early adopters
adopt new technology soon after release, after innovators
what are early majority
adopt new technology after a period of time, after early adopters
what are late majority
adopt new technology after the average member of society, after early majority
what are laggards
last to adapt to an innovation, after late majority
what is a software
computer program or set of programs
what are the two types of software
application software and operating system
how can software be obtained
bought or made
what is text (data type)
for storing brief, non numeric data
what is number (data type)
for storing number
what is number (data type)
for storing number`
what is boolean (data type)
data with only two possible values
what is date / time (data type)
subsection of number data type that can be interpreted as a time
what is currency (data type)
subsection of number data type that can be interpreted as a currency
what is paragraph text (data type)
data allows for text longer than 256 character
what is object (data type)
inserts image or music file
Define the term Database and identify the steps to creating one
organized collection of related information, created by collecting and relating data tables to one another
Describe the role of a Database Management System
software for creating, storing and accessing database files
Describe the fundamental concepts of the Relational Database
organizes data into inter-related tables, information is simple and easy to use
Describe the difference between a data warehouse and a data mart
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
Understand the function of Business Intelligence and Data Analytics
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
Distinguish between the types of decisions by organizational level and type
operational decisions: employees
managerial decisions: general management
strategic decisions: business executives
Explain the differences between systems development methodologies
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
Describe the phases of the System Development Life Cycle (SDLC)
1) preliminary analysis
2) system analysis
3) system design
4) programming
5) testing
6) implementation
7) maintenance
Compare the build vs buy decision
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
Identify the four primary implementation policies
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)
Explain the fundamentals of Project Management
1) initiation
2) planning
3) execution
4) monitoring and controlling
5) closing
Define E-Business and E-Commerce and explain the difference between them
e-commerce generates revenue whereas e-business refers to all aspects of running a business online
Describe different types of E-Commerce
B2B
B2C
C2C
C2B
B2G
C2G
Understand the link between Organizational Strategy and Information Systems
people use information systems to gather the data necessary to make effective organizational strategy
OLAP vs OLTP
OLTP collects raw data, OLAP uses data to make decisions
types of project managament
traditional project management (TPM) and agile project management (APM)
what uses transaction processing systems
operational decisions
what uses management information systems
managerial decisions
what uses executive information systems
strategic decisions