MIS 304 Exam 2

Ace your homework & exams now with Quizwiz!

FinTech (Financial Technology)

An industry known for championing software and technology in the financial sector. They're also popular for generally challenging traditional banking and incumbent institutions. - refers to technologies that support activities in the financial sector

What is E-Commerce?

The exchange of goods, services, and money among firms, between firms and their customers, and between customers, supported by communication technologies and, in particular, the Internet

Web 2.0 (Business 2.0)

The next generation of Internet use—a more mature, distinctive communications platform characterized by new qualities such as collaboration, sharing, and free. Web 2.0 applications shift a Web user's role from a passive consumer of content to its creator. - change how people interact and enable social media

Business-to-business (B2B)

Transactions among businesses ex: A manufacturer conducts business over the Web with its suppliers

Business-to-consumer (B2C)

Transactions between businesses and their customers ex: A person buys a book from Amazon

Consumer-to-business (C2B)

Transactions between customers and businesses Ex: A person offers his photography at shutterstock.com

Consumer-to-consumer (C2C)

Transactions between people not necessarily working together ex: A person purchases some memorabilia from another person via eBay

Which of the following is NOT an example of Crowdsourcing? a) Google docs b) OpenStreetMap c) GoFundMe d) Wikipedia e) Kickstarter

a) Google docs

Many companies have not been able to realize the full potential of a virtual world environment beyond just providing virtual showcases for their products. a) True b) False

a) True

AZT owns a small Fleet of trucks and books jobs through an online freight brokerage. Which e-commerce business model does AZT fall under? a) G2C b) B2B c) None of the other options is correct d) C2B e) A2B

b) B2B

Web 1.0 applications allow people to collaborate and share information online. a) True b) False

b) False

The Network Effect refers to the notion that the value of a network a) Is measurable only on social networks (e.g., Facebook, Twitter, LinkedIn) b) Increases with the number of users in the network c) Is driven by how new it is (i.e., newer networks are more valuable) d) Decreases with the number of users in the network e) None of the other options are correct

b) Increases with the number of users in the network

Recall the class-video where Sammi convinced people to give up their personal information. From what we learned, which of the following best describes why people gave up their personal information? a) They knew Sammi from before b) Sammi asked questions confidently and looked like he was officially representing an organization c) Two-factor authentication d) All of the other options are correct e) They did not believe in privacy, and wanted personal information to be public

b) Sammi asked questions confidently and looked like he was officially representing an organization

In context of databases, which of the following is/are true? a) The following terms are synonymous, i.e., Primary Key = Foreign Key b) The following terms are synonymous, i.e., Relation = Table c) The following terms are synonymous, i.e., Relation = Row d) All of the other options are correct e) The following terms are synonymous, i.e., Attribute = Tuple

b) The following terms are synonymous, i.e., Relation = Table

When we consider entities as tables, each column is a(n) ________. a) form b) attribute c) query d) record e) applet

b) attribute

Facebook is a good example of click-and-mortar company. a) true b) false

b) false

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

Security and performance of a website fall under which of the following categories? a)cost compliance b)structural firmness c)disintermediation capacity d)functional convenience e)representational delight

b) structural firmness

Cryptocurrencies

bitcoin offer an alternative to traditional payment methods. An advantage is low "processing" or transaction fees. They also offer anonymity for users. The drawbacks of cryptocurrencies include limited acceptance, governmental disapproval, and fluctuations in value.

A(n) ________ is a compilation of data from the database that is organized and produced in printed format. a) form b) field c) report d) entity e) attribute

c) Report

Why Is Blendtec Successful in their Marketing Videos? a) focus on big surprises and do not make sequels b) the videos are serious and focus on drama rather than humor c) the videos contain the unexpected/ have shock value d) because of freeconomics. they charge for blenders but the youtube videos are free e) none of the other options are correct

c) the videos contain the unexpected/ have shock value

Brick and Mortar

consists of retailers operating solely in physical retail stores - grocery store

click and mortar

consists of retailers who use both physical retail stores and online stores - apple, walmart, target

Click Only

consists of retailers who use online sales only - netflix, twitter

As discussed in our class, how does Amazon use databases on their website? a) Provide product recommendations based on order history b) Populate review data c) Welcome the user in a personalized way d) All of the other options are correct e) Retrieve product prices and images

d) All of the other options are correct

________ are comprised of members from different geographic areas assembled as needed to collaborate on a certain project. a) Command groups b) Work groups c) Task forces d) Virtual teams e) Non-core teams

d) Virtual teams

