To enforce the Total Participation constraint of E2 in a 1:N relationship R, the Foreign Key placed in the relation corresponding to E2 must be specified as:

When mapping a Total Specialization (Option 3: Superclass and Subclasses), the primary key of the Subclass relation is also a:

The Foreign Key in the relation corresponding to the Weak Entity must also be specified as:

When mapping a 1:1 Relationship, if both sides have Partial Participation, a separate relation might be the optimal choice to minimize:

Mapping a generalization lattice (multiple inheritance) is most often handled using:

The key for a separate relation created from a Multivalued Attribute is the combination of the entitys Primary Key and the:

Loading the initial database contents on a secondary storage medium is a phase of:

A special null value is used to represent values that are:

Which of the following is NOT one of the three main types of Explicit schema-based constraints in the Relational Model?

All the following are types of recent database applications EXCEPT:

Which of the following describes properties used to describe an entity?

Which term is the informal name for a Tuple in the Relational Model?

In the E-R Diagram notation, an attribute that can be calculated from other stored attributes (like Age from Date of Birth) is represented as a:

Which constraint specifies that every entity in the entity set must participate in the relationship at least once?

The constraint that links two relations via a Foreign Key is:

Which integrity constraint in the Relational Model prohibits the Primary Key from having a NULL value?

The Key Attribute in an E-R Diagram should be underlined. (True/False)

In the E-R Model, the Primary Key of a Weak Entity is formed by combining its Partial Key with the:

Which phase involves specifying the data types, structures, and constraints to be stored in the database?

Which type of attribute is composed of several meaningful sub-parts (e.g., Address broken down into Street, City, and Zip)?