Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in
Which of the following relational algebraic expressions would result in the given table?
Which term describes the management of simultaneous transactions to prevent conflicts?
Which term best describes one or more database operations that are executed as a single unit?
Using the Customer and Sales_Rep relations shown in the exhibit, you must datermine a relational
Which of the following relational algebraic expressions would result in this relation?
Which term describes an attribute or combination of attributes that uniquely identifies a row in
What is a candidate key?
A foreign key maps to a:
Consider the relations shown in the exhibit. Due to restructuring, the sales department has
been eliminated and the employees working in that department have been dismissed. All ID
information is stored as integers. Which SQL statement would be used to return a relation with all
information for the employees who have been dismissed?
Which of the following best describes the ON DELETE NO ACTION referential integrity
Consider the table shown in the exhibit. Which relational algebraic operation would return
A large enterprise uses a two-tier database architecture and runs complex database processing
on the client. Which term best describes the client in this system?