something that the users want to track in their environment

/in /by

Question

1. (TCO B) 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. (TCO B) The characteristics of a thing are described by its _____.

identifiers

entities

objects

attributes

relationships

Question 3. (TCO C) 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. (TCO C) 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. (TCO C) 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. (TCO B) 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. (TCO C) How would you represent a one-to-many strong entity relationship in a physical relational database design?