Question 1. Maximum cardinality refers to _____.
the most instances of one entity class that can be involved in a relationship with one instance of another entity class
the maximum number of entity classes involved in a relationship
whether or not an instance of one entity class is required to be related to an instance of another entity class
whether or not an entity is a weak entity
None of the above
Question 2. The characteristics of a thing are described by its _____.
identifiers
entities
objects
attributes
relationships
Question 3. The identifier of the entity becomes the _____ of the corresponding table.
A. primary key
B. foreign key
C. supertype
D. subtype
Both A and B
Question 4. In a relational database design, all relationships are expressed by _____.
creating a primary key
creating a foreign key
creating a supertype
creating a subtype
creating a line between entities
Question 5. In relational database design, ID-dependent entities are used to _____.
represent N:M relationships
handle associative relationships
handle multivalued attributes
handle archetype/instance relationships
All of the above
Question 6. Match the following terms to their definitions.
Potential Matches:
1 : something that the users want to track in their environment
2 : an entity whose identifier includes the identifier of another entity
3 : describes characteristic of an entity
4 : an entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity
5 : an entity that holds specialized attributes that distinguish it from one or more other similar entities
Answer
: ID-dependent entity
: Subtype
: Weak entity
: Attribute
: Entity
Question 7. How would you represent a one-to-many strong entity relationship in a physical relational database design?