Consider the following schedule involving two transactions, T1 a

Question

Consider the following schedule involving two transactions, T1 and T2, where A and B are data items with initial values A=1000, B=2000.

01 Dec 2025

Answer :

Word Count : 204

In the given schedule involving two transactions T1 and T2, the operations on data items A and B need to be analyzed for consistency and correctness according to Database Management System (DBMS) principles. Transactions ___ _____ ____ _________ ____ ______ ___.
________ _____ ___ _____ ______ ____ ____ __________ ___ ___ ___.
________ _____ _________ ______ _________ ______.
___ __________ ____ _______ ________ _________.
__________ ________ __________ _____ _________ ________ ________.
_______ ____ ______ _____ _______.
_________ ______ __________ ______ _____ __________ __________ ___ ________ ___ __________.
____ __________ ________ _________ __________.
______ _____ ______ ___ _____ _________ ___ ___ _______ ________ _________ ____.
___ _________ ____ ______ _______ _________ ____.
________ ________ ______ __________ ______.
________ __________ ______ ___ _____ _________.
______ _____ _________ ________ _____ ______ _______ ______ ____ _____ ______.
__________ ____ ___ __________ _______ __________ ________ _____ __________.
_____ _____ ___ ______ _____ ____ ____ ____ _________ __________.
_______ ____ ____ ______ __________ __________ ____.
_________ ______ __________ ___ _________ ______ ____ ____ _____ ___.
_________ ____ ________ ______ _____ ________ __________.
__________ ______ _____ ____ ____ ______ ___ _______ _______.
_______ ____ ______ ______ _________.
__________ _____ ____ ______ _____ ___.
________ ________ __________ ____ _____ ____ ____.
_________.
Get Full Answer on WhatsApp

Related Questions

me	T1	T2
t1	READ(A)
t2	A = A - 100
t3		READ(A)
t4		A = A * 1.1
t5		WRITE(A)
t6		READ(B)
t7	WRITE(A)
t8	READ(B)
t9	B = B + 100
t10	WRITE(B)

(a) Consider a Relation: Course(CourseCode, CourseName, ProgrammeCode, ProgrammeName, CourseCredit, CourseDuration, Programme Duration, ProgrammeCredit). Some of the constraints on the relation Courseare:

CourseCode uniquely identifies a course.

ProgrammeCode is a unique code of a programme. A programme consists of many courses. A course can be part of multiple programmes.

A Programme consists of compulsory courses and optional courses. To complete a Programme, a student must complete all the compulsory courses and optional courses, as per the total credit requirements of a Programme.

Perform the following tasks 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 consisting of at least 8 to 10 records, showing possible redundancies.

(iv) Decompose the relation Courseinto 2NF and 3NF relations.

(b) What is multi-valued dependency? Explain with the help of an example. How can it be used to decompose a relation into the 4th Normal Form? Explain with the help of an example. Also, explain the concept of the Join dependency with the help of an example.

(d) Consider the following relational database:

Member (memberId,memberName, memberAddress, memberPhone)

BookIssued (memberID, BookID, Issue Date, returnDate)

Book(BookId, BookTitle, FirstAuthor)

The underlined attribute(s) in the relations given aboveform the primary key. In relation Member the attribute memberId is the unique identifier of a member. The purposes of other attributes in the Member relation are self-explanatory. You may define the domain of different attributes. Pleasenote that the BookIssued relation has two foreign keys,namely memberID and BookID, which reference the Member and Book relations, respectively. 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 each in the Member and Book tables and about 10 records in the BookIssuedtable.

(iii) List the name and phone number of all the members in lexicographical order.

(iv) Find all the Books issued to the member whose memberID is "0001".

(v) a book is not returned if returnDate is NULL) Find the list of those members who have not returned more than one book. (Assume that

(vi) Find the number of books whose first author's name is "XYZ".

(vii) Find the pair of members who have the same memberPhone.

(viii) Find the list of Books whose title includes the term "Database".

(ix) Find the title of the book that has been issued the most.

(x) Find the list of members who have not issued any books.

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★