Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?

Related MCQs

• Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
• Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
• The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
• 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
• The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into employee1 (ID, name) employee2 (name, street, city, salary) This type of decomposition 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):
• 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):
• A super key is a set of one or more attributes that, taken collectively, allow us