MIS 431 EXAM 1 STUDY GUIDE
Database - Answer -A shared, integrated computer structure that houses two types of
data: end-user data (raw facts) and metadata (data about data)
Database Management System (DBMS) - Answer -manages database structure,
controls access to data, contains query language
Importance of DBMS - Answer --makes data management more efficient and effective
-query language allows quick answers to ad hoc queries
-provides better access to more and better-managed data
-promotes integrated view of organization's operations
-reduces the probability of inconsistent data
Importance of good database design - Answer --poor design results in unwanted data
redundancy
-poor design generates errors leading to bad decisions
Practical approach to database design - Answer --focus on principles and concepts of
database design
-importance of logical design
Data - Answer -Raw facts
Field/attribute - Answer -group of characters with specific meaning
Record/Row/Tuple - Answer -Logically connected fields that describe a person, place,
or thing
Table - Answer -collection of related records
DBMS Functions - Answer -- data dictionary management
- data storage management
- Data transformation and presentation
- Security management
- Multiuser access control
- Backup and recovery management
- Data integrity management
- Database access languages and application programming interfaces
- Database communication interfaces
Database Models - Answer -collection of logical constructs used to represent data
structure and relationships within the database
Database - Answer -A shared, integrated computer structure that houses two types of
data: end-user data (raw facts) and metadata (data about data)
Database Management System (DBMS) - Answer -manages database structure,
controls access to data, contains query language
Importance of DBMS - Answer --makes data management more efficient and effective
-query language allows quick answers to ad hoc queries
-provides better access to more and better-managed data
-promotes integrated view of organization's operations
-reduces the probability of inconsistent data
Importance of good database design - Answer --poor design results in unwanted data
redundancy
-poor design generates errors leading to bad decisions
Practical approach to database design - Answer --focus on principles and concepts of
database design
-importance of logical design
Data - Answer -Raw facts
Field/attribute - Answer -group of characters with specific meaning
Record/Row/Tuple - Answer -Logically connected fields that describe a person, place,
or thing
Table - Answer -collection of related records
DBMS Functions - Answer -- data dictionary management
- data storage management
- Data transformation and presentation
- Security management
- Multiuser access control
- Backup and recovery management
- Data integrity management
- Database access languages and application programming interfaces
- Database communication interfaces
Database Models - Answer -collection of logical constructs used to represent data
structure and relationships within the database