What is a RDBMS - What is a Relational Database ?
What is Relational Database Management System (RDBMS) ?
- RDBMS stands for Relational Database Management System
- It forms the basis for SQL and modern database systems
- Examples of RDBMS include MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access
- It follows the relational model proposed by E. F. Codd in 1970
What is a Table?
- Data in an RDBMS is stored in tables, which are database objects.
- A table is a collection of related data entries organized into columns and rows.
- Tables are the most common and simplest form of data storage in a relational database.
- Each table contains various columns (attributes) and rows (records).
- Example: A Wikitechy table may store data like customer ID, Student_Name, Mark,Age.
| ID | Student Name | Mark | Age |
|---|---|---|---|
| 1 | Mani | 65 | 15 |
| 2 | Mohan | 70 | 15 |
| 3 | Raj | 50 | 15 |
| 4 | Bagavan | 80 | 16 |
What is Field ?
-
In every table, there are fields, which are columns designed to store specific details about each record in the table.