Timedora
Free Practice Quiz Question List

ER Modeling Fundamentals Online Quiz Questions

Use this free practice quiz with 20 questions to review ER Modeling Fundamentals, test your knowledge, and prepare for your next test or exam.

20 questions
01
Choose one
1 point

A system records students. Which statement correctly distinguishes the entity type from an instance?

  1. A

    A Student entity is one specific student, while a student instance is the category of all students.

  2. B

    Student is an entity type, while one particular student is an instance of that entity type.

  3. C

    StudentName is an entity type, while Student is an attribute.

  4. D

    An instance is a property shared by every entity type.

02
Choose all
1 point

Select all the correct statements about the basic building blocks of an ER model.

  1. A

    An entity is a kind of thing the system records.

  2. B

    An instance is an individual example of an entity type.

  3. C

    An attribute is a relationship between two entity types.

  4. D

    A key uniquely identifies an entity instance.

  5. E

    An ERD presents the design visually, including information and associations.

03
True or false
1 point

Every candidate key is automatically the primary key of an entity.

  1. A

    True

  2. B

    False

04
Written response
1 point

What ER modeling term names an attribute, or set of attributes, that uniquely identifies an entity instance?

05
Fill in the blank
1 point

An attribute is a of an entity. An individual thing belonging to an entity type is an .

06
Open ended
1 point

Explain the roles of entities and instances, attributes, and keys in an ER model. Then describe what an ERD presents and why it is useful before implementation.

07
Choose one
1 point

Which statement correctly describes the relationship between candidate keys and a primary key?

  1. A

    A candidate key is always a property with a nonnumeric value.

  2. B

    A primary key is an ERD, while a candidate key is an entity instance.

  3. C

    A candidate key can uniquely identify rows; one candidate key is selected as the primary key.

  4. D

    A candidate key describes an association between entity types.

08
Choose all
1 point

Select all the correct statements about attributes, keys, and ERDs.

  1. A

    An attribute is a property of an entity and should have a defined meaning and appropriate value type.

  2. B

    An instance is a property that describes every entity of the same type.

  3. C

    A key is an attribute, or set of attributes, that uniquely identifies an entity instance.

  4. D

    An ERD visually presents information and associations, helping people check requirements before implementation.

09
True or false
1 point

An ERD visually presents a system's information and associations, which can help check requirements before implementation.

  1. A

    True

  2. B

    False

10
Written response
1 point

In a library system, Book is an entity type. What is one particular book called relative to that entity type?

11
Fill in the blank
1 point

In ER modeling, a kind of thing the system records is an ; an individual thing of that type is an .

12
Choose one
1 point

What is the main purpose of an entity-relationship diagram (ERD)?

  1. A

    It stores the system's records and enforces constraints during operation.

  2. B

    It visually presents the information a system needs and the associations among that information.

  3. C

    It automatically chooses a primary key for every table.

  4. D

    It specifies the programming language used to implement a system.

13
True or false
1 point

In an ER model, an attribute is a property of an entity and should have a defined meaning and an appropriate value type.

  1. A

    True

  2. B

    False

14
Written response
1 point

What three-letter abbreviation names the diagram that visually presents an entity-relationship design?

15
Choose one
1 point

What is the role of a table's primary key?

  1. A

    It uniquely identifies each row in a table.

  2. B

    It describes a property shared by all tables.

  3. C

    It connects two rows without referring to a key.

  4. D

    It indicates whether an entity participates in a relationship optionally.

16
True or false
1 point

A key in an ER model must always be a single attribute; a set of attributes cannot uniquely identify an entity instance.

  1. A

    True

  2. B

    False

17
Written response
1 point

What is the ER-model term for a property of an entity, such as a student's name?

18
Choose one
1 point

A system records students under the entity type Student. How should one individual student and Student be classified?

  1. A

    The student is an attribute, and StudentName is an instance.

  2. B

    The student is an entity type, and Student is a key.

  3. C

    The student is an instance, and Student is an entity type.

  4. D

    The student is a key, and Student is a relationship.

19
Written response
1 point

What is the general ER-model term for an attribute or set of attributes that uniquely identifies an entity instance?

20
Choose one
1 point

Which statement correctly describes the relationship between candidate keys and the primary key?

  1. A

    A candidate key is selected to describe an entity's attributes; the primary key may not identify rows.

  2. B

    A candidate key could uniquely identify rows; one is selected as the primary key.

  3. C

    A candidate key is an instance of an entity; the primary key is its relationship.

  4. D

    Candidate keys and primary keys are unrelated to identifying rows.