Which of the following statements is true about firms pursuing a click-and-mortar business strategy? a) these firms are only involved in export business activities b) these firms indulge in rafter bidding activities c) these firms avoid indulgence in physical store locations d) these firms operate in both physical and virtual arenas e) these firms avoid indulgence in electronic commerce

d) these firms operate in both physical and virtual arenas

Virtual Teams can benefit from a) Video conferencing b) Synchronous communication c) Video conferencing + Synchronous communication d) Asynchronous communication e) All of the above

e) All of the above

What are some of the problems with using a Spreadsheet for managing large datasets such as company transaction (e.g., order history) data? a) Spreadsheets are more expensive than databases b) We cannot analyze and summarize data using spreadsheets c) None of the other options are correct d) Spreadsheets are not suitable for storing numbers like product prices and quantities e) Difficulty in sharing the data across departments and users

e) Difficulty in sharing the data across departments and users

In context of databases, which of the following is/are true? a) The following terms are synonymous, i.e., Attribute = Tuple b) The following terms are synonymous, i.e., Relation = Row c) The following terms are synonymous, i.e., Primary Key = Foreign Key d) All of the other options are correct e) The following terms are synonymous, i.e., Tuple = Row

e) The following terms are synonymous, i.e., Tuple = Row

Data Lake

is a central repository that quickly ingests data (often in a raw format) and allows for storing structured, semi-structured, and unstructured data

GPS-enabled location-based services

location: Determining the basic geographic position of the cell phone mapping: Capturing specific locations to be viewed on the phone navigation: The ability to give route directions from one point to another tracking: The ability to see another person's location

Database:

made up of a number of related tables. For example you may store data on customers, orders, products, and shippers, all in your sales database.

The Long Tail

refers to being able to cater to a niche market owing to a broader reach which leads to a sufficiently large customer base. --> Although customers with unusual wants or needs may not be able to support a local storefront, there are often enough individuals in larger geographic regions to support an online merchant.

C2C EC: E-Auctions

§Individual sellers can sell or barter items at online auctions §Consumers place bids §Example: eBay.com §Revenue model based on small transaction fees, highly profitable

C2C EC: Online Classifieds

§Just advertising, no online transactions §Freecycling §Example: craigslist.com

Electronic Meeting System

An electronic meeting system utilizes networked computers and sophisticated software to support various group tasks.

New Revenue and Pricing Models

*Companies can earn revenues not only through traditional sales, but also through subscription, licensing, or transaction fees *Companies and individuals can earn money through Web advertising or affiliate marketing REVERSE PRICING

Social Commerce

*Utilizing social networks to build lasting relationships and advertise products

Design

- Conceptual Data model: A map or diagram that represents entities and their relationships (e.g., entity-relationship diagram). - Table design & Normalization: A process to make sure the database will operate efficiently. Helps to eliminate data duplication.

Representation Delight

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

C2C Opportunities & Threats

- Consumers can buy and sell to broader markets, potentially all over the world - Eliminates overheads of licensing and middlemen that increases the final price of products and services - Online markets are always available for consumers, 24/7/365 - Increases the numbers of buyers and sellers who can find each other - Market demand is an efficient mechanism for setting prices in the electronic environment THREATS: - No quality control - Higher risk of fraud - Harder to use traditional payment methods (checks, cash)

E-banking and online brokerage

- paying bills online using electronic bill pay - people can turn to multiple sites to get the latest information about stock prices

Drawbacks of e-tailing

- trust: This is especially a concern for new online businesses without a proven track record - direct product experience: E-tailing doesn't provide sensory information - product delivery and returns Except for direct downloads, e-tailing requires additional delivery time for products Returns may also be a hassle, compared to just going to the store

SQL Query

A command created using SQL database client software that operates directly on the record in a database SELECT AUTHOR, TITLE, PUBLICATION_DATE, PRICE FROM BOOKS WHERE AUTHOR = 'VALACICH' ORDER BY PUBLICATION_DATE;

Semantic Web

A component of Web 3.0 that describes things in a way that computers can understand - machine-readable web pages - enhanced search results

Data Dictionary

A document explaining information for each attribute (e.g., name, whether it is an identifier, data type, and valid values). Data type: Each attribute has a specified data type (e.g., text, numbers, or dates). Business rules: Prevent illegal or illogical entries from entering the database

Databases: Foundation Concepts

A table is made up of a number rows or records. Each row is made up of a series of attributes or columns

Enhancing Collaboration with Social Media

Cloud-Based Collaboration Tools Content Management Systems Collective Intelligence Human-Based Computing (Crowdsourcing)

Product and Content Sales

Consumers use mobile apps to make purchases while on the go

Information on the Go

