COMP 106: Introduction to Database Management Systems

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/32

flashcard set

Earn XP

Description and Tags

Comprehensive vocabulary flashcards covering fundamental Database Management System (DBMS) concepts, models, architectures, and office data management.

33 Terms

1
New cards

Database

An organized collection of related data stored, managed, and maintained systematically to enable easy access, retrieval, updating, and deletion.

2
New cards

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.

3
New cards

Data

Raw, unprocessed facts and figures that lack context and carry no clear meaning on their own.

4
New cards

Information

Data that has been processed, structured, and contextualized to make it meaningful, clear, and actionable for decision-making.

5
New cards

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.

6
New cards

Data Integrity

The condition of maintaining accurate, valid, and reliable data through built-in rules, such as range and type constraints.

7
New cards

Data Consistency

The state where a single, unified, and correct version of a record is shared and synchronized across all departments and system users.

8
New cards

Procedures (DBMS Component)

The written guidelines, rules, and instructions governing how data is entered, verified, updated, and backed up within a database system.

9
New cards

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.

10
New cards

Network Model

A database model standardized under CODASYL specifications where records are linked through complex networks, permitting a child record to have multiple parents.

11
New cards

Relational Model

A database architecture proposed by E. F. Codd in 1970 that organizes data into two-dimensional tables linked by shared key attributes.

12
New cards

Table

A structured collection of related data within a relational database consisting of rows and columns representing a specific entity.

13
New cards

Record

A single row within a database table representing a complete set of attributes for one specific entity.

14
New cards

Field

A specific column in a database table representing an individual attribute or data element with a defined data type.

15
New cards

Primary Key

A field or set of fields that uniquely identifies each record in a database table, preventing duplicate records and enabling table relationships.

16
New cards

Foreign Key

A field in one table that references the primary key of another table to establish a logical relationship between the two.

17
New cards

External Level

The tier in the three-level database architecture representing user-specific views and interfaces, such as forms or billing screens.

18
New cards

Conceptual Level

The middle tier in the three-level database architecture defining the entire logical design, including all tables, fields, and relationships.

19
New cards

Internal Level

The bottom tier in the three-level database architecture describing how data is physically arranged, stored, and indexed on physical media.

20
New cards

Query Processor

The DBMS component that receives user requests, analyzes their syntax, and verifies access permissions prior to execution.

21
New cards

Query Optimizer

The internal DBMS engine that evaluates possible execution plans and selects the fastest, most efficient route to retrieve requested data.

22
New cards

Storage Manager

The DBMS subsystem responsible for the direct physical reading and writing of database records to and from storage disks.

23
New cards

Data Dictionary (Metadata)

A centralized repository containing data about data, including definitions of tables, fields, constraints, data types, keys, and security permissions.

24
New cards

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.

25
New cards

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.

26
New cards

Database Administrator (DBA)

The technical role responsible for managing overall database design, user accounts, security permissions, backup operations, and performance tuning.

27
New cards

Lookup List

A standardized dropdown menu used in data entry interfaces to enforce data quality by preventing spelling errors and naming inconsistencies.

28
New cards

Full Backup

A complete data protection process where an entire database is copied in full, typically scheduled on a weekly basis.

29
New cards

Incremental Backup

A data protection method that copies only the records and modifications made since the most recent backup, usually performed daily.

30
New cards

Audit Trail

A chronological security log documenting which user accessed, created, altered, or deleted a specific record, along with the timestamp.

31
New cards

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.

32
New cards

Two-Tier Architecture

A client-server database architecture where client machines interact directly with the database server without an intermediary application layer.

33
New cards

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.