Let's celebrate summer! Dive deep with our first summer discounts! Get now 30% OFF on selected recently updated extensions. Learn more

Relational Databases for Dummies

Properly design your database to store your app’s information

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.

Lubov Cholakova

Lubov CholakovaLubov has been with DMXzone for 8 years now, contributing to the Content and Sales departments. She is bringing high quality content in the form of daily blog updates, reviews, tutorials, news, newsletters,update emails and extensions' manuals. If you have a product that needs publicity or any other questions about the entire DMXzone community, she is the one you can contact.

See All Postings From Lubov Cholakova >>

Comments

Be the first to write a comment

You must me logged in to write a comment.