Shared Flashcard Set

Details

Information Systems
Exam 1 key terms and study guide
60
Computer Science
Undergraduate 4
02/13/2010

Additional Computer Science Flashcards

 


 

Cards

Term
Availability
Definition
The percentage of time that a system is capable of serving its intended function. amount of time that it needs downtime
Term
Reliability
Definition

used to calculate the probability of failure for a single solution component. One measure used to define a component or system's reliability is mean time between failures (MTBF). MTBF is the average time interval, usually expressed in thousands or tens of thousands of hours (sometimes called power-on hours or POH), that elapses before a component fails and requires service. MTBF is calculated by using the following equation:

MTBF = (total elapsed time - sum of downtime)/number of failures

 

A system is more reliable if it is fault tolerant. Fault tolerance is the ability of a system to continue functioning when part of the system fails. Fault tolerance is achieved by designing the system with a high degree of hardware redundancy. If any single component fails, the redundant component takes its place with no appreciable downtime.

Term
Data
Definition
facts used by programs to produce useful information
Term
Hardware
Definition
machinery, computer, cpu, and support equipments
Term
Software
Definition
computer programs and manuals, set of instructions, that direct circuitry in hardware
Term
Telecommunications
Definition
is the transmission of signals over a distance for the purpose of communication
Term
Information System
Definition
a 'bridge' between the business world and computer science
Term
Transaction Processing
Definition
is a set of information which process the data transaction in database system that monitors transaction programs (a special kind of program).
Term
Management Information System
Definition
Management information systems are distinct from regular information systems in that they are used to analyze other information systems applied in operational activities in the organization.
Term

Decision Support System

(EIS/DSS)

Definition
is a class of information systems (including but not limited to computerized systems) that support business and organizational decision-making activities. A properly designed DSS is an interactive software-based system intended to help decision makers compile useful information from a combination of raw data, documents, personal knowledge, or business models to identify and solve problems and make decisions.
Term
Chief Information Officer
Definition
Developer in the computer world
Term
Systems Analyst
Definition
The architect or Designer
Term
Programmer
Definition
Builder
Term
Administrator
Definition
also a builder, just another name for programmer
Term
Quality Assurance
Definition
Inspector
Term
Project Manager
Definition
Equivelant to General Contractor
Term
Component
Definition
different chips on the motherboard of the computer controlling different functions
Term
CPU
Definition
Central Processing Unit,
Term
RAM
Definition
random Access memory, volotile, but also very fast
Term
Bottleneck
Definition
Capacity, Speed, and Cost, all in direct opposition to eachother
Term
Cache
Definition
an intermediary between physical RAM and CPU, also volatile
Term
Virtual Memory
Definition
and extension to physical memory, much slower than ram
Term
Integrated component
Definition
put in systems to cut costs, is able to perform multiple functions but is very inflexible
Term
Port
Definition
input or output device
Term
Programming Language
Definition
an artificial language designed to express computations that can be performed by a computer
Term
Freeware
Definition
available for use without charge, usually not the whole version of the softwaree
Term
Compiled Software
Definition
many files combined in different ways for complex software
Term
Shareware
Definition
a free download trial version, also not usually the complete package
Term
OS
Definition
operation system, speaks to the computer in a language that it can understand, and makes it usable for peopel
Term
software suites
Definition
such as windows, microsoft, adobe etx.
Term
Utility Software
Definition
system software desingend to help analyze configure, optimize and maintain, such as defragmenting the hard drive etc.
Term
Scalability
Definition
how well an application can grow to meet increasing performance demands
Term
Reliability
Definition
probability of failure
Term
Portability
Definition
ability to reuse existing code, when transfered from one place to another, kind of like compatibility
Term
feasability
Definition
performing preliminary study to measure a projects viablilty
Term
Felxibility
Definition
how many different kinds of applications can it perform
Term
Database
Definition
Integrated collection of logically related records or files
Term
Flat File Database
Definition
plain text or binary file, oner record per line
Term
relational database
Definition
series of unordered tables related together
Term
tables
Definition
or relations, used to represent things in real life
Term
Fields
Definition
a single piece of information
Term
Primary Key
Definition
Unique Identifier for each rule of Data
Term
Foreign Keys
Definition
A foreign key is a column in a table used to reference a primary key in another table.
Term
Data Dependancies
Definition
how each piece of data is related to the other.
Term
Entities
Definition
real world objects distinguisable from other objects. such as a student or a building
Term
Data Mining
Definition
process of analyzing data and making it useful
Term
clustering
Definition
grouping according to logical relationships or consumer preferences
Term
Query
Definition
retrieving data from the data base
Term
Criteria
Definition
what do you need to get out of the system
Term

 

 

 

Aggregates

Definition
Term
Normal Forms
Definition
Describes one entity
no duplicate rows always a primary key
columns are unordered
rows are unordered
Term
First NOrmal form
Definition
all column values must be atomic
Term
Second normal form
Definition
in 1NF and every nonkey column in fully dependant on the entire primary key
Term
Third normal form
Definition
in 2NF all non key columns are mutually independant
Term
Normalization
Definition
process of simplifying the design of database so it achieves optimum structure
Term
Business Rules
Definition
important part of DB integrity, helps to organize and sift through data
Term
Data Integrity
Definition
forbids nulls in primary key column. no unmatched foreign key
Term
Cardinality
Definition
relationships between data tables, defines how each is linked to eachother, one to one, many to many, or one to many and so on.
Term
conceptual modeling
Definition
high level description of Data and Constraints
Term
physical modeling
Definition
direct DBMS into choice of underlying data layout in hopes of optimizing performance.
Supporting users have an ad free experience!