course content

Course Content

Relational Database and Normalization

Difference between Relational and Non-relational DatabasesDifference between Relational and Non-relational Databases

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 databasesNon-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.

1. Which database (DB) model uses tables?
2. Which database management systems (DBMS) uses tables?
3. Which database (DB) model uses different object formats?
4. Which database management systems (DBMS) use different object formats?

question-icon

Which database (DB) model uses tables?

Select the correct answer

question-icon

Which database management systems (DBMS) uses tables?

Select a few correct answers

question-icon

Which database (DB) model uses different object formats?

Select the correct answer

question-icon

Which database management systems (DBMS) use different object formats?

Select a few correct answers

Section 1.

Chapter 2