RelationalDBDesignRelationalDBDesign





Database Design   «Prev  Next»
Lesson 7The relational database management system
ObjectiveWhat are the functions of an RDBMS?

Relational Database Management System

A database management system (DBMS) is a software interface that sits between a database and a user, or between a database and an application (such as an inventory system).
Different DBMSs support different database models and different
  1. DDLs [Data Definition Language] and
  2. DMLs [Data Manipulation Language].
A typical DBMS creates, manipulates, modifies, and maintains a database.

Relational database management system (RDBMS)

A relational database management system (RDBMS) supports the relational model. It performs the same basic functions as those listed for a DBMS. SQL is the data definition and data manipulation language that is packaged with an RDBMS. The following SlideShow walks you through the major functions of a RDBMS. Use the forward and back arrows to navigate through the series of images.

1) SQL component in a RDBMS
2) Allows access to data in a variety of ways
3) Provides the means to make changes to database records
4) Built-in security and utilities to perform routine DB backups
5) RDBMS provides tools to generate invoices, payroll checks, and financial reports

RDBMS Functions

RDBMS Management

One RDBMS can manage many relational databases.
Oracle, Microsoft, IBM, MySQL, and Sybase have comprehensive RDBMSs available on the market.
Each company packages its product(s) with utilities to enhance RDBMS capabilities and performance. Product prices vary widely among these top competitors.
The next lesson discusses the concept of database change management.

Main functions of DBMS

A database management system (DBMS) is a collection of programs that manages the database structure and controls access to the data stored in the database. In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software, known as a database management system, helps manage the cabinet’scontents.

RDBMS - Exercise

Before moving on to the next lesson, click the Exercise link below to check your knowledge of the functions of an RDBMS.
RDBMS - Exercise