DBMS - keys , database schema

Which one of the following is a set of one or more attributes taken collectively to unique identify a record?

• Candidate key

• Sub key

• Super key

• Foreign key

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

• NAME

• ID

• CITY

• CITY, ID

A ------------ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

• Rows

• Keys

• Attribute

• Fields

Which one of the following attribute can be taken as a primary key?

• Name

• Street

• Id

• Department

An attribute in a relation is a foreign key if the ---- key from one relation is used as an attribute in that relation.

• Candidate

• Primary

• Super

• Sub