Skills101
← All practice quizzes

Quiz: ER Model

5 questionsNo time limitPass: 60%+10 XP on first pass

Design a database on paper before building it. Entities, attribute types, relationships, one-to-one / one-to-many / many-to-many, and turning an ER diagram into tables.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    In an ER diagram, a diamond represents:

  2. Question 2

    "Age calculated from date of birth" is which type of attribute?

  3. Question 3

    Students and Courses (a student takes many courses; a course has many students) is:

  4. Question 4

    How is an M : N relationship stored in tables?

  5. Question 5

    Department (1) — Employee (N). Where does the foreign key go?