Scribd
Upload
6 views5 pages

Understanding SQL RDBMS Basics

RDBMS stands for Relational Database Management System, which is the foundation for SQL and modern database systems like MS SQL Server and MySQL. Data in RDBMS is organized into tables, consisting of rows (records) and columns (fields), where each field holds specific information about the records. The document explains the basic components of RDBMS, including tables, fields, records, and columns.

Uploaded by

cgichira
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views5 pages

Understanding SQL RDBMS Basics

RDBMS stands for Relational Database Management System, which is the foundation for SQL and modern database systems like MS SQL Server and MySQL. Data in RDBMS is organized into tables, consisting of rows (records) and columns (fields), where each field holds specific information about the records. The document explains the basic components of RDBMS, including tables, fields, records, and columns.

Uploaded by

cgichira
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL RDBMS CONCEPTS

• What is 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.
SQL RDBMS CONCEPTS…

• What is table?
• The data0 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.
Remember, a table is the most common and simplest form of data storage in a
relational database.
SQL RDBMS CONCEPTS…

• Following is the example of a CUSTOMERS table:


SQL RDBMS CONCEPTS…

• What is field?
• Every table is broken up into smaller entities called fields. The fields in the
CUSTOMERS table consist of ID, NAME, AGE, ADDRESS and SALARY.
• A field is a column in a table that is designed to maintain specific information about
every record in the table.
• What is record or row? A record, also called a row of data, is each individual entry
that exists in a table. For example, there are 7 records in the above CUSTOMERS
table.
SQL RDBMS CONCEPTS…

• Following is a single row of data or record in the CUSTOMERS table:

• What is column? A column is a vertical entity in a table that contains all


information associated with a specific field in a table.

You might also like