Database Systems, unit: The Relational Model. Core concepts, terminology, and worked-example cues a college student meets for this unit, building on prior units without repeating them. Front: a term, concept, or short problem cue. Back: the definition, explanation, or answer.
38 cards · basic cards · AI-written, checked twice. Edit anything.
- What is a database?
Show answer
An organized collection of structured data stored and accessed electronically- What is the relational model?
Show answer
A model that organizes data into tables (relations) of rows and columns- What is a relation, in relational database terms?
Show answer
A table consisting of rows (tuples) and columns (attributes)- What is a tuple, in the relational model?
Show answer
A single row in a relation, representing one record- What is an attribute, in the relational model?
Show answer
A column in a relation, representing a single data field- What is a domain, in the relational model?
Show answer
The set of valid values an attribute can take- What is a primary key?
Show answer
A column or set of columns that uniquely identifies each row in a table- What is a candidate key?
Show answer
Any column or set of columns that could serve as a primary key- What is a foreign key?
Show answer
A column that references the primary key of another table, establishing a relationship- What is referential integrity?
Show answer
The rule that a foreign key value must match an existing primary key value or be null- What is a composite key?
Show answer
A primary key made up of two or more columns- What is a schema, in a database?
Show answer
The structural blueprint defining tables, columns, types, and relationships- What is a DBMS (Database Management System)?
Show answer
Software that manages the creation, storage, and access of a database- What is an RDBMS?
Show answer
A DBMS specifically built around the relational model, using tables and SQL- What is data independence?
Show answer
The ability to change a database's structure without affecting applications using it
FlashKeepers