Shared Flashcard Set

Details

CIS Exam 1 Flashcards
Flashcards for Exam 1
80
Computer Science
Undergraduate 1
02/10/2013

Additional Computer Science Flashcards

 


 

Cards

Term
Purpose of a Database
Definition
To keep track of things
Term
Data
Definition

Recorded facts and numbers

Term
Information
Definition

Knowledge derived from data

Data presented in a meaningful context

Data processed by summing, ordering, averaging, grouping, comparing or other similar operations

Term
System
Definition

A set of components that interact to achieve some purpose or goal

Term
Information system
Definition
A system that has the goal of producing information
Term
5 components of an IS Framework
Definition
Hardware, software, data, procedures, people
Term
Competitive strategy
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
The Business Process
Definition

A set of activities that transforms inputs into outputs

Inputs->activities->outputs

Term
Manufacturing Process
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
Purpose of a Database
Definition
To keep track of things
Term
Redundant Data
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
Modification Issues
Definition
Deletion problems, update problems, insertion problems.
Term
Relational Databases
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
User
Definition

will use a database application to track things, use forms to enter, read, delete and query data, and produce reports.

Term
Database
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
Database Concepts
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
Functions of a DBMS
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
Referential Integrity
Definition
Ensure that the values of a column in one table are valid based on the values in another table.
Term
Database Applications
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
Personal Database System
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
Information System
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
Intranet and Extranet
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
People and Procedures
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
Electronic eCommerce
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
E-Business
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
Systems Development
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
Relation
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
Table Synonym
Definition
Row or column
Term
File Synonym
Definition
Record or Field
Term
Relation  Synonym
Definition
Tuple or Attribute
Term
Entity
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
Relational Databases
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
A Key
Definition
One (or more) columns of a relatin that (are) used to identify a row.
Term
Unique key
Definition
Data value is unique for each row. Consequently, the key will uniquely identify a row.
Term
Nonunique Key
Definition
Data value may be shared among several rows. Consequently, the key will identify a set of rows.
Term
A Composite Key
Definition
A key that contains two or more attributes. For a key to be unique, it must often become a composite key.
Term
Candidate Key
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
Primary Key
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
Surrogate Key
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
Foreign Key
Definition
A primary key from one table placed into another table.
Term
Referential Integrity
Definition
States that every value of a foreign key must match a value of an existing primary key.
Term
Null Value
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
Normalization
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

Supporting users have an ad free experience!