BUS220 - Week 2 Flashcards

Cover Week 2 Material

1
Q

Difficulties in Managing Data

A

–Amount of data increases exponentially.
–Data are scattered and collected by many individuals using various methods and devices.
–Data come from many sources.
–Data security, quality and integrity are critical.
–An ever-increasing amount of data needs to be considered in making organizational decisions.
–Huge quantities must be kept for a long time
–Data are scattered across locations in an organization
–External data must be included to support decision making
Review:
–Huge quantities must be kept for a long time
–Data are scattered across locations in an organization
–External data must be included to support decision making
–Data security, quality and integrity are essential but difficult to ensure

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

Describe the data lifecycle.

A

–Data is acquired from internal, external and personal sources
–Data is converted into the format required for a data warehouse and/or data mart
–Data is analyzed with data analysis and data mining tools
–The results is generation of decision support and knowledge that provides solutions to organizational problems.
–In short, data is transformed into knowledge and solutions

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

.Data, Information, Knowledge, Wisdom

A
Wisdom
^
Knowledge
^
Information
^
Data

Data is foundation

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

Database management system

A

(DBMS) provides all users with access to all the data.

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

DBMSs minimize the following problems

A

–Data redundancy
–Data isolation
–Data inconsistency

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

DBMSs maximize the following issues:

A

–Data security
–Data integrity
–Data independence

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

Data Hierarchy

A
Bit
Byte
Field
Record
File (or table)
Database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Designing the Database

A

–Entity
–Attribute
–Primary key
–Secondary keys

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

entity-relationship (ER) modeling.

A

Database designers plan the database design

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

ER diagrams consists of

A

consists of entities, attributes and relationships.
–Entity classes
–Instance
–Identifiers

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

What is a data model?

A

–A diagram that represents entities in the database and their relationships to each other

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

What are primary and secondary keys?

A

–A primary key is the field in a record that uniquely identifies that record so it can be retrieved, updated and stored.
–A secondary key is any other field that has some identifying information but typically does not identify the specific record.

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

BIS/220 – INTRODUCTION TO COMPUTER APPLICATION AND SYSTEMS
24
What is an entity?

A

–An entity is a person, place, thing or event about which information is maintained.

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

What is a relationship?

A

–A relationship is the way in which entities are associated with each other.

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

Name the three types of entity relationships.

A

–One to one
–One to many
–Many to many

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

Database Management Systems

A

Database management system (DBMS)
Relational database model
Structured Query Language (SQL)
Query by Example (QBE)

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

Normalization

A

method for analyzing and reducing a relational database to its most streamlined form for:
–Minimum redundancy
–Maximum data integrity
–Best processing performance
Normalized data is when attributes in the table depend only on the primary key
-Normalization Produces Order

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

Data Warehousing

A

–Data warehouses are organized by business dimension or subject.
–Data warehouses are multidimensional.
–Data warehouses are historical.
–Data warehouses use online analytical processing.

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

Benefits of Data Warehousing

A

End users can access data quickly and easily via Web browsers because they are located in one place.
End users can conduct extensive analysis with data in ways that may not have been possible before.
End users have a consolidated view of organizational data.

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

Data Marts

A

A data mart is a small data warehouse, designed for the end-user needs in a strategic business unit (SBU) or a department.

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

Data Governance

A

Data governance
Master data management
Master data

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

Knowledge Management

A

Knowledge management (KM)
Knowledge
Intellectual capital (or intellectual assets)

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

Knowledge Management (continued)

A

Explicit Knowledge (above the waterline)
Tacit Knowledge
(below the waterline) (Iceberg Picture, just the tip shows for explicit knowledge)
Knowledge management systems
–Use of information technologies to systematize, enhance, and expedite intra-firm and inter-firm knowledge management.
Best practices
–The most effective and efficient ways of doing things.

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

Connected computers:

A

Work together
Are interdependent
Exchange data with
each other

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

Network Applications - Discovery

A
Discovery
–Search Engine
–Meta-Search Engine
–Foreign Language Translation
–Portals
26
Q

Network Applications - Communications

A

