Timedora
Free Online Flashcard Deck

Relational Tables, Keys, and Relationships Free Online Flashcards

Study Relational Tables, Keys, and Relationships with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

In a relational table, what do rows and columns represent?

Back

Columns describe attributes, while each row represents one record or instance.

02
Front

What makes a candidate key the primary key?

Back

A primary key is the candidate key chosen as the table’s main identifier. Its values must be unique and not null.

03
Front

How do data types, domains, and constraints work together?

Back

A data type supplies a basic domain of acceptable values; additional rules can narrow that domain, and constraints enforce those rules.

04
Front

What table structure represents students taking many courses and courses having many students?

Back

An associative table connects records from two tables and represents a many-to-many relationship, such as students taking courses.

05
Front

What is a candidate key?

Back

A candidate key is a minimal set of columns that uniquely identifies each row. A table may have more than one.

06
Front

What do `NOT NULL`, `UNIQUE`, and `CHECK` constraints enforce?

Back

`NOT NULL` requires a value, `UNIQUE` disallows repeated values or combinations, and `CHECK` enforces a specified condition.

07
Front

What does a table’s schema define?

Back

A table’s schema defines its columns; its rows vary as records are added or removed.

08
Front

Where can a foreign key go in a one-to-many relationship?

Back

Put a foreign key on the “many” side. For example, `Courses` can contain `department_id` when each course belongs to one department.

09
Front

What is a cell in a relational table?

Back

A cell contains the value at the intersection of a particular row and column.

10
Front

What does `(student_id, course_id)` as a combined primary key prevent?

Back

The combined primary key `(student_id, course_id)` allows at most one enrollment row for each student-course pair.

11
Front

What does a foreign key require of its values?

Back

A foreign key’s values must match a key in another table or the same table, preventing references to records that do not exist.

12
Front

What is a column’s domain?

Back

A domain is the set of valid values for an attribute; additional rules can narrow which values are acceptable.