Database Design Quiz

What is an entity in the context of database design?

• B. A type of association between entities

• A. A concrete or abstract object that can be distinctly recognized and uniquely characterized

• C. A characteristic associated with an entity

• D. A link between multiple entities

What is the purpose of an attribute in database design?

• D. To describe a characteristic of an entity

• A. To define the cardinality of an entity

• B. To represent a relationship between entities

• C. To uniquely identify an entity

What does the cardinality of a relationship in database design specify?

• C. The domain of an attribute

• A. The number of times an entity can be involved in an association

• B. The type of entity involved in a relationship

• D. The value of an identifier

In database design, what is the purpose of an identifier or key?

• D. To define the attributes of an entity

• C. To uniquely identify an entity or relationship

• B. To establish a link between entities

• A. To determine the cardinality of a relationship

What is the cardinality notation 1, n used for in database design?

• A. An entity can exist without being part of any association

• C. An entity must be involved in exactly one association

• D. An entity can be involved in at most one association

• B. An entity can be involved in multiple associations without limit

What is the purpose of an association in database design?

• A. To define the attributes of an entity

• C. To uniquely identify an entity

• D. To describe a characteristic of an entity

• B. To establish a link between entities

What is the representation of a type-association in database design?

• D. A relationship between entities

• C. A type of entity

• B. A characteristic associated with an entity

• A. A link between multiple entities

How can an n-ary association be simplified in database design?

• B. By adding more attributes to the association

• D. By increasing the cardinality of the association

• A. By creating binary associations between entities

• C. By removing one of the entities involved