MIS EXAM 2

________ are comprised of members from different geographic areas assembled as needed to collaborate on a certain project.

a. Work groups
b. Non-core teams
c. Command groups
d. Correct Response
e. Virtual teams
f. Task force

e. virtual team

Once the data model is created, the format of the data is documented in a data ________.

a. Incorrect Response
b. entry
c. domain
e. dictionary
f. warehouse
g. mart

e. dictionary

Which of the following best describes “Big Data”?

a. large volumes of data from a variety of sources

b. data where tables have Primary keys

c. data on USB drives instead of clay disks

d. none of the other options are correct

a. large volumes of data from a variety of sources

When we consider entities as tables, each column is a(n) ________.

a. attribute
b. applet
c. Incorrect Response
d. query
e. record
f. form

a. attributes

Which of the following is an example of synchronous communication?

a. online reviews
b. videoconferencing
c. work flow automation systems
d. e-mail
e. bulletin board systems

b. videoconferencing

The primary use of online transaction processing (OLTP) systems is to define a set of reachable and exploitable vulnerabilities present in a database.

a. True
b. False

b. False

Walmart is an example of a "Click and Mortar" business

a. True
b. False

a. True

Which of the following is true about firms pursuing a click and mortar business strategy?

a. these firms indulge in rafter bidding activities

b. these firms avoid indulgences in e-commerce

c. these firms are only involved in export business activities

d. these firms operate in both physical and virtual arenas

e. these firms avoid indulgences in physical store locations

d. these firms operate in both physical and virtual arenas

You want to sell a textbook from last semester online. Which e-commerce business model does this fall under?

a. B2B
b. None of the other options is correct
c. B2C
d. A2B
e. G2C

b. None of the other options is correct

it would be C2C

A(n) ________ is a compilation of data from a database that is organized and produced in printed format.

a. field
b. report
c. form
d. attribute
e. entity

b. Report

In the example COURSES table that follows, how do you know it is not normalized? [Note: primary key is underlined]

a. CourseID is the primary Key

b. None of the options are correct

c. Course Name is duplicated

d. Instructor information should be in course table

e. section is duplicated

c. Course Name is duplicated

In our WordPress assignment, we learned to create a site that discussed a tech talk. Which of the following could we do with WordPress?

	a)  Both: Add images, Embed video
	b)  All of: Normalize Data, Add images, Embed video
	c)  Embed video
	d)  Add images
	e)  Normalize data

a. Both: Add images, Embed Videos

An "Instance" of a person matches a _______ whereas a "collection" of people matches a ________.

a. Column; table
b. Row; field
c. Column; field
d. Table; key
e. Row; table

e. Row; table

The Network Effect refers to the notion that the value of a network

a. Decreases with the number of users in the network
b. Is only measurable on social networks like Facebook, Twitter, and LinkedIn
c. Is driven by how new it is (newer networks are more valuable)
d. Increases with the number of users in the network

d. Increases with the number of users in the network

_____________ is used in order to have small, well-defined tasks performed by a scalable ad hoc workforce for everyday people.

a. insourcing
b. nearshoring
c. crowdsourcing
d. disinntermediation
e. none of the above

c. crowdsourcing

E-Commerce

the exchange of goods/services/money among two entities supported by communication technology (the internet specifically)

Business to Consumer (B2C)

transaction between businesses and their customers

ex: person buying book from Amazon

Business to Business (B2B)

transaction among businesses

Consumer to business (C2B)

transaction between customer and business

ex: person offers their photography to shutterstock

Consumer to Consumer (C2C)

transaction between people not necessarility working together

person buying something from etsy from someone else

E-Government

used to increase efficiency and effectiveness

Government to Citizen (G2C)

reduces paper

ex: turbo tax

Government to Business (G2B)

License application

Government to Goverment (G2G)

Sharing documents over the internet to different branches of the government

Disintermediation

cutting out the middleman and reaching customers more directly and efficiently

E-banking and online brokerage

• paying bills online

• people can turn to multiple sites to get info about stock prices

Fintech

refers to technologies that support activities in the financial sector

Brick and Mortar

consist of retailers operating solely in physical retail stores

Click and mortar

online transactions and physical stores

Click only

consist of retailers who use online sales ONLY

The long tail

cater to niche markets in addition to mainstream markets to gain more customers

Mass Customization

generates additional value for customers and profits for produces

examples of brands that successfully implemented mass customization

Dell and Nike

both offer a lot of options

successful e-commerce

designing websites to meet online consumer needs

websites that meet needs: Structure firmness (most important)

no bad links, understandable error messages, privacy/security, speed

websites that meet needs: functional convenience (second important)

ease of use, simple navigation, user feedback, help features, one click ordering, flexible payment, order tracking

websites that meet needs: representational delight (3rd important)

aesthetically pleasing, professional look and feel, color/font/images, consistent layout, no clutter

internet marketing methods: Search marketing

• includes paid search

• placing ads on websites based on search terms and SEO

  • SEO (search engine optimization)

• optimizing a website and its relative search engine ranking

Internet marketing methods: Display Ads

Simple banner ads

• now often contextualized to what the person is viewing

Internet marketing methods: email marketing

• extremely low cost

• less than a penny an e-mail

• effectiveness is easy to track

Internet marketing methods: social media

