Term
|
Definition
|
|
Term
|
Definition
Recorded facts and numbers
|
|
|
Term
|
Definition
Knowledge derived from data
Data presented in a meaningful context
Data processed by summing, ordering, averaging, grouping, comparing or other similar operations |
|
|
Term
|
Definition
A set of components that interact to achieve some purpose or goal
|
|
|
Term
|
Definition
A system that has the goal of producing information |
|
|
Term
5 components of an IS Framework |
|
Definition
Hardware, software, data, procedures, people |
|
|
Term
|
Definition
A company's organized responce to the industry structure industry structure of the industry in which it operates, and thus, how to compete within that structure. |
|
|
Term
5 parts of Porter's 5 forces model |
|
Definition
bargaining power of customers, the availability ("threat") of substitutable products, the bargaining power of suppliers, the ease ("threat") of new competitors entering the industry, the rivalry between competitors. |
|
|
Term
Porter's Primary/Operational Activities |
|
Definition
-Inbound logistics: receiving, storing and distributing product inputs
-Manufacturing operations: transforming inputs into the final product
-Outbound logistics: collecting, storing, and distributing the product to buyers
-Sales and marketing: convincing customers to buy the product and selling it to them
-Customer service: assisting the customers in their use of the product
|
|
|
Term
Porter's Support Activities |
|
Definition
Procurement: managing supplier relationships and buying the product inputs
-Technology management: product research and development and new procedures, methods and techniques
-Human resources management: managing employee resources
-Firm infrastructure management: general management of the firm, finance, accounting, legal services, and government affairs
|
|
|
Term
|
Definition
A set of activities that transforms inputs into outputs
Inputs->activities->outputs
|
|
|
Term
|
Definition
Raw Materials > Assembly activities > Finished goods inventory |
|
|
Term
Manufacturing Process as it overlays Porter’s Operational Activities |
|
Definition
Inboundlogistics Raw Materials Inventory manufacturing operations Assembly activities Outbound logistics Finished goods inventory
|
|
|
Term
Business Process Modeling |
|
Definition
Business process modeling- the study and documentation of business processes.
Business process modeling notation (BPMN)- a commonly used system for drawing business process models. |
|
|
Term
|
Definition
|
|
Term
|
Definition
Several data that are shown up more than one that is not needed. Same information may be entered several times. |
|
|
Term
Problem of having multiple themes? |
|
Definition
Several data that are shown up more than once, that is not needed.
-same information may be entered several times.
|
|
|
Term
|
Definition
Deletion problems, update problems, insertion problems. |
|
|
Term
|
Definition
Stores information in tables. Each informational topic is stored in its own table.
A relational database will break-up a list into several parts- one part for each theme in the list.
|
|
|
Term
What does a relational database provide? |
|
Definition
It provides a solid foundation for user forms and reports. |
|
|
Term
Structure Query Language (SQL) |
|
Definition
An international standard for creating, processing and querying databases and their tables.
|
|
|
Term
What are the four compnents of a database system? |
|
Definition
users, Database Application, Database management System (DBMS), Database
|
|
|
Term
|
Definition
will use a database application to track things, use forms to enter, read, delete and query data, and produce reports.
|
|
|
Term
|
Definition
is a self-describing collection or related records, •contains the definition of its structure, Metadata is data describing the structure of the database data, Tables within a relation database are related to each other
|
|
|
Term
|
Definition
user data, metadata, indexes and overhead data, applicaton metadata. |
|
|
Term
Database management system (DBMS) |
|
Definition
Serves as an intermediary between database applications and the database.
|
|
|
Term
|
Definition
create databases, create tables, create supporting structures, read database data, modify database data (insert, update, and delete), maintain database structures,enforce rules, control concurrency, provide security, perform backup and recovery
|
|
|
Term
|
Definition
Ensure that the values of a column in one table are valid based on the values in another table. |
|
|
Term
|
Definition
A set of one or more computer programs between the use and the DBMS |
|
|
Term
Functions of a Database Applications |
|
Definition
Create and process forms, process user queries, create and process reports, executive application logic, control database applications |
|
|
Term
|
Definition
have one application, have only a few tables, are simple in design, involve only one computer, support one user at a time. |
|
|
Term
Enterprise-Class Database Systems |
|
Definition
Support several users, simulataneously, include more than one application, involve multiple computers, are complex in design, have many tables, have many databases. |
|
|
Term
Example of Desktop and Organizational DBMS Products |
|
Definition
Microsoft Access, Microsoft's SQL Server, Oracle's Oracle, Sun Microsystem's MySQL, IDM's DB2 |
|
|
Term
Difference between data, information, and knowledge |
|
Definition
Data: raw facts
Information: Collection of facts organized in such a way taht they have value beyond the facts themselves
Process: Set of logically related tasks
Knowledge: awareness and understanding of a set of information |
|
|
Term
Characterisitics of Valuable Information |
|
Definition
Accessible, accurate, complete, economical, flexible, relevant, reliable, secure, simple, timely, verifiable. |
|
|
Term
|
Definition
A set of interrelated elements that:
collect (input), manipulate (process), store, disseminate (output) data and information, provide a corrective reaction (feedback mechanism) to meet an objective. |
|
|
Term
Components of an(y) Information System? |
|
Definition
<-Feedback->input->processing->output-> |
|
|
Term
Input, Processing, Output, Feedback |
|
Definition
Input-activity of gathering and capturing raw data
Processing- converting data into useful outputs
Output- production of useful information, usually in the form of documents and reports
Feedback- Information from the system that is used to make changes to input or processing activities. |
|
|
Term
Computer-based Information system |
|
Definition
single set of hardware, software, databases, telecommunications, people, and procedures: that are configured to collect, manipulate, store, and process data into information.
Technology infrastructure: include all hardware, software, databases, telecommunications, people, and procedures. Configured to collect, manipulate, store, and process data into information. |
|
|
Term
Hardware, Software, and database |
|
Definition
Hardbase: consists of computer equipment used to input, processing, and output activities.
Software: consists of the computer programs that govern the operation of the computer.
Database: organized collection of facts and information, typically consisting of two or more related data files. |
|
|
Term
Telecommunications, networks, and internet |
|
Definition
Telecommunications, networks, and the Internet:The electronic transmission of signals for communications, Networks:Connect computers and equipment to enable electronic communication, Internet:World’s largest computer network, consisting of thousands of interconnected networks, all freely exchanging information
|
|
|
Term
|
Definition
Intranet:Internal network that allows people within an organization to exchange information and work on projects, Extranet:Network that allows selected outsiders, such as business partners and customers, to access authorized resources of a company’s intranet
|
|
|
Term
|
Definition
Intranet:
Internal network that allows people within an organization to exchange information and work on projects
Extranet:
Network that allows selected outsiders, such as business partners and customers, to access authorized resources of a company’s intranet
|
|
|
Term
Business Information system |
|
Definition
Most common types of information systems:
Those designed for electronic and mobile commerce, transaction processing, management information, and decision support
Some organizations employ:
Special-purpose systems, such as virtual reality, that not every organization uses
|
|
|
Term
|
Definition
Any business transaction executed electronically between:
Companies (business-to-business, B2B)
Companies and consumers (business-to-consumer, B2C)
Consumers and other consumers (consumer-to-consumer, C2C)
Business and the public sector
Consumers and the public sector
|
|
|
Term
|
Definition
Management, Suppliers E-procurement, Organization and its partners, customers e-commerce. |
|
|
Term
Transaction, and transaction processing systems |
|
Definition
Transaction:
Any business-related exchange, such as payments to employees and sales to customers
Transaction processing system (TPS):
Organized collection of people, procedures, software, databases, and devices used to record completed business transactions
|
|
|
Term
Enterprise Resource Planning |
|
Definition
Set of integrated programs that manages the vital business operations for an entire multisite, global organization
|
|
|
Term
Management Information System |
|
Definition
Organized collection of people, procedures, software, databases, and devices that provides routine information to managers and decision makers
|
|
|
Term
Decision Support System (DSS) |
|
Definition
Organized collection of people, procedures, software, databases, and devices that support problem-specific decision making
Can include:
A collection of models used to support a decision maker or user (model base)
A collection of facts and information to assist in decision making (database)
Systems and procedures (user interface or dialogue manager) that help decision makers and other users interact with the DSS
|
|
|
Term
Knowledge Management, Artificial Intelligence |
|
Definition
Knowledge management systems (KMSs):
Organized collection of people, procedures, software, databases, and devices to:
Create, store, share, and use the organization’s knowledge and experience
Artificial intelligence (AI):
Computer system takes on characteristics of human intelligence
|
|
|
Term
Expert Systems and Virtual Reality and Multimedia |
|
Definition
Expert systems:Give computer ability to make suggestions and function like an expert in a particular field
Virtual reality and multimedia:
Virtual reality: Simulation of a real or imagined environment that can be experienced visually in three dimensions Multimedia: Can include photos and images, the manipulation of sound, and special 3D effects
|
|
|
Term
Systems Development and Outsourcing |
|
Definition
Systems development:
The activity of creating or modifying existing business systems
Outsourcing:
Allows a company to focus on what it does best and delegate other functions to companies with expertise in systems development
|
|
|
Term
Investigation and Analysis |
|
Definition
Goal of systems investigation:To gain clear understanding of the problem to be solved or opportunity to be addressed
Systems analysis:Defines the problems and opportunities of the existing system
|
|
|
Term
Design, Implementation, and Maintenance and Review |
|
Definition
Systems design:Determines how new system will work to meet business needs defined during systems analysis
Systems implementation:Acquiring various system components defined in design step, assembling them, and putting the new system into operation
Systems maintenance and review:Checks and modifies the system so that it continues to meet changing business needs
|
|
|
Term
Global Challenges in Information systems |
|
Definition
Cultural challenges, Language challenges, Time and distance challenges, Infrastructure challenges, Currency challenges, Product and service challenges, Technology transfer issues, State, regional, and national laws, Trade agreements
|
|
|
Term
Types of Systems used within organizations |
|
Definition
E-commerce and m-commerce, TPS and ERP, MIS and DSS, and specialized business information systems
|
|
|
Term
|
Definition
the activity of creating or modifying existing business systems
Organization: formal collection of people and various other resources established to accomplish a set of goals |
|
|
Term
Information systems personnel typically work in an is department that employs |
|
Definition
A chief information officer, systems analyst, computer programmers, and computer operators |
|
|
Term
|
Definition
a two-dimensional table that has specific characteristics, consist of rows and columns
|
|
|
Term
Characteristics of a Relation |
|
Definition
Rows contain data about an entity, Columns contain data about attributes of the entity, Cells of the table hold a single value, All entries in a column are of the same kind, Each column has a unique name, The order of the columns is unimportant, The order of the rows is unimportant, No two rows may be identical
|
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
something of importance to a user that needs to be represented in a database. An entity represents one theme or topic.
entities are restricted to things that can be represented by a single table
|
|
|
Term
|
Definition
stores information in relations (special tables). Each informational topic is stored in its own relation (special table). Those relations are joined together using the value of the data in a common field.
|
|
|
Term
|
Definition
One (or more) columns of a relatin that (are) used to identify a row. |
|
|
Term
|
Definition
Data value is unique for each row. Consequently, the key will uniquely identify a row. |
|
|
Term
|
Definition
Data value may be shared among several rows. Consequently, the key will identify a set of rows. |
|
|
Term
|
Definition
A key that contains two or more attributes. For a key to be unique, it must often become a composite key. |
|
|
Term
|
Definition
A candidate key is called "candidate" because it is a candidate to become the primary key. A candidate key is a unique key. |
|
|
Term
|
Definition
A candidate key chosen to be the main key for the relation. If you know the value of the primary key, you will be able to uniquely identify a single row. |
|
|
Term
|
Definition
A unique, numeric value that is added to a relatio to server as the primary key that has no meaning to users and are usually hidden often used in plae of a composite primary key. |
|
|
Term
|
Definition
A primary key from one table placed into another table. |
|
|
Term
|
Definition
States that every value of a foreign key must match a value of an existing primary key. |
|
|
Term
|
Definition
means that no data was entered; different from a zero, space character or tab character |
|
|
Term
Alternative Meanings of Null Values |
|
Definition
Null is often ambiguous, the column values is not appropriate for the specific row, the column value is not decided, the column value is unknown. |
|
|
Term
|
Definition
A process of analyzing a relation to ensure that it is well formed, if a relation is normalized (well formed), rows can be inserted, deleted or modified without creating update anomalies
|
|
|