Skills101
← All practice quizzes

Quiz: ER to Tables

5 questions · new set on every retakeNo time limitPass: 60%+10 XP on first pass

Take one realistic ER diagram — departments, students, courses, faculty, phone numbers and prerequisites — and convert it into tables with the seven mapping rules, then run real queries on the result.

Log in to take the quiz

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

  1. Question 1

    In a 1:N relationship between Department (1) and Student (N), where does the foreign key go?

  2. Question 2

    How is an M:N relationship such as Student enrolls Course mapped?

  3. Question 3

    A student can have several phone numbers. What is the right design?

  4. Question 4

    The attribute "grade" in Student enrolls Course belongs in which table?

  5. Question 5

    Why is age usually not stored as a column?

🎯 Today’s placement challenge — 10 questions, no login. Can you score 10/10?Take today’s challenge →