When you purchase a movie ticket online, the system must both reserve your seat and process your payment. If either step fails, the entire operation must be canceled. This all-or-nothing principle describes a:
Transaction (specifically Atomicity)
When you submit an SQL query, which internal component of the DBMS parses the query, checks it for correctness, and determines the most efficient way to access the data?
Query Processor
What is the defining characteristic of a relational database?
Data is organized into tables (relations) of rows and columns
The process of deciding to create an index on a frequently searched column belongs to which design phase?
Physical Design
A formal database model is a framework that specifies which three components?
Data structures, Operations, and Integrity Rules
In the relational model, what is a row, representing a single instance of an entity, also known as?
Tuple (or Record)
Which relational algebra operation returns only specified columns from a table?
PROJECT
What is a key difference between a mathematical set and a tuple?
A set is unordered and unique; a tuple is ordered and allows duplicates
