Consider the relation shown in the exhibit.

Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

Consider the entity-relationship (ER) diagram shown in the exhibit.

Which type of relationship between the two entities is shown?

Consider the Registration relation shown in the exhibit. Which of the following SQL statements
would return all tuples that have course codes beginning with the letter M?

Consider the Information Engineering diagram shown in the exhibit for a building management
company. Referential integrity must be maintained such that a building cannot be deleted when it
has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas
Bldg_Name, Location and Res_Name are all represented by variable-length strings with a
maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

Which of the following best describes the two-tier database architecture?

The exhibit shows a table called Recreation Relation that relates a unique student identification
number and a sports activity with a fee for participating in that activity. The Student_ID and Activity
columns in the table are used together as a composite key. Which statement about the relation is correct?

Consider the entity-relation (ER) diagram shown in the exhibit.

When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

Which term best defines a database system in which data records are stored in one or more files
with no structured relationship?

Which of the following describes two desirable characteristics of a primary key?

Which relational algebraic operation is used to select specific columns (attributes) from a relation?