used for interactive communication and relationship building with customers

Internet marketing methods: mobile marketing

if ads can be tailored to a user’s location, then highly targeted marketing opportunities open up

Internet marketing methods: payment; performance assessment

• impression

• pay per click/click through

• conversion models

  • beware of click fraud

SEO (Search engine optimization)

attempts to improve a page’s ranking in search engines

Reasons for increase in Mobile EC

• faster cell network

• powerful handheld device

• feature rich apps

• location based Mobile commerce (services tailored to location of someone)

• Information on the go (looking at reviews)

• product and content sales (actually buying things online)

Voice and conversational commerce

• smart devices and AI technology

• allows purchases using chat and voice commands

collaboration software

aka groupware; represents a class of software that enables people to work together more effectively

synchronous

live; real time communication (face to face)

asynchronous

not live, real time communication

Electronic meeting systems EMS

utilizes networked computers and sophisticated software to support various group tasks

Desktop Videoconferencing

• simple and low cost

• internet based

Dedicated videoconferecing

• organizational conferencing rooms

• multiple people and/or locations

• highly realistic/excellent video and audio quality

• can be extremely expensive (up to 500k)

Intranets and employee portals

share documents and information to people within the organization

Real time access to information

updated information instantly available throughout the organization

enterprise search

company focused, including corporate databases

collaboration

document sharing and co-editing

employee portals

employee benefits self service

Web 1.0

like myspace and stuff

super old; couldn’t function very well

Web 2.0

dynamic web application

• allows people to act as consumers and producers (like leaving a review on a product)

Evolving web capabilities: Web 1.0

• me

• consume

• connect ideas

• search

• find

• techies rule

• organization

evolving web capabilities: web 2.0

• me and you

• consume and create

• connect ideas and people

• receive and give recommendation to friends and others

• share

• user rule

• individual

evolving workspace

• generation of social media users

• different workplace expectations

• portfolio careers

• sate of the art tech is valued

• don’t just serve, but collaborate with customers

• companies now create a corporate culture that embraces trends of digital world

• embracing social media attracts and retains top talent

future web capabilities

the semantic web

• machine readable web page

Web 3.0

• mobility

• contextual web

enterprise 2.0

• leverage social media to support business processes

blogs

• topical blogs of interest to customers

• critics call blogs “amateurization of journalism”

• microblogging tools (like twitter)

  • post news to customers

Instant messaging

• within the company

  • with customers

virtual worlds

product showcase

media sharing

webcasting, podcasting

social bookmarking

• share internet bookmarks

  • reddit, pinterest

social cataloging

• good reads, IMDB

tagging

manually adding medata data to content

Collective intelligence

• open sourced software

• wikis

Human based computing (crowdsourcing)

takes advantage of individuals from all over the world of their knowledge, expertise and resources. can be done at a fraction of the cost of normal businesses

• open innovation: allows

M-Turk

crowdsourcing marketplace that makes it easier for individuals and businesses to outsource their processes and jobs

Viral marketing

• good marketing techniques can be driven by word of mouth or person to person communication

• the power of viral marketing can be a great tool

Pitfalls of social media marketin

• online reviews

  • negative reviews from competitors

  • companies paying for positive reviews

• microblogging

  • easy to “cross a line” and offend

  • negative publicity can come quickly

• social networks

  • fine line between maintaining control and offending customers

  • individuals sharing too much personal info

• lesson learned

  • news travels fast

  • have crisis team and a plan

  • prepare for worst SM nightmare

  • monitor environment

  • respond within 24 hours

What is BI

using IS to gather and analyze info from internal and external sources to make better business decisions

• uses PAST data to find out what happened

Advance analytics

tools and techniques used to understand why something happened, predicts future outcomes, or discover hidden patterns in large data sets

Business analytics

used as an umbrella term for BI and AA

big data

high volume, high variety, and high volocity

Structured data

part of high variety

semi-structured data

part of high variety

unstructured data

part of high variety

DBMS

software allow users and programmers to access and manage the database

• MSAccess

Database

collection of related tables

Tables (relation)

• condensed data of a specific thing

• made up of rows (records; tuple)

• made up of columns (attributes)

rows (records; tuple)

made up of atttributes (columns)

Primary Key

An attribute (column) that is unique across all records to allow us to distinguish one entity from another

advantages of Databases: minimal data redundancy

single copy of data

advantages of Databases: increase security

simplifies enforcement of access restrictions

advantages of Databases: enforce standards

centralized data management standardized rules

advantages of Databases: concurrency

eliminating redundancy improves consistency

OLTP (online transaction processing)

system that interact with customers and run a business in real time

data marts

mini data warehouse, limited in scope to organizational unit

OLAP (online analytical processing)

complex, multidimensional analyses of data beyond simple queries

• measures and facts

• dimensions

  • perspectives on which to view the facts

  • hierarchically arranged to enable drill down and roll up

OLAP cubes

multidimensional structure of dimensions and measures

Slicing and dicing (OLAP)

analyzing data on subset dimensions

Data mining

• discovering “hidden” predictive relationships in the data

• complicated algorithms run on large data warehouse

• types of data mining algorithms

data mining: association discovery

estimating what types of products are bought if someone buys something else

data mining: clustering

finding natural grouping based on similar metrics

data mining: classification

assigning data into predesigned categories