Question

Assume the structure of a relation is Employee (EmpID, Name, Dept, Salary). The number of attributes for this relation would:

a. be three.
b. be five.
c. be six.
d. be four.
e. vary depending upon the number of employees.

Answer 1

D. Four

Explanation:

The number of attributes for the Employee relation is four namely: EmpID, Name, Dept, Salary.

We said four because it is only four attributes that are defined for the Employee relation, but an instance of the relation can have lesser than four attribute but not more than four attribute.