Get the iOS app
Official deck

SQL and Relational Databases

By @memoo

Computer Science 86 cards0 imports Updated Sep 3, 2026

Practical foundations in relational modeling, SQL queries, joins, aggregation, constraints, normalization, indexes, and transactions.

Preview cards

Question
What is a relational database?
Answer
A database that represents data as relations, commonly implemented as tables.
Question
What is a relation in the relational model?
Answer
A set of tuples sharing the same attributes.
Question
What is a tuple?
Answer
One record in a relation, commonly displayed as a table row.
Question
What is an attribute?
Answer
A named property of a relation, commonly displayed as a table column.
Question
What is a database schema?
Answer
The defined structure of database objects, including tables, columns, constraints, and relationships.