Lesson 3 Ite 5 Flashcards
refers to raw facts or figuresthat can be processed or analyzed to extract meaningful insights
Data
organized collection of data that is stored and managed in a structured format. It allows for efficient storage, retrieval, and manipulation of data.
database
software that provides an interface between users, applications, and the database. It manages data storage, retrieval, and manipulation, ensuring data integrity, security, and efficiency.
DBMS (DataBase Management System
encompasses the database itself along with the database management system (DBMS) and any associated applications and tools used to interact with the database.
database system
Physical devices and additional software required for the database’s operation.
Hardware & Software
User Aka
End-user
what is Meta data?
data about data
MySQL, PostgreSQL, Oracle, Microsoft SQL Server are examples of?
DBMS
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
data abnormality in which inconsistent changes have been made to a database. For example, an employee moves, but the address change is not corrected in all files in the database.
Data anomaly
The Database System Environment
hardware, software, people, procedures, and data.
This component includes all users of the database system.
People
Although the most readily identified software is the DBMS itself
Software
refers to all of the system’s physical devices, including computers
Hardware
are the instructions and rules that govern the design and use of the database system.
Procedures
