Introduction to Database Management System

Flashcards covering key concepts of Database Management System based on lecture notes.

Database Management System (DBMS)

A software for creating and managing databases.

Data Abstraction

The process of hiding irrelevant details from users in a database system.

Data Redundancy

Unnecessary duplication of data that DBMS aims to reduce by storing data centrally.

Atomicity

A transaction property where a transaction must fully complete (100%) or not at all (0%).

Integrity Constraints

Rules that ensure the accuracy and consistency of data in a database.

Naive Users

Unsophisticated users who interact with the database through user-friendly applications without technical knowledge.

Candidate Key

A subset of a superkey that uniquely identifies each record in a table.

Primary Key

A candidate key selected by database designers to uniquely identify tuples in a relation.

Foreign Key

An attribute in one table that links to the primary key in another table.

Relational Algebra

A formal system for manipulating relations (tables) in a relational database.

Set Operators

Operators that combine the results of two or more queries into a single result.

Outer Join

A join that returns all records from one table and the matched records from the other table, padding with NULLs where there is no match.

Division Operator

An operator used to find tuples in one relation that are associated with all tuples of another relation.

Selection Operator (σ)

An operator used to select rows from a relation that satisfy a given condition.

Projection Operator (∏)

An operator that selects specific columns from a relation, removing duplicates.

Join Operation

Combines records from two or more tables based on a related column.

Mapping and Data Independence

The ability to change the schema at one level of the database without affecting other levels.