Saved Bookmarks
| 1. |
Cardinality of a table TI is 10 and of table T2 is 8 and the two relations are union compatible.(a) What will be the maximum possible cardinality of T1 ∪ T2? (b) What will be the minimum possible cardinality of T1 ∩ T2? |
|
Answer» (a) Degree(CD) - the number of Columns is the Degree Cardinality (RC)-: the number of Rows is the Cardinality T1 ∪ T2 = Sum of cardinalities of Table 1 and Table 2 i. e.T1 ∪ T2 = 10 + 8 = 18 (b) T1 ∩ T2 is the common rows(tuples) in T1 and T2 If there is no common tuples then T1 ∩ T2 is 0 hence the cardinality is 0. |
|