हिंदी

A table 'game1' has 3 columns and 20 rows and another table 'game2' has the same column as game1 (ie 3) and 15 rows. 5 rows are common in both the table.

Advertisements
Advertisements

प्रश्न

A table 'game1' has 3 columns and 20 rows and another table 'game2' has the same column as game1 (ie 3) and 15 rows. 5 rows are common in both the table. If we take union, what is the degree and cardinality of the resultant table?

संख्यात्मक
Advertisements

उत्तर

Degree: Both tables have 3 columns, so the union has degree 3.

Cardinality: Duplicate rows are removed.

[20 + 15 − 5 = 30]

Final answer: Degree = 3; Cardinality = 30.

shaalaa.com
  क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
अध्याय 9: Databases Concepts and SQL - EXERCISE [पृष्ठ १७४]

APPEARS IN

सीबीएसई Computer Science with Python [English] Class 12
अध्याय 9 Databases Concepts and SQL
EXERCISE | Q 22. | पृष्ठ १७४
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×