Question

✌️Hlo..

➡️Answer this question..

Q. Table STUDENT has 4 rows and 2 columns . Table MARKS has 2 rows and 3 columns. How will be the cardinality and degree of the Cartesian product of STUDENT and MARKS ?

❌no spam⚔️​

Answer 1

Answer:

STUDENT table :

Degree = 2

Cardinality = 4

Marks Table :

Degree = 4

Cardinality = 2

Product of STUDENT and Mark Table:

Degree = 4 + 2 = 6

Cardinality = 4 * 2 = 8

Explanation:

• Degree is the number of attributes or columns present in a table.

• Cardinality is the number of tuples or rows present in a table.

• The Cartesian product :

The Cartesian product, also referred to as a cross-join, returns all the rows in all the tables listed in the query. Each row in the first table is paired with all the rows in the second table. This happens when there is no relationship defined between the two tables.

In The Cartesian product we add all attributes or columns from all table and multiple tuples or rows.

So,

Product of STUDENT and Mark Table:

Degree = 4 + 2 = 6

Cardinality = 4 * 2 = 8