Showing posts with label database design. Show all posts
Showing posts with label database design. Show all posts

Saturday, June 26, 2021

quick understand MongoDB from the Relational Database aspect

the following table should really help if you are coming from the relational Database and new to NoSQL.

 it will help you to learn NoSQL structure.

Relational DB

MongoDB

Database

Database

Table

Collection

Row

Document

Index

Index

Join

$Lookup

Foreign Key

Reference


Monday, February 10, 2020

What is the normalization in the Database Design?

First normalization: to break down the cell into smallest unit. single value entry

second normalization: the repeat column should be abstract to a table with primary key reference.

third normalization: no transitional dependencies. such as salutation, or total