Database Systems Flashcards
Efficient data management typically requires the use of a _________________.
COMPUTER DATABASE
Organized collection of logically related data
DATABASE
Data about data, through which the end-user data are integrated and managed
METADATA
Raw facts of interest to the end user
END-USER DATA
A collection of hardware, software, people, procedures and data
INFORMATION SYSTEM
What are the levels of management in an information system?
Corporate
Team, Division Unit
Individual
Level of management that comprises of information useful for the whole organization
CORPORATE
Also known as “global” information
CORPORATE
Policies and procedures, HR information, online forms, phone directory
CORPORATE
Level of management that covers all the information shared within teams, divisions, business units
TEAM DIVISION, BUSINESS UNIT
Project documentation, business unit specific content, meeting minutes
TEAM DIVISION, BUSINESS UNIT
Level of management that handles personal information needs of staff
INDIVIDUAL
Email, internal and external correspondence and reports
INDIVIDUAL
Collection of programs that manages the data base structure and controls access to the data stored in the database
DATABASE MANAGEMENT SYSTEM
Resembles a very well-organized electronic filing cabinet
DATABASE
If database is the very well-organized electronic filing cabinet. What helps manage the cabinet’s contents?
DATABASE MANAGEMENT SYSTEM
This role of DBMS helps create an environment in which end users have better access to more and better-managed data
IMPROVED DATA SHARING
This role of DBMS provides a framework for better enforcement of data privacy and security policies
IMPROVED DATA SECURITY
This role of DBMS promotes an integrated view of the organization’s operations and a clearer view of the big picture
BETTER DATA INTEGRATION
Exists when different versions of the same data appear in different places
DATA INCONSISTENCY
This role of DBMS makes it possible to produce quick answers to ad hoc queries
IMPROVED DATA ACCESS
A specific request issued to the DBMS for data manipulation
QUERY
A spur-of-the-moment question
AD HOC
QUERY
Comprehensive approach to promoting the accuracy, validity, and timeliness of the data
DATA QUALITY
Refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data
DATABASE DESIGN
How the database structure will be used to store and manage end-user data
DATABASE DESIGN
First step in designing a database
DATA MODELING
Process of creating a specific data model for a determined problem domain
DATA MODELING
A clearly defined area within the real world environment
PROBLEM DOMAIN
Well-defined scope and boundaries that are to systematically addressed
PROBLEM DOMAIN
Simple representation, usually graphical, of more complex real-world data structures
DATA MODEL