Introduction to Databases (Mainly RDBMS)

Key Concepts -
The formal definition of a database is a method which we are using in order to store our data. While there are many approaches to save information, a very common method to save our data is using tables. The SQL language interacts with databases that keep their information inside tables.

The method of storing data inside tables is called RDBMS.

RDBMS is characterised by 3 main concepts:
1. Each table can be related to another table using the common column,
2. Tables should be normalized, it simply means that other than the common column,Each table should have its unique set of columns
3. Constraints - when we’re using the RDBMS, we can enforce different rules on different columns, in order to enforce the validity of our data. We are calling this rules Constraints.