11 Relational Database Terms Explained in Less Than 280 Characters Each With Hand-Drawn Tables

Clear and Concise Explanation

Photo by Radek Grzybowski on Unsplash

The relational model helps us understand data at a logical level.

Relational databases are used in the vast majority of database products.

But most programmers get confused by relational database terms.

Here I have tried to explain eleven relational database terms that will help you understand database concepts correctly.

1. Relational Database

A relational database is made up of a collection of tables.

Each table has a unique name.

The term relation is used to refer to a table.

I have drawn a relation called course below.

The course relation has three column headers: ID, title, and Credits.

Credit: Me

2. Tuple and Attribute

A tuple is used to refer to a row in a table.

An attribute is used to refer to a column in a table.