Question

Identify the relational database model's basic components

Answer 1

Answer:

The basic components of the relational database model are:

1. Tabel

2. Attributes

3. Tuples

4. Domain

1. Table

Data when arranged in rows and columns, a table is formed.

2. Attributes

In a table, there are rows and columns. Each column forms a different sense in a table.

For example, if we are storing the employee details in a table, then it goes like this:

Employee_ID	Employee_Department
101	Engineering
201	Management
301	Human Resource

Here the Employee ID and Employee Department represent the attributes.

3. Tuples

The row is called a Tuple. In the above table, we have 4 rows and 2 columns

4. Domain

It is actually a group of valid values. Like Domain of months: Jan, Feb, March ...... Like in the above table, attribute Employee_ID accepts only integer domain. It cannot accept float or double. Likewise, Department_names only accept characters, not numbers.

Upvote the answer ( as much needed for me) if it helps else let me know your doubts. Thank you!!!