1/32
Comprehensive vocabulary flashcards covering fundamental Database Management System (DBMS) concepts, models, architectures, and office data management.
Database
An organized collection of related data stored, managed, and maintained systematically to enable easy access, retrieval, updating, and deletion.
Database Management System (DBMS)
The software that allows users to create, store, maintain, retrieve, protect, and control access to a database without interacting directly with raw files.
Data
Raw, unprocessed facts and figures that lack context and carry no clear meaning on their own.
Information
Data that has been processed, structured, and contextualized to make it meaningful, clear, and actionable for decision-making.
Traditional File System
A record-keeping approach where individual departments store information in separate, disconnected files or spreadsheets, often resulting in data duplication and inconsistency.
Data Integrity
The condition of maintaining accurate, valid, and reliable data through built-in rules, such as range and type constraints.
Data Consistency
The state where a single, unified, and correct version of a record is shared and synchronized across all departments and system users.
Procedures (DBMS Component)
The written guidelines, rules, and instructions governing how data is entered, verified, updated, and backed up within a database system.
Hierarchical Model
An early database structure arranged like a top-down tree or organizational chart, where each record has one parent and child records are restricted to a single parent.
Network Model
A database model standardized under CODASYL specifications where records are linked through complex networks, permitting a child record to have multiple parents.
Relational Model
A database architecture proposed by E. F. Codd in 1970 that organizes data into two-dimensional tables linked by shared key attributes.
Table
A structured collection of related data within a relational database consisting of rows and columns representing a specific entity.
Record
A single row within a database table representing a complete set of attributes for one specific entity.
Field
A specific column in a database table representing an individual attribute or data element with a defined data type.
Primary Key
A field or set of fields that uniquely identifies each record in a database table, preventing duplicate records and enabling table relationships.
Foreign Key
A field in one table that references the primary key of another table to establish a logical relationship between the two.
External Level
The tier in the three-level database architecture representing user-specific views and interfaces, such as forms or billing screens.
Conceptual Level
The middle tier in the three-level database architecture defining the entire logical design, including all tables, fields, and relationships.
Internal Level
The bottom tier in the three-level database architecture describing how data is physically arranged, stored, and indexed on physical media.
Query Processor
The DBMS component that receives user requests, analyzes their syntax, and verifies access permissions prior to execution.
Query Optimizer
The internal DBMS engine that evaluates possible execution plans and selects the fastest, most efficient route to retrieve requested data.
Storage Manager
The DBMS subsystem responsible for the direct physical reading and writing of database records to and from storage disks.
Data Dictionary (Metadata)
A centralized repository containing data about data, including definitions of tables, fields, constraints, data types, keys, and security permissions.
Physical Data Independence
The capacity to alter physical storage devices, servers, or disk paths without requiring changes to the conceptual schema or user application screens.
Logical Data Independence
The ability to modify the logical structure of a database, such as introducing a new column, without disrupting existing user screens or reports.
Database Administrator (DBA)
The technical role responsible for managing overall database design, user accounts, security permissions, backup operations, and performance tuning.
Lookup List
A standardized dropdown menu used in data entry interfaces to enforce data quality by preventing spelling errors and naming inconsistencies.
Full Backup
A complete data protection process where an entire database is copied in full, typically scheduled on a weekly basis.
Incremental Backup
A data protection method that copies only the records and modifications made since the most recent backup, usually performed daily.
Audit Trail
A chronological security log documenting which user accessed, created, altered, or deleted a specific record, along with the timestamp.
Republic Act 10173
The Data Privacy Act of 2012, a Philippine law regulating the collection, processing, confidentiality, and security of personal and sensitive medical information.
Two-Tier Architecture
A client-server database architecture where client machines interact directly with the database server without an intermediary application layer.
Three-Tier Architecture
A client-server design that places an application server between the client workstations and the database server to provide enhanced security and centralized business logic.