RDBMS Basics

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, Oracle, MySQL, and Microsoft Access.

In Simple word RDBMS is a database management system that is based on the relational model as introduced by E. F. Codd.

Generally, these databases will be more complex than the text file/spreadsheet example in the previous lesson.
In fact, most of today's database systems are referred to as a RDBMS, because of their ability to store related data across multiple tables.

Some of the more popular relational database management systems include:

* Microsoft Access
* Microsoft SQL Server
* MySQL
* Oracle

In Short below are the basics of RDBMS:-

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.

The data in RDBMS is stored in database objects called tables. The table is a collection of related data entries and it consists of columns and rows.

Every table is broken up into smaller entities called fields.

A record, also called a row of data, is each individual entry that exists in a table. A column is a vertical entity in a table that contains all information associated with a specific field in a table.

1 comment:

  1. Professionally written blogs are rare to find, however I appreciate all the points mentioned here. I also want to include some other writing skills which everyone must aware of.
    ระบบจัดการร้านค้า

    ReplyDelete