Ch4 Entity Relationship Model Quiz 5

What does an Entity Relationship Diagram (ERD) represent?

• Physical database structure

• Conceptual database from the user's perspective

• Relational schema design

• Transaction model

Which component of the ERD corresponds to a table in the relational environment?

• Entity

• Attribute

• Relationship

• Cardinality

An attribute that must have a value is called a(n):

• Optional attribute

• Required attribute

• Simple attribute

• Derived attribute

In ERD notation, how is an entity represented?

• Oval

• Diamond

• Rectangle

• Triangle

What is the role of an identifier in an entity?

• Define attributes

• Establish relationships

• Uniquely identify each entity instance

• Describe entity's characteristics

A primary key composed of more than one attribute is called a:

• Composite attribute

• Simple attribute

• Composite identifier

• Multivalued identifier

Which type of attribute can be subdivided into smaller attributes?

• Simple attribute

• Composite attribute

• Multivalued attribute

• Derived attribute

An attribute that has more than one value for an entity is known as a:

• Single-valued attribute

• Composite attribute

• Multivalued attribute

• Derived attribute

What is an attribute whose value is calculated from other attributes called?

• Multivalued attribute

• Derived attribute

• Composite attribute

• Optional attribute

Which of the following indicates the minimum and maximum number of entity occurrences associated with one occurrence of the related entity?

• Connectivity

• Cardinality

• Participation

• Existence