Course Content
Relational Database and Normalization
Overview
Relational database management systems have a very user-friendly interface and this allows them to be used even by people without much experience. The relational database model stores data in tables with different relations.
Non-relational database management systems have a specific interface that can be used by developers only. The data is stored in unique formats, not in tables. These formats can be different, but the most popular is JSON (JavaScript Object Notation).
Main difference
| Relational databases | Non-relational databases |
| Store data in tables. | Store data in different formats like JSON. |
For example, there are two data sets “student” with headers: id, name, surname, and age. Look at the representation of these data sets in relational and non-relational databases examples:
Data in non-relational databases are represented as structures like a dictionary in Python. Here you can see the example with relationship:
Here is the data of students who belong to group BG1, but there is no direct relationship here. The program (NoSQL DBMS) must look for this dependency itself.
The related database will be detailed and revealed later in this course.
Which database (DB) model uses tables?
Select the correct answer
Which database management systems (DBMS) uses tables?
Select a few correct answers
Which database (DB) model uses different object formats?
Select the correct answer
Which database management systems (DBMS) use different object formats?
Select a few correct answers
Section 1.
Chapter 2