–E-mail
–Web-based Call Centers
–VOIP

27
Q

Network Applications - Collaboration

A
–Virtual collaboration
–Workflow technologies
–Groupware
–Teleconferencing
–Videoconference
–Web conferencing
–Real-time collaboration tools
28
Q

Network Applications - web services

A

–eXtensible Mark-up Language (XML)
–Simple Object Access Protocol (SOAP)
–Web Services Description Language (WSDL)
–Service Oriented Architecture (SOA)

29
Q

Describe the three network applications that we discussed in this section and the tools and technologies that support each on

A

–Discovery: search engines, meta-search engines, sites with material in foreign languages and portals
–Communications: emails, call centers, chat rooms and VoIP
–Collaboration: workflow technologies, groupware, teleconferencing and whiteboards.

30
Q

(RSS)

A

Really Simple Syndication

31
Q

Web 2.0 websites are interactive

A

–AJAX: Allows portions of Web pages to reload without reloading the entire page.
–Tagging: Allows user to place information in multiple overlapping associations vs rigid categories.
–Blogs: Websites open to the public where the site creator expresses his or her feelings and opinions.
–Wikis: Site in which anyone can post material and make changes to other material.
–RSS: Allows users to receive information they want when they want it without having to surf thousands of websites.
–Podcasts: Digital audio file distributed over the Web
–Videocasts: Digital video file distributed over the Web

32
Q

Benefits of E-Learning

A

Self-paced learning increases content retention.
Online materials deliver high-quality, current content.
Students have the flexibility of learning from any place at any time at their own pace.
Learning time generally is shorter, and more people can be trained due to faster training time.
Training costs can be reduced.

33
Q

Drawbacks of E-Learning

A

Instructors may need training to be able to teach electronically.
The purchase of additional multimedia equipment may be necessary.
Students must be computer literate and may miss the face-to-face interaction with instructors.
There are issues with assessing students’ work, as instructors really do not know who completed assignments.

34
Q

Telecommuting

A

allows workers to work anytime and anyplace.

BIS/

35
Q

Electronic Commerce (E-Commerce, EC)

A

Pure versus Partial Electronic Commerce depends on the degree of digitization involved.
–Brick-and-mortar organizations
–Virtual organizations
–Click-and-mortar organizations

36
Q

E-Business

A
Business-to-Consumer (B2C)
Business-to-Business (B2B)
Consumer-to-Consumer (C2C)
Business-to-Employee (B2E)
E-Government
Mobile Commerce (m-commerce)
37
Q

Benefits of E-Commerce

A

Benefits to organizations
–Makes national and international markets more accessible
–Lowering costs of processing, distributing, and retrieving information
Benefits to customers
–Access a vast number of products and services around the clock (24/7/365)
Benefits to Society
–Ability to easily and conveniently deliver information, services and products to people in cities, rural areas and developing countries.

38
Q

Limitations of E-Commerce

A

Technological Limitations
–Lack of universally accepted security standards
–Insufficient telecommunications bandwidth
–Expensive accessibility
Non-technological Limitations
–Perception that EC is unsecure
–Unresolved legal issues
–Lacks a critical mass of sellers and buyers

39
Q

Define e-commerce and distinguish it from e-business

A

E-commerce describes buying and selling of products, services and information via computer networks, primarily the Internet.
–E-business expands the definition of e-commerce to include more than buying and selling, but also servicing customers, collaborating with business partners and conducting electronic transactions within and organization.
BIS/

40
Q

Types of electronic commerce

A

–Business-to-consumer: B2C involves companies directly selling to consumers over the Internet.
–Business-to-business: B2B occurs when two or more businesses make transactions electronically
–Consumer-to-Consumer: C2C occurs when consumers transact business over sites which allow direct selling of goods or services to other consumers, such as eBay.com or other auction sites.
–Business-to-employee: B2E occurs when an employer using electronic commerce internally to provide information and services to its employees such as training, discounted insurance, travel packages and tickets to events.

41
Q

E-government

A

Describes the use of Internet technology in general and e-commerce in particular to deliver information and public services to citizens, public employees, business partners, and suppliers.

