. .
Quiz by , created more than 1 year ago

asdf Quiz on Chapter 4 (True/False), created by . . on 08/09/2016.

161
2
0
. .
Created by . . almost 8 years ago
Close

Chapter 4 (True/False)

Question 1 of 30

1

1) An ERM is dependent on the database type.

Select one of the following:

  • True
  • False

Explanation

Question 2 of 30

1

2) The word “entity” in the ER model corresponds to a table.

Select one of the following:

  • True
  • False

Explanation

Question 3 of 30

1

3) The Crow’s Foot model is less implementation-oriented than the Chen model.

Select one of the following:

  • True
  • False

Explanation

Question 4 of 30

1

4) The ER diagram represents the conceptual database as viewed by the end user.

Select one of the following:

  • True
  • False

Explanation

Question 5 of 30

1

5) The ER model refers to a specific table row as an entity instance.

Select one of the following:

  • True
  • False

Explanation

Question 6 of 30

1

6) In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name.

Select one of the following:

  • True
  • False

Explanation

Question 7 of 30

1

7) The ER model refers to a specific table row as an entity occurrence.

Select one of the following:

  • True
  • False

Explanation

Question 8 of 30

1

8) Attributes are types of entities.

Select one of the following:

  • True
  • False

Explanation

Question 9 of 30

1

9) In the original Chen model, each attribute is represented using an oval with the
attribute name connected to the entity with a line.

Select one of the following:

  • True
  • False

Explanation

Question 10 of 30

1

10. Software vendors have adopted the Chen representation because of its compact
representation.

Select one of the following:

  • True
  • False

Explanation

Question 11 of 30

1

11) Attributes have a domain that specifies the data type of the attribute.

Select one of the following:

  • True
  • False

Explanation

Question 12 of 30

1

12) Attributes cannot share a domain.

Select one of the following:

  • True
  • False

Explanation

Question 13 of 30

1

13) In an ER diagram, primary keys are usually bolded.

Select one of the following:

  • True
  • False

Explanation

Question 14 of 30

1

14. Ideally, a primary key is composed of several attributes.

Select one of the following:

  • True
  • False

Explanation

Question 15 of 30

1

15. A composite identifier is a primary key composed of more than one attribute.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 30

1

16. All attributes are either simple or composite.

Select one of the following:

  • True
  • False

Explanation

Question 17 of 30

1

17) All simple attributes are also single-valued.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 30

1

18) In the Chen model, a multivalued attribute is connected to the owning entity
with a double line.

Select one of the following:

  • True
  • False

Explanation

Question 19 of 30

1

19) The DBMS can easily handle multivalued attributes.

Select one of the following:

  • True
  • False

Explanation

Question 20 of 30

1

20) Derived attributes are stored in a special database table.

Select one of the following:

  • True
  • False

Explanation

Question 21 of 30

1

21) A relationship is identified by a name that describes the relationship.

Select one of the following:

  • True
  • False

Explanation

Question 22 of 30

1

22) Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

Select one of the following:

  • True
  • False

Explanation

Question 23 of 30

1

23) In Chen notation, there is no way to represent cardinality.

Select one of the following:

  • True
  • False

Explanation

Question 24 of 30

1

24) Connectivities and cardinalities are established by business rules.

Select one of the following:

  • True
  • False

Explanation

Question 25 of 30

1

25) A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

Select one of the following:

  • True
  • False

Explanation

Question 26 of 30

1

26) You should always load data from the 1 side of a 1:M relationship.

Select one of the following:

  • True
  • False

Explanation

Question 27 of 30

1

27) A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship

Select one of the following:

  • True
  • False

Explanation

Question 28 of 30

1

28. The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.

Select one of the following:

  • True
  • False

Explanation

Question 29 of 30

1

29) Relationships operate only in one direction.

Select one of the following:

  • True
  • False

Explanation

Question 30 of 30

1

30. A recursive relationship is one in which a relationship can exist between occurrences of the same entity set

Select one of the following:

  • True
  • False

Explanation