Customers can get further information about a product wherever they are, including in the store, but this can lead to "showrooming"

Sources of BI Data

Databases, spreadsheets, reports and articles

Tables and Records

Each table has a number of rows also known as records or tuples * A row has a number of attributes or columns. To be precise, an attribute refers to the entire column. *At the intersection of each row and column, you have a specific value *A table will also have an identifier or primary key. This is the attribute that is unique across each record to allow us to distinguish one entity from another. So even two people had the same name, their IDs will be differen.

Functional Convenience

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

E-Mail Marketing

Extremely low cost, less than a penny an e-mail, and hence very popular; effectiveness also easy to track

Mass Customization

Generates additional value for customers and profits for producers customization allows efficient gathering of user requirements and tailoring a product to their needs at a reasonable cost. Ex: you can purchase a custom-built PC from the Dell website with hardware and software that matches your needs. (Dell and Nike)

Mobile Marketing

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

Group Buying

If many people agree to purchase the product or service, they get significant discounts takes advantage of the ability to organize people with specific interests or tastes online. Ex: Groupon and Livingsocial

Payment; Performance Assessment

Impression, pay-per-click/click-through, and conversion models (but beware of click fraud)

Search Marketing

Includes paid search, placing ads on search Web sites based on search terms, and SEO, optimizing a Web site and its relative search engine ranking

Social Media Marketing

Increasingly used for interactive communication and relationship building with customers

________ is an example of an electronic communication tool. Microsoft Outlook Apple FaceTime MS SharePoint Google Docs Google Hangouts

Microsoft Outlook

Databases Cost and Risks

Need for new, specialized personnel Installation and management cost and complexity Conversion costs Need for explicit backup and recovery Organizational conflict

Structural Firmness

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

Continuous BI Planning

Organizations must continuously monitor and analyze business processes. •Results lead to ongoing adjustments. •Involves decision makers from all levels.

Benefits of E-Tailing

Product Benefits: With no store size and shelf space restrictions, companies can sell a far wider variety of goods Place Benefits: Internet storefronts are available on almost every computer connected to the Internet Price Benefits: Online retailers are efficient, with high volumes and low overhead allow for very competitive pricing

Operational System

Run the business on a current basis Current representation of state of the business Online customers, clerks, salespersons, administration Narrow and simple updates and queries Performance

Search Engine Optimization (SEO)

SEO attempts to improve a page's ranking in search engines like Google. Techniques include having other pages link to the page, keeping content updated, and including key words.

Ad-hoc Queries and Reports

Scheduled reports Key-indicator reports Exception reports Drill-down reports Ad hoc queries

Location-Based M-Commerce

Services can be offered tailored to a person's needs based on their current location

Display Ads

Simple banner ads, but now often contextualized to what the person is viewing

Informational System

Support managerial decision making Historical or point-in-time (snapshot) Managers, business analysts, and customers (checking status and history) Broad and complex queries and analyses Ease of access and use

Why Is Blendtec Successful in their Marketing Videos? a) Focus on big surprises and do not make sequels b) None of the other options are correct c) Because of freeconomics. They charge for blenders but the YouTube videos are free d) The videos are serious and focus on drama rather than humor e) The videos contain the unexpected / have shock value

e) The videos contain the unexpected / have shock value

When we consider entities as tables, each row is a ________. a) bot b) form c) query d) field e) record

e) record

________ are produced at predefined intervals to support routine decisions. a) security reports b) key-indicator reports c) exception reports d) drill-down reports e) scheduled reports

e) scheduled reports

In a database management system (DBMS), data are kept separate from the applications' programming code. This means that ________. a) an application needs to be changed when the database is changed b) an application cannot be changed without making changes to the database c) an application's programming code needs to be updated continuously to keep up with the database d) the database needs to be changed when a change is made to an application e) the database does not need to be changed if a change is made to an application

e) the database does not need to be changed if a change is made to an application

Enhancing Connection with Social Media

social networking: §One of the most popular uses of the Internet §Facebook had 2.6 billion monthly active users as of April 2020 §Social Search (increase the relevance of search results) social search 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

Disintermediation

the cutting out of marketing channel intermediaries by product or service producers or the displacement of traditional resellers by radical new types of intermediaries - has enabled many firms to provide many financial services directly to the customer

E-Government

used by local, state and federal governments to increase efficiency and effectiveness, much like ecommerce used by businesses. ex: electronic filing of income tax returns, the online filing of business license applications, or the ability to share data electronically between different law enforcement agencies.

Databases Advantages

