Web apps can be split into two major components: a front-end that displays and collects information, and a back-end for storing the information. In this article, Lalith Polepeddi will demonstrate what a relational database is, and how to properly design your database to store your app’s information.
A database stores data in an organized way so that it can be searched and retrieved later. It should contain one or more tables. A table is much like a spreadsheet, in that it’s made up of rows and columns. All rows have the same columns, and each column contains the data itself. If it helps, think of your tables in the same way that you wouldatable in Excel.
A relational database is a type of database that organizes data into tables, and links them, based on defined relationships. These relationships enable you to retrieve and combine data from one or more tables with a single query.