Copyright

What is the Entity-Relationship Model? - Diagram & Examples

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

What is the lowest design level (the least detail) for an ERD?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 75,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime.
Already registered? Login here for access

1. The term 'cardinality' refers to what aspect of an ER model?

2. What is the entity attribute that uniquely identifies an instance in a table called?

Create your account to access this entire worksheet
A premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

When working with a complex database knowing the relationship between entries can sometimes be helpful, if not essential. When assessing these relationships we often use the Entity-Relationship model. This assessment was assembled by our professional instructors to test your understanding of the Entity-Relationship model and its components.

Quiz & Worksheet Goals

The material covered in this assessment includes:

  • Design levels of ERD
  • Cardinality in ER
  • Various types of entity attributes
  • 1:m cardinality
  • How to reference data fields in a database table

Skills Practiced

A few of the skills needed to complete this assessment include:

  • Making connections - use your understanding of ERD
  • Information recall - access the knowledge you've gained regarding cardinality
  • Knowledge application - use your knowledge to answer questions about entity attributes

Additional Learning

Improve your understanding of the Entity-Relationship model by completing the lesson, What is the Entity-Relationship Model? - Diagram & Examples. This lesson will detail information found in this assessment, as well as:

  • Definitions of important related vocabulary
  • How to graphically show relationships between entities
  • The different types of cardinality
Support