Database Systems Flashcards
It consists of raw facts. The word raw indicates that the facts have not yet been processed to reveal their meaning.
Data
It is the result of processing raw data to reveal its meaning.
Information
It is a discipline that focuses on the proper generation, storage, and retrieval of data.
Data management
It consists of raw facts of interest to the end user
End-user data
It describes the data characteristics and the set of relationships that link the data found within the database
Metadata
It is a collection of programs that manages the database structure and controls access to the data stored in the database.
Database management system (DBMS)
It exists when different versions of the same data appear in different places.
Data inconsistency
It is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data.
Data quality
It 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
Historically, systems were often manual, paper-and-pencil systems. The papers within these systems were organized to facilitate the expected use of the data.
Manual File Systems
DP stands fo?
Data processing
Problems with File System Data Processing.
Data redundancy, Data anomalies
3 kinds of Data anomalies
Update anomalies, Insertion anomalies, and Deletion anomalies
A data abnormality in which inconsistent changes have been made to a database.
Data anomaly
It refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
Database system