• Metadata is the key advantage of databases over other approaches to recording data as tables - enables content search • Two important roles in defining metadata - Identify the type of data: each different type of value is given a unique tag - Define the affinity of the data: Tags enclose all data that is logically related - Minimal data redundancy - Improved data consistency - Increase security Improved data quality - Improved data accessibility and sharing - Enforcement of standards - Program-data independence - Increased productivity of application development - Reduced program maintenance

Row (record)

•A record in a table. One row pertains to one entity instance.

Big Data

•Businesses are dealing with the opportunities and challenges of "Big Data" - High Volume o Unprecedented amounts of data - High Variety o Structured data o Semistructured o Unstructured data - High Velocity o Rapid processing to maximize value

Collaboration Software

•Collaboration software represents a class of software that enables people to work together more effectively •Collaboration software is distinguished along two dimensions: - Whether the software supports synchronous or asynchronous collaboration and communication - Whether the software supports groups working together face-to-face or distributed

Table

•Contains data about entities (i.e., the "thing" or object about which you want to track data, e.g., customers). Consists of rows and columns.

Content Management System (CMS)

•Content management systems allow users to publish, edit, version track, and retrieve digital information. - It creates accountability and responsibility by tracking what changes were made and by whom. -Documents, images, audio files, videos, or anything that can be digitized may be used with a content management system. TYPICAL ROLES: §Creator §Editor §Administrator §Guest

Databases: Inputs to BI applications

•Data, information and knowledge are among the most important assets for an organization. •Some type of database is behind every information system in all major companies •Databases are collections of related data organized in a way that facilitates data entry and searches. - Allows generation of dynamic and relevant content

Decision Support System (DSS)

•Decision-making support for recurring problems •Used mostly by managerial level employees (can be used at any level) •Interactive decision aid •What-if analyses - Analyze results for hypothetical changes

Column (attribute)

•One cell in a row. Each attribute contains a piece of information about the entity.

Basis of Core Information Systems

•Online Transaction Processing (OLTP) - Systems that interact with customers and run a business in real time •Data Warehouses - Integrate data from multiple databases and other data sources - Contain historic as well as current data •Data Marts - Mini data warehouse, limited in scope to organizational unit

Intranets and Employee Portals

•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

C2B EC

•Relatively new phenomenon, consumers can sell small pieces of work (e.g., photos) or services to businesses •It might be argued that anyone who made a living doing this is actually in business for themselves, so may be B2B

Legal Issues in EC

•Taxation - Sales taxes - Internet Freedom Act: Internet sales are treated like mail-order sales •Digital Rights Management - Preventing unauthorized duplication - Restrict which devices can play media - Limit number of times media can be played •Net Neutrality - Should the Internet be open? Or should Internet access come first to the highest bidder?

Uses of Business Intelligence and Advanced Analytics

•The need for business intelligence and advanced analytics goes beyond traditional businesses; all types of organizations utilize it to improve their data-driven decision making as seen in the examples below Political parties ex: Model the influence of social media on election outcomes Government ex: Analyze performance of public benefits programs Defense ex: Manage maintenance and logistics during overseas deployment Hospitals ex: Predict patient volume and resource utilization Nonprofit Organizations ex: Manage fundraising campaigns and target donors

Need for BI: Threats and Opportunities for the Organization

•Unstable markets •Competitive pressure •Consumer demands •Government regulations •Short product life cycles

What is Business Intelligence (BI) and analytics?

•Using information systems to gather and analyze information from internal and external sources in order to make better business decisions - involves taking raw data as input and generating reports or analyses that support decisions of the organization. To be successful, organizations must have up-to-date, accurate and integrated information to monitor and fine-tune a broad range of business processes.

Wikis

•Wiki: a Web site allowing people to §Post, edit, add, comment §Access information • •Wiki: a Web site that is linked to a database §Keeps history of prior versions and changes §Allows for reversing any edits • •Wikipedia is the most popular wiki.

Data Mart

•is a data warehouse that is limited in scope

Data Warehouse

•is an integrated repository that contains data across multiple years, usually organized by subject areas, e.g., customers, products, employees, etc.

Business Intelligence (BI)

•refers to tools and techniques for analyzing and visualizing past data and providing answers

Advanced Analytics

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


Related study sets

AFJROTC // Chapter 4: Russia and the Former Soviet Republics Exam

View Set

Phys 65 - Digestion and Absorption of GI

View Set

BUSINESS 100 MIDTERM PART 1 STUDY SET

View Set

Unit 4: Cell Communication & Cell Cycle Questions [MB, APClass, etc.]

View Set

2.1.2 - money market instruments

View Set

Government and Economics Unit 2 lesson 8 How a Bill becomes Law: Part 2

View Set