Test 4 - Database Modeling Quiz

What is a barred relationship in database modeling?

• A relationship where the UID requires only the entity's attributes

• A relationship where the UID requires attributes from two entities

• A relationship where the UID is not required

• A relationship that can be ignored during database modeling

How is a many-to-many (M) relationship resolved in a database?

• By ignoring one of the entities

• By creating a supertype entity

• By introducing an intersection entity

• By converting it to a one-to-one relationship

Which of the following is a characteristic of non-transferable relationships?

• They are always optional

• They can be moved between instances

• They cannot be moved between instances

• They represent a recursive relationship

In a supertype-subtype relationship, what must the subtype entity do?

• Exist independently of the supertype

• Inherit all attributes of the supertype

• Contain the UID of the supertype

• Never have its own attributes

What does an arc relationship indicate in database modeling?

• A relationship where an entity has multiple valid relationships

• A hierarchical relationship between two entities

• A mutually exclusive relationship between entities

• A recursive relationship within the same entity

Why do businesses need to track historical data?

• To reduce storage costs

• To identify trends and patterns for business improvements

• To avoid tracking current data

• To increase database complexity

What is the purpose of creating an additional entity when tracking attribute values over time?

• To store only current values of attributes

• To store historical values of attributes and track changes

• To remove unnecessary data

• To avoid storing audit trails

In a many-to-many (M) relationship, what is the typical solution for tracking changes over time?

• Use a supertype-subtype relationship

• Ignore historical data

• Create an intersection entity

• Use a recursive relationship

Which of the following is stored in a PAYMENT MODIFICATION entity?

• The initial payment details only

• The current payment amount and modification history

• The customer's address

• The details of the customer's orders

What is the unique identifier (UID) of the RENTAL HISTORY entity in a jewelry store's rental tracking system?

• Customer ID

• Jewelry description

• Rental date and Jewelry detail UID

• Rental rate and return date