Explain like I'm a total nerd

Relational database was created to overcome the pitfalls of an earlier database structure called navigational database. Navigational database lacked the ability for "search" which became a much needed feature as computers got more powerful and applications grew more complex.

A table in a relational database is used to organize data of the same nature. Such as books or authors. Each row in a table contains one data entry, such as one book "Moby-dick". A column will represent an attribute belonging to data in a table, such as "year of publish" which will be "1851" for "Moby-dick".

An attribute can be used to store an identifier belonging to data of other tables. We can store the Author's name "Herman Melville" as an attribute of "Moby-dick" to add the relationship between a book and its author.

ISBN	title	author	Year of Publish
1503280780	Moby-Dick	Herman Melville	1851
1400079985	War and Peace	Leo Tolstoy	1867

name	Country
Herman Melville	United States
Leo Tolstoy	Russia

Towards the end of 1970s, a standardised language called SQL (Structured Query Language) for managing relation databases was created. Nowadays, almost all relational database systems use SQL for managing the database. The most well known relational database management system include PostgreSQL, mySQL.

Explain like I like videos