What is Relational Database Management System

Leave a comment (3) Go to comments

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.

What is Relational Database Management System Relational Database Management System RDBMS vendors RDBMS products

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 :

  • Sybase
  • Oracle
  • Microsoft SQL Server
  • DB2
  • MYSQL

Want to Learn More on this topic

PREVIOUS CHAPTER 2

Page 1 2 3 4 5 6 7

EOF - What is Relational Database Management System, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

3 Comments.

  1. Great site you have here but I was curious about if you knew of any community forums that cover the same topics discussed here?
    I’d really love to be a part of community where I can get comments from other experienced people that share the same interest. If you have any suggestions, please let me know. Bless you!

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: