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.
20 cards · basic cards · AI-written, checked twice. Edit anything.
- What is a database?
- An organized collection of structured data stored and accessed electronically
- What is the relational model?
- A model that organizes data into tables (relations) of rows and columns
- What is a relation, in relational database terms?
- A table consisting of rows (tuples) and columns (attributes)
- What is a tuple, in the relational model?
- A single row in a relation, representing one record
- What is an attribute, in the relational model?
- A column in a relation, representing a single data field
- What is a domain, in the relational model?
- The set of valid values an attribute can take
- What is a primary key?
- A column or set of columns that uniquely identifies each row in a table
- What is a candidate key?
- Any column or set of columns that could serve as a primary key
- What is a foreign key?
- A column that references the primary key of another table, establishing a relationship
- What is referential integrity?
- The rule that a foreign key value must match an existing primary key value or be null
- What is a composite key?
- A primary key made up of two or more columns
- What is a schema, in a database?
- The structural blueprint defining tables, columns, types, and relationships
- What is a DBMS (Database Management System)?
- Software that manages the creation, storage, and access of a database
- What is an RDBMS?
- A DBMS specifically built around the relational model, using tables and SQL
- What is data independence?
- The ability to change a database's structure without affecting applications using it
FlashKeepers