MIS 3140 EXAM 1 STUDY GUIDE
Data - Answers - Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
Field - Answers - A character or group of characters that has a specific meaning. A field
is used to define and store data.
Record - Answers - A logically connected set of one or more fields that describes a
person, place, or thing.
File - Answers - collection of related records
Ex: A file might contain data about the students currently enrolled at University.
data redundancy - Answers - the duplication of data, or the storage of the same data in
multiple places
data independence - Answers - A condition in which data access is unaffected by
changes in the physical data storage characteristics.
Database Management System (DBMS) - Answers - The collection of programs that
manages the database structure and controls access to the data stored in the database.
structural independence - Answers - A data characteristic in which changes in the
database schema do not affect data access.
What are the different types of databases? - Answers - Single-User
Multi- User
Logical Data Format - Answers - how a human being views the data
Physical Data Format - Answers - How the computer views the data.
Islands of Information - Answers - Scattered data locations, Increases the probability of
having different versions of
the same data
Data Redundancy sets the stage for: - Answers - Poor security
Inconsistency
Entry Errors
Integrity Problems
Data Integrity - Answers - all of the data in the database is consistent with the real-world
events and conditions.
Data is accurate
Data - Answers - Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
Field - Answers - A character or group of characters that has a specific meaning. A field
is used to define and store data.
Record - Answers - A logically connected set of one or more fields that describes a
person, place, or thing.
File - Answers - collection of related records
Ex: A file might contain data about the students currently enrolled at University.
data redundancy - Answers - the duplication of data, or the storage of the same data in
multiple places
data independence - Answers - A condition in which data access is unaffected by
changes in the physical data storage characteristics.
Database Management System (DBMS) - Answers - The collection of programs that
manages the database structure and controls access to the data stored in the database.
structural independence - Answers - A data characteristic in which changes in the
database schema do not affect data access.
What are the different types of databases? - Answers - Single-User
Multi- User
Logical Data Format - Answers - how a human being views the data
Physical Data Format - Answers - How the computer views the data.
Islands of Information - Answers - Scattered data locations, Increases the probability of
having different versions of
the same data
Data Redundancy sets the stage for: - Answers - Poor security
Inconsistency
Entry Errors
Integrity Problems
Data Integrity - Answers - all of the data in the database is consistent with the real-world
events and conditions.
Data is accurate
