ERD:

Scenario:

The above ERD represents the details of a simple course database which records the course registration details of students. The course entity has a unique identifier CourseNum and the Registration entity is allocated a partial key. The mode represents the mode of registration: online or on-campus. A student may have more than one phone number.

Semantic Rules:

1. Each course may have many registrations.
2. Many registrations are recorded for each course.
2. Each student may register only once.
2. Each student can have multiple registrations.

Question: Which of the following functional dependencies represent full functional dependency?

Question

ERD:

Scenario:

The above ERD represents the details of a simple course database which records the course registration details of students. The course entity has a unique identifier CourseNum and the Registration entity is allocated a partial key. The mode represents the mode of registration: online or on-campus. A student may have more than one phone number.

Semantic Rules:

1. Each course may have many registrations.
2. Many registrations are recorded for each course.
2. Each student may register only once.
2. Each student can have multiple registrations.

Question: Which of the following functional dependencies represent full functional dependency?

BlackTom AI · Accepted Answer

We start by identifying the concept at play: full functional dependency means that a non-key attribute is functionally determined by the whole candidate key, and not by just part of a composite key. Now, let's examine each option in turn.

Option 1 (A): 'CourseNum --> Name, Description' and 'RegistrationNum,CourseNum --> RegistrationDate, Mode'.
- For the Course relation, CourseNum is the key and determines Name and Description. Since CourseNum is a whole key for that relation, this FD is a full functional dependency in the Course relation.
- For the Registration relation, the combined key (RegistrationNum, CourseNum) determines RegistrationDate and Mode. Because the determinant is the entire composite key, this is also a full functional dependency within the Registration relation.
So, both FDs in this option represent full functional dependencies.

Option 2 (B): 'StudentNum --> Name, Phone, Email'.
- If StudentNum is the key for the Student relation, then it functionally determines Name, Phone, and Email. This is a full functional dependency as well, since the determinant is the (single-attribute) key of that relation.
Thus, this is also a correct example of a full functional dependency.

Option 3 (C): 'RegistrationNum,CourseNum --> RegistrationDate, Mode'.
- This repeats the same full FD seen in option A for the Registration relation: the entire composite key (RegistrationNum, CourseNum) determines RegistrationDate and Mode. This is a classic full functional dependency.

Option 4 (D): 'RegistrationNum,CourseNum --> RegistrationDate, Mode' and 'StudentNum --> Name, Phone, Email'.
- This option combines the two FDs from options 2 and 3 (and 1) that are each full functional dependencies in their respective relations. Since both parts describe full dependencies on their respective keys, the whole option represents multiple full FD statements.

In summary, all listed FDs describe full functional dependencies: the determinant is either the whole candidate key of the relation or a single-attribute key where appropriate. Each statement correctly reflects a full FD, and Option D simply groups the already-valid full FDs from the other options into one combined choice.

查看解析

登录即可查看完整答案

类似问题

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

Using the Entity Relationship Diagram you have drawn on your piece of paper for the Hamilton Island 'BoatRaceResults' Table, answer the following question. Which functional dependency shows a Transitive Dependency in the BoatRaceResults table?

Using the Entity Relationship Diagram you have drawn on your piece of paper for the Hamilton Island 'BoatRaceResults' Table, answer the following question. Which attribute is fully Dependent on the primary key of the BoatRaceResults table?

Using the Entity Relationship Diagram you have drawn on your piece of paper for the Hamilton Island 'BoatRaceResults' Table, answer the following question. Which are Dependent Non-Key Attributes of the BoatRaceResults table?

You are given this relation: A B C a1 b1 c5 a1 b2 c6 a2 b1 c7 a3 b2 c6 A possible candidate key is: [ Select ] , and a functional dependency is: [ Select ]

Given the following relation R with 5 attributes and the three functional dependencies shown, which of the following is true? Select one answer.

Because of the need to know the functional dependencies in a database, it is a good idea to create a(n) ________.

Because of the need to know the functional dependencies in a database, it is a good idea to create a(n) ________.

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单