Row and violate referential integrity

Quiz 2
In the relational database terminology, a table is synonymous with: Select one:

CORRECT
Feedback
See the section RM Concepts in the Topic 01 lecture slides
The correct answer is: A relation
Question 2
Correct
Mark 1.00 out of 1.00
Question text
In the relational database terminology, an attribute is synonymous with: Select one:

Feedback
The correct answer is: A column
Question 3
Correct
Mark 1.00 out of 1.00
Question text
A null indicates:

CORRECT

Feedback
A superkey is ANY combination of attributes for which each tuple is unique.

relation

The correct answer is: STAFF_NUM, BRANCH_NUM

Question 7

The correct answer is: Row #6
Question 8
Correct
Mark 1.00 out of 1.00
Question text
This question is based on the image below:

Select one:

Feedback
The result relation consists of the tuples that are in Dept 1 BUT NOT Dept 2 - therefore, it is Dept1 MINUS Dept2
The correct answer is: Dept1 MINUS Dept2
Question 9
Correct
Mark 1.00 out of 1.00
Question text
Based on the information and tables below, which of the following statements is true?

integrity rule.

	c. The 3rd and 4th rows of Employee table, considered together, violate the referential

integrity rule.

The result relation consists of the tuples that are in Dept1 or Dept 2 or both - UNION.

The correct answer is: Dept1 UNION Dept2
Question 11
Incorrect
Mark 0.00 out of 1.00
Question text
Which of the following relational algebra operators produces a subset of attributes from a relation?

The correct answer is: Dept1 INTERSECT Dept 2 Question 13
Correct
Mark 1.00 out of 1.00
Question text

This question refers to the image below:

Select one:

	a. A relation with the attribute CUST_NO and one tuple with the value CR56

Feedback
Your answer is correct.

	d.

Feedback

The SELECT line is used to specify the columns returned by the query.

Feedback
Your answer is incorrect.

Covered in Topic 2 and Lab 2.

	d. WHERE