Shared Flashcard Set

Details

MIS
MIS- Test 2: Ch. 6
21
Business
Undergraduate 4
11/10/2010

Additional Business Flashcards

 


 

Cards

Term
A grouping of characters into a word, or group of words
Definition
Field
Term
A group of related fields
Definition
Record
Term
A group of records of the same type
Definition
File
Term
A group of related files
Definition
Database
Term
What does a record describe?
Definition
An entity
Term
What is an entity?
Definition
A person, place, or thing in which we store information
Term
This refers to each characteristic, or quality, describing an entity
Definition
Attribute
Term
The presence of duplicate data in files
Definition
Data redundancy
Term
This occurs when the same attribute may have different values
Definition
Data inconsistency
Term
This refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data
Definition
Program-data dependence
Term
A collection of data organized to serve many applications efficiently by centralizing the data and controlling the redundant data
Definition
Database
Term
This is a set of computer programs or software that controls the creation, maintenance, and the use of the database in a computer platform.
Definition
Database Management System (DBMS)
Term
There are two different views withing a DBMS:
Definition
Logical- this presents the data as they would be perceived by end users or business specialists
Physical- this shows how the data are actually organized and structured on physical storage media
Term
This system reduces data redundancy and inconsistency by minimizing isolated files in which the same are repeated
Definition
DBMS
Term
This is the most popular type of DBMS today for PC's- and this also stores data in tables and it is extracted and combined to whatever form or format the users needs
Definition
Relational DBMS
Term
What are rows commonly referred to as?
Definition
Records- or in very technical terms: Tuples
Term
This uniquely identifies each record: an example of this would be your social
Definition
Key field
Term
This is also a key field which is a unique identifier for each record
Definition
Primary key
Term
This is a lookup field to look up about the supplier of a specific part
Definition
Foreign key
Term
This is a database that stores current and historical data of potential interest to decision makers throughout the company
Definition
Data warehouse
Term
This provides concrete methods of analyzing exactly what customers want and how best to supply them
Definition
Business Intelligence
Supporting users have an ad free experience!