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?

• A. Activity_Fee is a determinant of Activity.
• B. Activity_Fee is partially dependent on the key.
• C. Activity_Fee is a determinant of Activity and Student_I
• D. The table contains a transitive dependency.

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

• A. 1 = relationship, 2 = attribute, 3 = entity
• B. 1 = entity, 2 = relationship, 3 = attribute
• C. 1 = attribute, 2 = entity, 3 = relationship
• D. 1 = relationship, 2 = entity, 3 = attribute

Consider the following SQL statement and the Orders relation shown in the exhibit:
What is the output of this SQL statement?
SELECT *
FROM Orders
WHERE NOT (Amount < 1000
AND Sales_Rep_No = 210);

• A. B
• B. D
• C. C
• D. A

Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name and Res_Name are represented by variable-length strings with a maximum of 20 characters. Location can be up to 50 characters long, and no building has more than 600 rooms. Which SQL statement best implements the BUILDING relation shown in this diagram?

• A. CREATETABLE BUILDING ( Building_ID NOT NULL PRIMARY KEY, Bldg_Name, Location, Room_Count, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
• B. CREATETABLE BUILDING (
  Building_ID NOT NULL PRIMARY KEY, Bldg_Name, Location, Room_Count);
• C. CREATETABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (50),
• D. CREATETABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (50),
  Room_Count INTEGER CHECK (Room_Count >
  Room_Count INTEGER CHECK (
  -1 And Room_Count < 601));
  Room_Count > -1 Or Room_Count < 601));

Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation? Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation?

• A. (Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))
• B. (Customer X Sales_Rep) ? Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No
• C. Customer X Sales_Rep
• D. Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)