Consider a Relation: Student (EnrolNo, StudentName, ProgrammeCode, ProgrammeName,
CourseCode, CourseName, Grade). Some of the constraints on the relation Student are:
A student is assigned one unique Enrolment Number (EnrolNo).
Two students may have same name.
A student can register in one Programme only.
6
A Programme consists of several compulsory courses.
Grades can be “A”, “B”, “C”, or “D” and only one grade value is recorded for a student
in a course.
Perform the following task for the relation given above:
(i) What is the key to the relation?
(ii) Identify and list the functional dependencies in the relation.
(iii)Make an instance of this relation showing possible redundancies.
(iv) Decompose R into 2NF and 3NF relations.
(i) Key to the Relation
In the given relation Student(EnrolNo, StudentName, ProgrammeCode, ProgrammeName, CourseCode, CourseName, Grade), the key is a minimal set of attributes that can uniquely identify a record in the relation.
- EnrolNo is the unique identifier for a student, which guarantees that each student is uniquely represented by this attribute.
- Since EnrolNo uniquely identifies the student, we can say that EnrolNo is a candidate key.
However, considering that EnrolNo is unique for each student, the combination of attributes like (EnrolNo, CourseCode) is also a potential candidate key, as it ensures that each student's enrollment in a specific course is unique.
Thus, the primary key for this relation is likely EnrolNo, and the relation can be uniquely identified by this key.
(ii) Functional Dependencies
A functional dependency defines a relationship between two sets of attributes in which one set can uniquely determine the other. For this relation, we need to identify all the functional dependencies based on the constraints provided.
From the constraints:
- A student is assigned one unique EnrolNo: This implies that EnrolNo → StudentName, ProgrammeCode, ProgrammeName.
- A student can register in only one programme: This implies that EnrolNo → ProgrammeCode, ProgrammeName.
- A Programme consists of several compulsory courses: ______ _________ ___ ________ ___ _________ _____.
______ ______ _____ ________ _________ _______ ___ ________ ____ ___ ________.
___ _____ ___ __________ _________ ___ _______ _______ __________ ____ _______ ____.
________ _______ ___ ______ ________ _____ ___ ________ ____ _____.
____ _______ _______ _____ _______ ____ ________ ___.
_____ ______ _______ __________ ___ __________ ____ ____ _______.
____ _____ _____ ___ _____ ______ ___ _____ _________ ________ _____ ___.
___ __________ _______ ________ __________ __________ _________ _______ ______ _____ __________ ______.
________ ___ __________ ___ ______ ____ __________ _________ __________ _____ ___ _____.
____ _____ __________ __________ _____ ____ _________.
_________ _______ ________ ____ ___ ___ _______ ________.
___ ____ ___ _____ ______ _____ ________ ______ _______ _____ ___ ____.
____ ___ _____ ________ _____ ______ ____ _________ ______ _____ _____.
______ ______ _________ ________ _____ _________ ______ _____ _________ ____.
______ _________ ________ ______ __________.
_____ ___ ____ ____ _______ _______ __________ ________ _______ _____ __________.
__________ _______ ________ _____ ____ ________ _______ ________ _________ ____.
__________ ____ _________ ____ ___ _________ _________ ______.
_____ ________ ____ __________ ______ _________ _______ ___.
_________ ___ __________ _____ ________ __________ ________.
_____ _______ _______ _____ __________ __________ ___ ______ ____ _________ _____ _____.
_____ _______ ___ ______ __________ ___ ______ _______ ______ ______ ___.
______ ____ ____ ____ ________.
___ _________ ______ _____ _______.
____ ______ _____ ________ ______ _____.
___ _________ ____ _____ _______ _______ ________ __________.
__________ __________ ____ ________ ________ _______ _____ ____.
____ _______ ___ ______ ____ ___ _____ ______ _____ _____ ___.
_________ ________ ______ _______ _________ _________ __________ _________ ______.
________ _________ _____ __________ __________ ________ ________ ________ _______.
____ __________ _____ _____ _______ _____ _______ ________ ______ ___.
_______ ______ ________ ________ ____ ________ ____ _______ ______.
____ ____ _________ ______ __________.
______ ____ ___ __________ ___ _____ __________.
_________ __________ _________ ________ ___ _________.
_______ __________ __________ _____ __________ __________.
__________ _________ ___ ___ ____ ______ ______ ________ ________ _________ ___ _________.
__________ __________ _________ _______ __________ _______.
______ __________ _______ ________ ____ ________ ___ ________.
_________ _______ _____ ______ ________ ________ ___ ___ _______ ________ _______ ____.
________ ____ _______ ____ _______ ________ _________ ________ ___ ________ ___.
____ ___ _______ ___ ______ ____ _________ _______ ______ _____ _____ _____.
_____ _____ _________ _____ _____.
_______ ______ ______ ________ _______ _____ ___ ___ ______ _________.
____ _________ _______ _________ ______ _________ _______ ___ __________ ______.
________ __________ ______ _________ _________ ____ _____.
__________ ___ ______ _________ _________ _______ ___ ______ ________ _______.
______ ___ _______ ___ ____ ________ __________.
______ _________ ________ ______ _____ ___.
_________ ________ ____ ______ __________ ___ _______ _____ ____ __________.
___ ____ ______ ______ ________ ________ _____ ____ ______ ___ __________ ____.
________ __________ _______ ________ ______ ________ _____ ______ ___ __________ ________ ____.
___ _____ ___ ________ ____ _________.
_________ __________ ________ ____ _______ _________ __________ ___ _________ ______ _____.
____ _______ __________ ______ ______ ______ _____ _____ _________ _____ ______ _________.
______ _______ ____ __________ _____ __________ ________ ________ ________ ______ _______.
________ ________ _____ ___ _________ _________ ______ ______ ________ ________ _____.
______ _______ __________ ___ ____ ______ ___ ___.
__________ ________ ________ ____ ________ ________ ___ ___ ____.
_________ ________ _____ _____ ________.
_______ __________ ________ _____ ________ ___ ______.
____ _____ _______ _______ __________ _____ ________ _____ ____ _____.
____ __________ _______ _________ ___ ____ _____ ________.
__________ ____ ________ ________ _________ __________ __________ _________ ________ _______ __________ ______.
_______ __________ ________ _____ _________.
___ ____ ____ ___ _______ ___ _____ ___ _______.
__________ ____ ________ ___ _________ ___ ___ ______ _____ ____ _________ ___.
________ _________ __________ ________ _________ ________ _________.
_________ ____.
Get Full Answer on WhatsApp