Which term describes the rejoining of relations that have been decomposed?

Which subset of Structured Query Language (SQL) is used to perform operations such as data
retrieval or deletion on the data contained in a database?

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

Which of the following best describes the ON DELETE CASCADE referential integrity constraint?

The exhibit shows a table called Student Relation that tracks all information related to a students
courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

Consider the following relation definition:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL
Student_Number: integer NOT NULL
Building: variable length character string length 25 NOT NULL)
Primary Key Housing_ID
Foreign Key Student_Number References
STUDENT(Student_Number)
ON DELETE NO CHECK
ON UPDATE
Which integrity constraint is violated in this relation definition?

A relation for a construction company is shown in the exhibit. Which of the following best defines
the relationship between Cust_ID and Cust_Name?

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?