The relationship that connects three entity types is called:
Anonymous Quiz
5%
Binary Relationship
68%
Ternary Relationship
21%
Quaternary Relationship
5%
Unary Relationship
Which of the following describes the collection of similar entities that exist in the database at a particular point in time?
Anonymous Quiz
26%
Entity Type
26%
Entity Set
26%
Schema
21%
Relationship Type
In the E-R Diagram notation, an Attribute of a Relationship type is represented by:
Anonymous Quiz
47%
An oval connected to the diamond
35%
An oval connected to the entity
6%
A dashed oval
12%
A rectangle inside the diamond
A key that uniquely identifies each record in the entity set is known as the:
Anonymous Quiz
26%
Alternate Key
63%
Primary Key
5%
Foreign Key
5%
Partial Key
If an employee must work for one department, and a department can have many employees, the cardinality Ratio of the WORKS_FOR relationship (from EMPLOYEE to DEPARTMENT) is:
Anonymous Quiz
0%
1:1
42%
M:1
42%
1:N
16%
N:M
The set of possible values for a simple attribute is its:
Anonymous Quiz
39%
Domain
28%
State
28%
Degree
6%
Cardinality
Which component in the E-R Model is represented by a diamond shape?
Anonymous Quiz
0%
Key
88%
Relationship Type
6%
Entity Set
6%
Attribute
The Degree of a relationship type refers to the:
Anonymous Quiz
12%
Number of tuples in the relationship set
29%
Number of participating entity types
18%
Cardinality ratio of the relationship
41%
Number of attributes in the relationship
The process of defining a Superclass from a set of Subclasses based on common features is called:
Anonymous Quiz
13%
Categorization
31%
Specialization
56%
Generalization
0%
Aggregation
The constraint that allows an entity to belong to more than one subclass simultaneously is the:
Anonymous Quiz
13%
Total Constraint
20%
Disjoint Constraint (d)
47%
Overlapping Constraint (o)
20%
Completeness Constraint
The constraint that specifies an entity in the Superclass must belong to at least one of the Subclasses is the:
Anonymous Quiz
7%
Partial Constraint
20%
Overlapping Constraint
40%
Total Completeness Constraint
33%
Disjointness Constraint
Which term refers to the concept where a Subclass inherits attributes from multiple Superclasses?
Anonymous Quiz
0%
Categorization
71%
Multiple Inheritance
0%
Specialization
29%
Generalization Hierarchy
The Subclass relationship to the Superclass is also known as a:
Anonymous Quiz
46%
Is-A relationship
23%
Has-A relationship
23%
Part-Of relationship
8%
Belongs-To relationship
A subclass whose entities are determined by a specific condition on a Superclass attribute is called:
Anonymous Quiz
7%
Total Specialization
57%
Attribute-Defined Specialization
21%
User-Defined Specialization
14%
Overlapping Specialization
Which constraint dictates that an entity in the Superclass can belong to at most one of the Subclasses?
Anonymous Quiz
35%
Overlapping Constraint
41%
Disjointness Constraint
12%
Total Constraint
12%
Completeness Constraint
A specialized type of Subclass that models a single relationship involving members of one of several different entity types is a:
Anonymous Quiz
19%
Generalization Hierarchy
69%
Category (Union Type)
6%
Superclass
6%
Specialization Lattice
The combination of constraints (Disjoint, Total) means that an entity must belong to:
Anonymous Quiz
20%
Exactly one subclass
40%
Zero or more subclasses
27%
At least one subclass
13%
All defined subclasses
The Superclass contains common attributes, while the Subclass contains:
Anonymous Quiz
0%
Only the key attribute
36%
Its own specific attributes
29%
All attributes of the superclass
36%
Attributes inherited from its superclass
If an EER model contains shared subclasses, the structure is referred to as a:
Anonymous Quiz
7%
Attribute-Defined Hierarchy
43%
Generalization Hierarchy
43%
Specialization/Generalization Lattice
7%
Simple Specialization
The constraint that specifies an entity in the Superclass may not belong to any of the Subclasses is the:
Anonymous Quiz
21%
Total Constraint
71%
Partial Completeness Constraint
7%
Overlapping Constraint
0%
Disjoint Constraint