In which phase of database design do you identify entities, attribute domains, and relationships?

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?

Consider the Information Engineering diagram shown in the exhibit. 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 RESIDENT relation shown in this diagram?

Which term describes one or more database operations that are executed as a single unit?

Your enterprise is involved in planning a database project. The exhibit shows the result of one
phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

Consider the following relations shown in the exhibit. Which of the following SQL statements would
return the Customers2 relation from the Customers relation?

Which statement is used to define a named group of related tables, views, domains and other
database objects?

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

Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

What is a domain?