42
Q

Forward Auction

A

Used by sellers as a selling channel to many potential buyers. Buyers competitively bid on the item until the auction closes with the highest bidder winning

43
Q

Reverse Auction

A

The buyer seeks to buy a product or service and suppliers submit bids. Generally, the lowest priced bidder wins.

44
Q

Drivers of today’s online advertising

A
The emergence of “communitainment.”
The increasing popularity of Usites.
Mainstreaming of the Internet.
Declining usage of traditional media.
Fragmentation of content consumption.
Consumers are multitasking and they do not like ads.
45
Q

Communitainment

A

–Blending of community, communication, and entertainment into a new form of online activity
•Social networking, video, and photo sharing sites
–Driven by consumers
–Consumers will shift more than 50% of their content consumption over the next decade to communitainment formats (Piper Jaffray, 2007)
•Displacing traditional forms of media content like TV, magazines, and large Internet sites.
This trend presents a major challenge for advertisers
Why?
Google it! - combination of communication and entertainment

46
Q

Eight types of sites

A

Portals: most popular; best for reach but not targeting

  • Search: second largest reach; high advertising value
  • Search: second largest reach; high advertising value
  • Commerce: high reach; not conducive to advertising
  • Entertainment: large reach; strong targetability
  • Community: emphasize being a part of something; good for specific advertising
  • Communications: not good for branding; low targetability
  • News/weather/sports: poor targetability
  • Games: good for very specific types of advertising
47
Q

Electronic Payments

A
Electronic payment systems enable you to pay for goods and services electronically.
Electronic checks (e-checks)
Electronic credit cards
Purchasing cards
Electronic cash
Stored-value money cards
Smart cards
Person-to-person payments
48
Q

Ethical and Legal Issues

A

Ethical Issues
Privacy
Disintermediation

49
Q

Electronic Payments

A
Electronic payment systems enable you to pay for goods and services electronically.
Electronic checks (e-checks)
Electronic credit cards
Purchasing cards
Electronic cash
Stored-value money cards
Smart cards
Person-to-person payments
50
Q

Legal Issues Specific to E-Commerce

A
Fraud on the Internet
Domain Names
Domain Tasting
Cybersquatting
Taxes and other Fees
Copyright
BIS/
51
Q

customer relationship management (CRM)

A

It costs six times more to sell to a new customer than to sell to an existing one.
A typical dissatisfied customer will tell 8-10 people.
By increasing the customer retention rate by 5%, profits could increase by 85%.
Odds of selling to new customers = 15%, compared to the odds of selling to existing customers (50%)
70% of complaining customers will remain loyal if their problem is solved

52
Q

Tenets of CRM

A

One-to-one relationship between a customer and a seller.
“Treat different customers differently.”
Keep profitable customers and maximize
lifetime revenue from them.

53
Q

Operational CRM-Two major components of operational CRM:

A

Customer-facing applications

Customer-touching applications

54
Q

Customer-Touching Applications

A

Search and comparison capabilities
Technical and other information and services
Customized products and services
Loyalty programs

55
Q

Customer-Facing Applications

A

Customer service and support
Sales force automation
Marketing
Campaign management

56
Q

Analytical CRM

A

systems analyze customer behavior and perceptions in order to provide actionable business intelligence.

57
Q

Types of Software-System control programs

A
  • System support programs
  • System utilities
  • System performance monitors
  • System security monitors
58
Q

Types of Software-–Operating system (Windows 7, Linux)

A
  • Multitasking/multiprogramming
  • Multithreading
  • Multiprocessing
  • Virtual Memory
  • Graphical user interface (GUI)
  • Social interface
59
Q

Types of Software - applications

A

–Proprietary application software
–Contract software
–Off-the-shelf application software Package

60
Q

Programming Languages

A

First-generation language or Machine Language
Second-generation language or Assembly language
Third-generation language or Procedural language
Fourth-generation language or Non-procedural language
Visual programming languages

61
Q

Object-Oriented Languages

A
Hypertext
Hyperlinks
Hypertext document
Hypertext markup language (HTML)
Extensible markup language (XML)