[DATABASE] Complete instruction on database design

What is a DBMS?

A Database Management System, aka DBMS is a software package designed to define, manipulate, retrieve and manage data in a database.

What is the difference between a DBMS and a database?

DBMS can contain several databases, meaning that a database is simply one of databases that a DBMS manages. Again, the DBMS can define new database, manipulate, retrieve and manage data in a database.

Why do we indeed need database?

• Managing redundancy
• Storing data in a physical place

Database types:

• Relational database: Relationship exits among tables in database, meaning from 1 table we can trace all the way back to the other tables.
• NoSQL database: The opposite of relational database.

Relational Database characteristics:

• Inter-related: Again relationship among tables in a database.
• Persistency: No redundant data exits in database.
• Shared: Different internal users can get access to a part/some parts/all parts of a database.

Broad goals of database design

• Develop a common vocabulary
• Define business rules