1. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

Answer. Attributes, Relation



2. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

Answer. Tuple of distinct



3. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

Answer. Select



4. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

Answer. Intersect



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

Answer. Primary



6. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called

Answer. Referencing relation



7. Which is a join condition contains an equality operator:

Answer. Equijoins



8. In precedence of set operators, the expression is evaluated from

Answer. Left to left