Question

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.

13 Sep 2024
Answer :
Word Count : 816

(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 _______ ________ _____ ____ _______ ________ ____ _____ ________ ________ ________.
_____ _________ __________ ________ _________ ____ ___.
_____ _______ _________ ___ ______ ______ __________ ________ __________ _____ ____.
__________ ________ ____ _____ ___.
________ _________ ____ ____ ____.
_________ ________ __________ ______ ____ _________ ____ __________ ________ _________ __________ _________.
_______ ______ ____ __________ ___ ___ ____ ___ __________ _____ _____ _________.
______ _______ __________ ___ ___.
_______ _______ _____ _________ _______ ________ __________ ______ _________ ____.
______ __________ __________ ______ _____ __________ ________ ____ ________ ____ ________ __________.
____ _____ ______ ____ ________ _________ _________ __________ _____ _______ ____.
_________ _____ ____ ________ _________ __________.
________ ____ _______ ___ _______ ___ _____ ________ __________ _______ __________.
__________ _______ ______ _____ _________.
_____ ___ _______ __________ ________ _______ _______ ________.
______ ________ ________ _______ ___ ___ ____ _____ __________ ___ _________.
_________ _____ ____ ________ __________ _______ ________ ____.
_______ ______ __________ ____ ____ ____ ____ _____ ______ _____.
_________ ____ ________ ____ ____ ________ __________ ____ ______.
________ _________ _________ _______ __________ _____ ___ ________.
______ ____ ___ ______ _____ __________ _________ ___.
___ ____ _________ ___ ____ ________ ___ _____ ___.
_______ _________ _____ _________ _____ ________ _________ __________.
___ _______ ___ ________ ________ ______ __________ _______.
_____ ___ ______ _________ ___ _________ _________ _____.
________ ________ _____ ___ _____ _______ _________ _______ ___ ____ ________ _______.
___ ________ ___ _________ ________.
________ _______ _______ _________ _________ _______ ______ ___ ________ __________ ____ ________.
___ _________ ____ ________ __________ __________ _____.
____ ___ ___ ___ ___.
___ _________ __________ __________ _______ ______ _______ __________ _______ ____.
_____ _______ _________ _______ _________ ____ ______ _________ ____ __________ __________ _______.
__________ _________ _________ _________ _______ _______ _________ ___ ____ _________.
____ _____ _________ ________ _____ _________ _______ _____ ________ ___.
_________ _______ _______ _______ ___ ___.
__________ __________ ____ ______ ____ __________ ____ _______ ________.
_________ _____ _______ ___ _____.
__________ _______ ___ _____ ______ ____ _________.
___ _______ ___ ____ ________.
________ _______ ________ ____ ____ ______ ____ ________ ______ _______.
_________ ______ ______ ________ ___ _______ ______ _______ ____.
__________ ____ __________ ____ _________ _______ _______ ______.
____ __________ _______ _____ _______ ____ __________ __________.
________ _____ _________ __________ _______ __________ ______ ______.
_______ ____ __________ ______ ______ _______ _________.
________ _______ _________ _______ _______ _________ __________.
_________ _________ _________ _______ _________ _____ _____ _______ ___ ________ __________.
__________ ________ ______ _____ _____ _____ _________ ________.
_______ _________ ________ ______ ____ _____ _____ ______ _______ ______ ______.
___ _________ ______ ______ ______ ________ _________ _________ __________ ______.
________ _________ ______ _____ __________.
______ ___ ___ ______ ________ _______ _________ _________ _____ _______.
_________ _____ _____ _______ _____ _______ ____ ___ _________ ____ _________ _______.
___ ___ ___ ________ __________ ____.
________ ___ ___ _______ _________ ___ ____.
___ ________ _________ ___ ____ _______.
______ ___ ____ _________ __________ ___ ___ __________ _____ ______ _________ ________.
____ ___ _______ ________ ____ __________ ______ __________.
________ _________ __________ ____ ___ __________ __________.
_____ ____ ________ _________ _____ ________ ______ ___ ____.
______ _____ _______ __________ ____ _________ ____ ______ ______ _____ _____.
_______ _______ _________ _______ ___ __________ _________ ______ _____ ____ ______ ______.
______ ________ _____ __________ _________ _______.
_____ ______ _______ ____ ________ ___ _______ ___.
_______ _________ __________ __________ _________.
__________ ___ _________ _______ _____ _____ __________ _____ _________ ________.
__________ _________ ______ _______ ____ __________ ___ _________ ____ ________.
_____ ___ __________ _________ _______ ________ _______ ___ __________ _____.
________ _______ __________ _______ _______ _____ ________ _____ _________ ________ _____.
_________ ____ _________ ____ ______ ______ ____ ________ _______.
______ _____ _________ ________ ____ ________ __________ __________ _____ ___.
_____ ________ ______ __________ ____ ______ _______ ______ ___ ____ ___.
___ _______ _____ ________ ______ ___ _____.
______ _________ ____ _______ ___ ______ _____ ________ ___ ________.
_____ ____ ____ ________ _________ ________.
______ _______ ____ ________ _______.
________ ___ ________ ____ __________ ________.
___ __________ ______ ________ _________ ______ ____ _______ ___ _____ ___.
____ _____ _____ ________ _______ _______ ___ _______.
______ ___.
Get Full Answer on WhatsApp

Related Questions

Explain the following terms in the context of a relational model with the help of one example of each– Super key, Domain, Cartesian Product, Primary Key, Natural join, Set Intersection, Set Difference operation and referential integrity constraint. 

What are object-relational database? Explain the concept of complex data types used in these databases. Explain the object model in the context of Object Oriented database systems. How objectoriented database systems are different from Object-relational database systems

Explain the multi-dimensional data model of a data warehouse. Also, define the concept of decision tree with the help of an example. List any four applications of data mining.

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.

Consider the following relational database:

Customer (custId, custName, custAddress, custPhone)
Account (AccountNumber, custId, TypeOfAccount, Balance)
Transaction (DateTimeofTransaction, AccountNumber, DebitORCredit, Amount)

The underlined attribute(s) in the relation forms the primary key. In relation Customer, the custID is
the unique identifier of a customer. The purposes of other attributes in Customer relation are self
explanatory. You may define the domain of different attributes. The TypeOfAccount attribute can
take the value (“Saving”, “Current”, “Salary”, “Other”). Please note that at a specific time of a date
only one transaction can be performed from an account. Please also note that the Account relation
has foreign key custID and Transaction relation has foreign key AccountNumber. Write and run the
following SQL queries on the database:
(i) Create the tables with the primary and foreign key constraints.
(ii) Insert at least 5 records in the first 2 tables and 20 records in the 3rd table.
(iii) List “Saving” Account details showing the AccountNumber, custName, custPhone,
Balance of all the accounts. These records should be shown in the order of custName.
(iv) Find all the transactions made by customer whose custID is “240002”.
(v) Find the list of those customers who have more than one account.
(vi) Find the total of Debit transactions made for Account Number “A0054”
(vii) Find the total of balance of all the accounts of a customer.
(viii) Find the list of customers whose name start with an alphabet “B”
(ix) List the pair of customers who share the same phone number.
(x) Find the list of the customers, who have not made any credit transaction since 1st January,
2023.

A University maintains the list of the books available in its library using a database system. In
addition, this system is used for issue and return of books to its students. This database is used to find
the following details by the students of the university and the staff of the library:
 List of the classification number, ISBN number, Title, Author Names, Subject Area of the
books.
 Searching of books using subject area, Title and Author name.
 List of books that are issued to a specific student.
Draw an ER diagram for the library. Specify key attributes and constraints on each entity type and
on each relationship type. Note any unspecified requirements and make appropriate assumptions to
make the specification complete.

Explain the ACID properties of transactions with the help of an example of each.

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login Cart
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top
📞
Call Support Instant phone assistance Consider a Relation: Student (EnrolNo, StudentName, ProgrammeCode, Pro
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→