Database Management Systems Lecture Notes

These flashcards encompass key terms and definitions related to Database Management Systems as covered in the lecture.

Database Management System (DBMS)

A program used to create, process, and administer a database.

SQL

Structured Query Language, used to perform operations on databases.

Entity

Something the user wants to track, always singular (e.g., Order).

Attributes

Characteristics that describe an entity, e.g., Order_Number.

Primary Key

An attribute associated with one and only one entity, uniquely identifying it.

Cardinality

A term used to describe the relationships between entities, indicating maximum numbers.

Crows Feet

A notation used to represent multiple relationships in an Entity Relationship Model.

Enterprise DBMS

A type of DBMS that processes large organizational databases and supports many users.

Personal DBMS

A type of DBMS designed for smaller, simpler database applications.

Backup/Recovery

Functions provided by a DBMS to secure and restore databases.