Identify the composite attributes

Related MCQs

• A relation is in                          if an attribute of a composite key is dependent on an attribute of other composite key.
• If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ................ is needed.
• In the                      normal form, a composite attribute is converted to individual attributes.
• In the........... Normal form, a composite attribute is converted to individual attributes.
• In the ........... normal form, a composite attribute is converted to individual attributes.
• In the __________ normal form, a composite attribute is converted to individual attributes.
• A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency
• A                    integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):