SQL DBMS AND RDBMS

DBMS: It stands for “Database Management Systems”

RDBMS: It stands for “Relational Database Management Systems”

RDBMS works with almost all database management systems like MS Sql, Microsoft Access, My Sql, Postgre, SqlLite, Orable etc... Its core and fundamental part which play major role with SQL.

The relational model is introduced by E F Codd which is considered DBMS (Database Management System) Which is either on a way RDBMS(Relational Database Management System).

Database:

Database is collection of data, objects and many other factors like Tables, Columns, Rows, Keys, Permissions, Users, Constraints, Integrity, and Normalization etc...

Basic about Tables: Table is collection or data into row and columns wise. For example, you make take table like Students and in that you may store details like FirstName, LastName, Gender, Email Address, Phone Number, BirthDate etc...

First Name Last Name Gender Email Address Phone Number Birth Date
John Millar Male johnmillar@gmail.com +1 987-654-6321 01/01/1985
Jason Turner Male Jason@jason.com +1 369-852-7412 02/01/1987
Jessica Wills Female Jessi123@gmail.com +1 357-951-8624 04/03/1990
James Walsh Male James3@gmail.com +1 368-963-4562 01/-8/1983

In above section, we learn what is table and how it stored data with matrix structure by using rows and columns. So basically, table is very important part in database because it store actual data or records into database.

Basic about Rows and Columns:

In above example, we can see 4 rows which have values or records. Records defined as horizontally considered as rows or records. Columns are actual field who store records for particular field like First Name or Last Name or Gender. They are defined as vertically aligned in table structure. Rows and columns create matrix or tabular format to store data and that whole structure is known as Table.

Rows:

John Millar Male johnmillar@gmail.com +1 987-654-6321 01/01/1985

Columns:

First Name Last Name Gender Email Address Phone Number Birth Date

We will learn more about Constraints, Integrity and Normalization in upcoming chapters.