Reference no: EM131524495

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?