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
Which of the following concepts is considered a top-down process, breaking an entity into more specific types?
Anonymous Quiz
54%
Specialization
23%
Generalization
15%
Categorization
8%
Aggregation
If an entity type can have two or more distinct key attributes, they are called:
Anonymous Quiz
0%
Alternate Keys
62%
Candidate Keys
15%
Foreign Keys
23%
Partial Keys
The category construct is mainly used to represent:
Anonymous Quiz
23%
Multiple inheritance
23%
Disjoint specialization
38%
Union types
15%
Generalization lattices