Workdocumentation 2024-02-02

Prompt

Ask a multi-choice quiz question about Functional Dependencies to a bachelor student with no prior contact with relational theory

ChatGPT

Here's a multiple-choice question designed to introduce the concept of Functional Dependencies to a bachelor student with no prior background in relational theory:

Consider a table in a school database that records 
the following information for each student: 
Student ID, Student Name, Course Code, and Course Name.
Each student can enroll in multiple courses. Which of
the following statements best describes a Functional
Dependency in this table?

A) Knowing the Course Name allows you to determine 
the Course Code.

B) Knowing the Student Name allows you to determine 
the Student ID.

C) Knowing the Student ID allows you to determine 
the Student Name.

D) Knowing the Course Code allows you to determine 
the Student ID.

The correct answer is C) Knowing the Student ID allows you to determine the Student Name. This question helps to illustrate the concept of Functional Dependencies by relating it to a familiar context, without requiring prior knowledge of relational database theory.