Consider the symbols shown in the exhibit. Which of the following correctly identifies these
symbols when used in an entity-relationship (ER) diagram?

Consider the Orders relation shown in the exhibit.

Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

A theta-join can be viewed as:

In which situation would the DBMS use a serial schedule to execute the transactions?

Which of the following definitions applies to all types of databases?

What is the highest normal form of the relation(s) shown in the exhibit?

What is the highest normal form of the relation(s) shown in the exhibit?

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following
SQL statements would create an intersection of the two relations with the widest variety of
Structured Query Language dialects?

Your enterprise has created a database and database application. The testing phase for the
project has started. Which of the following best describes white-box testing of the projects
software?

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following
SQL statements would create a set difference of the two relations with the widest variety of
Structured Query Language dialects?