Explain the concept of Multi-valued dependency and Join dependency with the help of an example of each. Also, explain the 4th Normal Form and 5th Normal form.

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.

Design normalised tables in 3NF for the ER diagram drawn in part (c), with the required integrity constraints

Design normalised tables in 3NF for the ER diagram drawn in part (c), with the required integrity constraints

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 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. 

Explain the three level DBMS architecture with the help of an example. Also, explain the concept of data independence in the context of database systems with the help of an example. 

Explain use of commit () and rollback() in JDBC programming with the help of a small program

Write a Java program using JDBC to manage saving accounts of a bank. Make necessary assumptions. Make provisions of exception handling in your program. 

What is FXML? Explain event handling in JavaFX.

Explain Swing package/class hierarchy. What is difference between AWT and Swing ? 

Explain use of List interface and Vector class in Java. 

What is multithreading? Explain how multiple child threads are created? Write a java program to demonstrate interthread communication. 

What is an exception? Explain various causes of exceptions. How exceptions are handled in java? Explain how user defined exceptions are created in Java.

What is polymorphism? Explain its advantages with examples

What is abstract class? Explain its advantages. How is it different from Interface?What is abstract class? Explain its advantages. How is it different from Interface?

What is inheritance? What are different types of inheritance supported by java? Explain how inheritance is implemented in java with the help of an example. 

Explain use of java File class and its methods with the help of examples 

Write a java program to find sum of two matrices. Define proper class and methods in your program. 

What is Character class? Explain use of compareTo and toString methods of Character class