Database | Entity Relationship Model

Which of the following is an environment?

• supermarket

• staff

• customer

• vehicle

Which of the following is false about the entity relationship diagram?

• Entities are represented by rectangles.

• All simple attributes are represented with single-lined ovals.

• Multi-valued attributes are represented with double-lined ovals.

• A derived attribute is connected to the entity by broken lines.

Which of the following is not a notation of the entity relationship diagram?

• Crow's foot

• Crow's nest

• Chen

• UML class diagram

Which of the following is false about the entity relationship model (ERM)?

• The ERM is a model representing the conceptual design of the database.

• An ERM is represented by an entity relationship diagram (ERD).

• An ERM needs to be translated to the data model used by the DBMS, during the logical design.

• The ERM represents data in rows and columns.

Based on the diagram, which is the key attribute?

• STUDENT

• matrix

• address

• age

Based on the diagram, which is the entity?

• STUDENT

• matrix

• address

• age

Based on the diagram, which is the composite attribute?

• STUDENT

• matrix

• address

• age

Based on the diagram, which is the derived attribute?

• STUDENT

• matrix

• address

• age

Based on the diagram, how many simple attributes are there?

• 11

• 10

• 4

• 2

Based on the diagram, how many multiple-valued attributes are there?

• 10

• 9

• 4

• 2