Introduction to Database Management Systems (DBMS)

A set of flashcards covering key concepts, terms, and definitions related to Database Management Systems (DBMS) as discussed in the lecture.

Database

An organized collection of interrelated data.

DBMS

A software that provides a way to access and manage data stored in databases.

Data redundancy

The unnecessary duplication of data in multiple file formats.

Integrity constraints

Rules that ensure data integrity, such as account balance must be greater than zero.

Atomicity of updates

A property ensuring that a series of operations either fully complete or do not happen at all.

Concurrent access

Multiple users accessing or manipulating the same data at the same time.

Meta-data

Data about other data, such as file size and modification dates.

Data models

Conceptual tools that describe data, relationships, semantics, and constraints.

Relational Model

A way to represent data in tables, where columns are attributes and rows are tuples.

Naïve users

Users without knowledge of databases who interact through predefined user interfaces.

Sophisticated users

Professionals who use database query languages and data analysis software.

Database Administrator (DBA)

The individual responsible for managing and overseeing the database system.

Instances and Schema

An instance is the data in the database at a given moment, while schema is the overall design.

Physical schema

The overall physical structure of how data is stored in the database.

View level

The highest level of abstraction where users interact with the database system.