A system records students. Which statement correctly distinguishes the entity type from an instance?
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.
Select all the correct statements about the basic building blocks of an ER model.
- A
An entity is a kind of thing the system records.
- B
An instance is an individual example of an entity type.
- C
An attribute is a relationship between two entity types.
- D
A key uniquely identifies an entity instance.
- E
An ERD presents the design visually, including information and associations.
Every candidate key is automatically the primary key of an entity.
- A
True
- B
False
What ER modeling term names an attribute, or set of attributes, that uniquely identifies an entity instance?
An attribute is a of an entity. An individual thing belonging to an entity type is an .
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.
Which statement correctly describes the relationship between candidate keys and a primary key?
- A
A candidate key is always a property with a nonnumeric value.
- B
A primary key is an ERD, while a candidate key is an entity instance.
- C
A candidate key can uniquely identify rows; one candidate key is selected as the primary key.
- D
A candidate key describes an association between entity types.
Select all the correct statements about attributes, keys, and ERDs.
- A
An attribute is a property of an entity and should have a defined meaning and appropriate value type.
- B
An instance is a property that describes every entity of the same type.
- C
A key is an attribute, or set of attributes, that uniquely identifies an entity instance.
- D
An ERD visually presents information and associations, helping people check requirements before implementation.
An ERD visually presents a system's information and associations, which can help check requirements before implementation.
- A
True
- B
False
In a library system, Book is an entity type. What is one particular book called relative to that entity type?
In ER modeling, a kind of thing the system records is an ; an individual thing of that type is an .
What is the main purpose of an entity-relationship diagram (ERD)?
- A
It stores the system's records and enforces constraints during operation.
- B
It visually presents the information a system needs and the associations among that information.
- C
It automatically chooses a primary key for every table.
- D
It specifies the programming language used to implement a system.
In an ER model, an attribute is a property of an entity and should have a defined meaning and an appropriate value type.
- A
True
- B
False
What three-letter abbreviation names the diagram that visually presents an entity-relationship design?
What is the role of a table's primary key?
- A
It uniquely identifies each row in a table.
- B
It describes a property shared by all tables.
- C
It connects two rows without referring to a key.
- D
It indicates whether an entity participates in a relationship optionally.
A key in an ER model must always be a single attribute; a set of attributes cannot uniquely identify an entity instance.
- A
True
- B
False
What is the ER-model term for a property of an entity, such as a student's name?
A system records students under the entity type Student. How should one individual student and Student be classified?
- A
The student is an attribute, and StudentName is an instance.
- B
The student is an entity type, and Student is a key.
- C
The student is an instance, and Student is an entity type.
- D
The student is a key, and Student is a relationship.
What is the general ER-model term for an attribute or set of attributes that uniquely identifies an entity instance?
Which statement correctly describes the relationship between candidate keys and the primary key?
- A
A candidate key is selected to describe an entity's attributes; the primary key may not identify rows.
- B
A candidate key could uniquely identify rows; one is selected as the primary key.
- C
A candidate key is an instance of an entity; the primary key is its relationship.
- D
Candidate keys and primary keys are unrelated to identifying rows.
Related study packs and tools
02 — Information and Representation
A progressive guide to how computers encode numbers, text, images, and sound as binary data, including the trade-offs and limits of digital representation.
2 Digital Logic
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
03 — Python Programming Fundamentals
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
6 Computer Memory
Learn how computer memory stores and addresses information, how RAM and ROM differ, and how caches and the memory hierarchy balance speed, capacity, and cost.
07 Trees and Binary Search Trees
A progressive guide to tree structure, binary-tree traversals, binary search tree operations, deletion, balancing, and the way tree height determines time and space costs.
10 — Data, Systems, and Applications
A progression through how data is organized, searched, exposed through software interfaces, and managed through abstraction layers in modern computer systems.
Interrupts
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
OS Processes
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
Systemcalls
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.