Is the number of entity classes that participate in a relationship in an ER model?

Question 1 (2 points)

Minimum cardinality refers to ________.

Question 1 options:

Save

Question 2 (2 points)

Relationships are classified by their cardinality.

Question 2 options:

Save

Question 3 (2 points)

Attributes may be ________.

Question 3 options:

Save

Question 4 (2 points)

A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.

Question 4 options:

Save

Question 5 (2 points)

A circle across the relationship line near an entity indicates ________.

Question 5 options:

Save

Question 6 (2 points)

The characteristics of a thing are described by its ________.

Question 6 options:

Save

Question 7 (2 points)

To represent a multivalued attribute in an E-R model, ________.

Question 7 options:

Save

Question 8 (2 points)

In a 1:N relationship, the term parent refers to the N side of the relationship.

Question 8 options:

Save

Question 9 (2 points)

A hash mark across the relationship line near an entity indicates ________.

Question 9 options:

Save

Question 10 (2 points)

For a relationship to be considered a binary relationship it must satisfy which of the following conditions?

Question 10 options:

Save

Question 11 (2 points)

In relational database design, ID-dependent entities are used to ________.

Question 11 options:

Save

Question 12 (2 points)

A foreign key is a key that does not belong in any table.

Question 12 options:

Save

Question 13 (2 points)

When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key, then ________.

Question 13 options:

Save

Question 14 (2 points)

A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.

Question 14 options:

Save

Question 15 (2 points)

In a relational database design, all relationships are expressed by creating a foreign key.

Question 15 options:

Save

Question 16 (2 points)

An intersection table can have additional attributes besides the keys of its parent tables.

Question 16 options:

Save

Question 17 (2 points)

An ID-dependent table can be used to represent multivalued attributes.

Question 17 options:

Save

Question 18 (2 points)

Like all ID-dependent relationships, the parents of an association table are required.

Question 18 options:

Save

Question 19 (2 points)

An intersection table is always ID-dependent on both of its parent tables.

Question 19 options:

Save

Question 20 (2 points)

By default, the identifier of the entity becomes the foreign key of the corresponding table.

Question 20 options:

Save

Question 21 (2 points)

One of the important properties of an attribute is whether or not it is ________.

Question 21 options:

Save

Question 22 (2 points)

The first step in the database design process is to create tables and columns from entities and attributes.

Question 22 options:

Save

Question 23 (2 points)

When creating a relational database design from E-R diagrams, first create a relation for each relationship.

Question 23 options:

Save

Question 24 (2 points)

A surrogate key should be considered when ________.

Question 24 options:

Save

Question 25 (2 points)

In a relational database design, all relationships are expressed by ________.

Question 25 options:

Save

Question 26 (5 points)

What are the guidelines for transforming a single entity into a table?

Question 26 options:

Save

Question 27 (5 points)

In detail, describe the relationship between CUSTOMER and ORDER.

Question 27 options:

Save

Question 28 (5 points)

Explain the following true statement: Databases do not model the real world.

Question 28 options:

Save

Question 29 (5 points)

What are the guidelines for handling multivalued attributes when transforming an entity into a table?

Question 29 options:

Save

Question 30 (5 points)

Describe in detail the relationship between ORDER and PRODUCT.

Question 30 options:

Save

Question 31 (5 points)

What is an entity?

Question 31 options:

Save

Question 32 (5 points)

What is the 1:N Transformation Rule?

Question 32 options:

Save

Question 33 (5 points)

What is the N:M Transformation Rule?

Question 33 options:

Save

Question 34 (5 points)

Degree is the number of entities that participate in a relationship. A relationship of degree 2 is a binary relationship. What are the three types of binary relationships?

Question 34 options:

Save

Question 35 (5 points)

What is the 1:1 Transformation Rule?

Question 35 options:

What is the number of entity classes involved in a relationship?

When an entity class has a relationship with itself it is called a?

What is an ID dependent entity?

Which one refers to the number of instances in a relation?