Database - Flashcards

Database

A collection of data stored for a specific purpose.

Database Management System (DBMS)

A software system that allows you to define, construct, and manipulate databases for various purposes.

Data Redundancy

The unnecessary duplication of data within a database, which is prevented by a DBMS.

Database Security

The protection of a database by restricting user access.

Flat File Database

A simple text file that stores data in a single table.

Relational Database

A complex database that stores information in multiple tables.

Database Design

A system that stores and retrieves data systematically from the database.

Efficiency

A factor to consider in database design that relates to the performance and speed of data retrieval.

Integrity

A factor in database design that ensures the accuracy and consistency of data.

Privacy

A factor in database design that protects personal information from unauthorized access.

Security

A factor in database design that safeguards data against threats and breaches.

Flexibility

A factor in database design that allows for easy modifications and adaptations to the database structure.

Data Model

A framework that determines the structure of data in a database, serving as its foundation.

Hierarchical Model

A data model where data is organized into a tree-like structure.

Network Model

A data model where a record can have multiple parent and child records.

Relational Model

A data model that represents a database as a collection of relation values resembling a two-dimensional table.

Object-Oriented Model

A type of data model that incorporates object-oriented programming principles.

Object-Relational Model

A data model that combines features of both relational and object-oriented models.

Domain

The set of defined atomic values for an attribute in a database.

Attribute

The name of a role played by a domain in a relation.

Tuple

Each row in a relation, representing a set of related data values.