Solve your IGNOU Doubts
Solve your IGNOU Doubts
Question:

What is 2-Phase locking? Lock and unlock various data items of the transactions, given in Figure 1, using 2-Phase locking such that no concurrency related problem occurs, when the transactions A, B and C are executed concurrently

See Answer →
Question:

What are the problems that can be encountered, if the three transactions (given in Figure 1) are run concurrently? Explain with the help of different transaction schedules of these transactions.

 

    Transaction  A

      Transaction  B       Transaction  C
        Read  X        Read  X          Read X
        Read  Y        ADD    500           SUBTRACT 200
        Raed  Z        W r i t    X             WRITE  X
         Read   Y  
       SUBTRACT  500  
        W r i t e Y  

                              Figure 1: Three Concurrent Transactions

See Answer →
Question:

What are the problems that can be encountered, if the three transactions (given in Figure 1) are run concurrently? Explain with the help of different transaction schedules of these transactions

See Answer →
Question:

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

See Answer →
Question:

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.

See Answer →
Question:

Explain the following terms with the help of an example of each – Assertion, Cursor, Stored Procedure, Triggers.

See Answer →
Question:

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.

See Answer →
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.

See Answer →
Question:

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

See Answer →
Question:

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

See Answer →
Question:

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.

See Answer →
Question:

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. 

See Answer →
Question:

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. 

See Answer →
Question:

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

See Answer →
Question:

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

See Answer →
Question:

What is FXML? Explain event handling in JavaFX.

See Answer →
Question:

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

See Answer →
Question:

Explain use of List interface and Vector class in Java. 

See Answer →
Question:

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

See Answer →
Question:

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

See Answer →
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
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→