Question

What will be the degree oof student table

Answer 1

It depends on the room which the table is placed

Answer 2

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