Suppose that the transaction processing system of your university contains a table in which there is one tuple for each currently registered student.
a. Estimate howmuch disk storage is required to store this table.
b. Give examples of transactions that must 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...
Increasing the zoom percentage also increases the font size in the file
Indicate whether the statement is true or false
Computer Science & Information Technology
An SSD laptop hard drive has no moving parts and produces less heat than a mechanical drive
Indicate whether the statement is true or false
Computer Science & Information Technology