Relational Database Management System Exercise

A Relational Database Management System (RDBMS) is a software system that enables the creation, management, and administration of relational databases, where data is organized into tables consisting of rows and columns. Introduced by E.F. Codd in 1970, the relational model revolutionized data storage by allowing relationships between tables through keys, ensuring structured and efficient data retrieval. RDBMSs typically use Structured Query Language (SQL) to perform operations such as querying, updating, and maintaining data integrity via ACID properties (Atomicity, Consistency, Isolation, Durability). Popular examples include MySQL, PostgreSQL, Oracle, and Microsoft SQL Server, making RDBMS the foundation for countless applications in business, finance, and beyond.

What are the functions of a Relational Database Management System?

Objective: List the major functions of an RDBMS.

Exercise scoring

This exercise is worth a total of two points. It is auto-scored; when you have completed the task below, click Submit to receive credit and view a results page.

Overview

The previous lesson introduced the major functions of a relational database management system (RDBMS). This exercise reinforces that list and helps you connect each function to SQL.

Instructions

In the text area below, list the five major functions of an RDBMS.

Then place an asterisk (*) after each function that directly uses a SQL component.

Use one line per function.

Hints

An RDBMS has five major functions. Review the image series from the lesson and look for where SQL is explicitly involved.

Submitting your exercise

When you have listed all five functions (and added * where appropriate), click Submit to complete the exercise and open the results page.