Consider a disk with the following characteristics (these are not parameters of any particular disk unit): block size B=512 bytes, interblock gap size G=128 bytes, number of blocks per track=20, number of tracks per surface=400. A disk pack consists of 15 double-sided disks. i. What is the total capacity of a track and what is its useful capacity (excluding interblock gaps)? ii. How many cylinders are there? iii. What are the total capacity and the useful capacity of a cylinder? iv. What are the total capacity and the useful capacity of a disk pack? 2. After a transaction is submitted to a DBMS for execution it may fail. There are several possible reasons for a transaction to fail in the middle of execution. What are some of more common types of failures among all possible ones? Name and briefly explain at least 3 types. 3. What are some of the issues that are addressed in the area of database security? Give one example for each issue. 4. Describe some of the advantages of distributed databases and name the additional functions that that the Distributed Database Management System software must be able to provide in order to achieve the above advantages. 5. Define data mining and describe some of its applications.