ER Modeling Quiz
Test your knowledge and skills in Entity-Relationship modeling. Please answer all questions carefully.
Full Name
*
First Name
Last Name
Email Address
*
example@example.com
1. Which of the following best describes an entity in ER modeling?
*
A real-world object or concept about which data is stored
A relationship between two tables
A field in a table
A type of attribute
2. Select all the possible types of relationships in ER modeling.
*
One-to-One (1:1)
One-to-Many (1:N)
Many-to-Many (M:N)
Self-Referencing
Other
3. Match the ER modeling terms with their descriptions.
*
Rows
Entity
Attribute
Relationship
Primary Key
Select the correct description for each term
A real-world object or concept
A property of an entity
A connection between entities
A unique identifier
A real-world object or concept
A property of an entity
A connection between entities
A unique identifier
A real-world object or concept
A property of an entity
A connection between entities
A unique identifier
A real-world object or concept
A property of an entity
A connection between entities
A unique identifier
4. What is the minimum number of tables required to represent a many-to-many relationship in a relational database?
*
5. Which attribute type can have multiple values for a single entity?
*
Composite Attribute
Multi-valued Attribute
Derived Attribute
Simple Attribute
In ER diagrams, diamonds are used to represent
What do diamonds represent in ER diagrams?
.
7. Given the following scenario, identify the entities and relationships: 'A university has multiple departments. Each department offers several courses. Students enroll in courses.' List the entities and describe at least two relationships.
*
8. Rate your confidence in drawing ER diagrams.
*
1
2
3
4
5
9. Upload your hand-drawn ER diagram for the scenario in question 7 (optional).
Upload a File
Drag and drop files here
Choose a file
Cancel
of
Submit Quiz
Should be Empty: