Suppose that the transaction processing system of your university contains a table in which there is one tuple for each current student.

a. Estimate howmuch disk storage is required to store this table.
b. Give examples of transactions in the student registration system that have to lock this entire table if a table locking concurrency control is used.

a. 10,000 tuples * 100 bytes/tuple = 1 megabyte.
b. Find all students who are registered in at least one course.

Computer Science & Information Technology

You might also like to view...

In a folder window, the ________ command enables you to sort items by Name, Date modified, Type, Size, Date created, authors, Tags, and Title, in Ascending or Descending order

Fill in the blank(s) with correct word

Computer Science & Information Technology

The output of the statement:cout << pow(2.0, pow(3.0, 1.0)) << endl;is ____.

A. 6.0 B. 7.0 C. 8.0 D. 9.0

Computer Science & Information Technology