The correct answer is: D. both (a) and (b)
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model. The relational model organizes data into tables, which are made up of rows and columns. Each row represents a single entity, such as a customer or product, and each column represents an attribute of that entity, such as the customer’s name or the product’s price.
Tables are related to each other through common attributes. For example, a customer table might be related to an order table through the customer ID attribute. This means that each customer in the customer table has a corresponding record in the order table.
RDBMSs are designed to be efficient and scalable. They are often used to store large amounts of data, such as customer information, product inventory, or financial records.
Here is a brief explanation of each option:
- A. Tables
Tables are the basic unit of storage in a relational database. They are made up of rows and columns. Each row represents a single entity, such as a customer or product, and each column represents an attribute of that entity, such as the customer’s name or the product’s price.
- B. Relations
A relation is a mathematical concept that describes a set of ordered pairs. In the context of a relational database, a relation is a table.
- C. Tuple
A tuple is a row in a table. It is made up of a set of values, one for each column in the table.
- E. None of the above
This option is incorrect because it does not include all of the possible ways that an RDBMS can organize data.