Video Summary - Functional Dependency/Ketergantungan Fungsional Dalam Basis Data

Functional Dependency in Databases

Functional dependency is a foundational concept in database normalization.

X → Y means that X functionally determines Y: whenever two records have the same value for X, they must also have the same value for Y.

X is the determinant.
Y is the dependent.
A determinant can determine multiple attributes.
Multiple attributes can work together to determine a dependent attribute; curly braces can be used to group them.

Student ID (NIM) → student name, study program, department Each student ID identifies one student and their recorded program and department. A name does not determine a student ID because different students may share a name.
Course code → course name, credits A course code identifies the course details.
Student ID and course code → grade A student may take multiple courses, so student ID alone does not determine a course or grade. A course code alone does not determine a grade because different students can earn different grades in the same course. The example assumes one recorded grade per student-course pair. If repeated attempts are recorded, additional information—such as the year or attempt—is needed.
Study program → department In the example, each study program belongs to one department.

To test whether X determines Y, check whether each value of X is associated with only one value of Y.
Repeated values of X are not a problem if the corresponding Y value remains the same. If one value of X is associated with different Y values, then X does not determine Y.
A determinant can be a combination of attributes, as in (student ID, course code) → grade.
Dependencies can form a chain: student ID → study program → department. Therefore, student ID also indirectly determines department.

Speaker: One presenter/narrator, identified by the channel as P Indah Ciptayani.
Other speakers or sources: None identified in the subtitles.