csev/py4e

Error In Database Quiz

NDhingra01 opened this issue · 1 comments

Greetings Dr Chuck @csev,

While I was doing the quiz on database and the quiz is called Quiz: Many to Many and the last question which is 10th

10. What do we generally avoid in a many-to-many junction table?

  • Data items specific to the many-to-many relationship
  • An AUTOINCREMENT primary key column
  • A logical key
  • Two foreign keys

This question is driving crazy to every person in the discussion. Can you please give this question a look and see what's happening in the discussion because it's kinda hard and tough to find the answer.

Thank you for reading and reviewing

Please also provide a bit more info. Is this the external PY4E, or on Coursera, edx or somewhere else and a URL, section/location to help find the problem or the title of one of the posts.
It's the external site, section 16 Databases. Part of it is a process of elimination, check q1 what is used, and q10 what is not.
1st in a browser a circle option, 'radio-button', is a single selection, and a square check box is multiple selections. Then you are looking for at least 2 answers.

In 1 example the 3-month-old post, the tables in the post uses User & Course, those are not the M-to-M table the question is about. In the video M-to-M @01:55, the table is Member, and one of the options is used here so it is allowed. Between q1 and what is in the video, you have at least 2 correct answers to tick.

So the one change appears to be adding the text "Select more than 1 answer".