Introduction to RDBMS : Day 1 : Chapter 1
In this chapter, you will learn to:
What is Relational Database Management System ?
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. Most popular commercial and open source databases currently in use are based on the relational database model.
A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables. (Taken from Wikipedia).
In the example below, “Customer ID” is the primary key (PK) in one table and the foreign key (FK) in another. The arrow represents a one-to-many relationship between the two tables. The relationship indicates that one customer can have one or more orders. A given order, however, can be initiated by one and only one customer.
A relational DBMS stores information in a set of “tables”, each of which has a unique identifier or “primary key”. The tables are then related to one another using “foreign keys”.
Today we have, several RDBMS products like :
- Microsoft SQL Server
Want to Learn More on this topic
PREVIOUS CHAPTER 2