3. Suppose a company wants to store the complete address of each employee, they create a table named employee details that looks like this emp id 1001 1002 1006 1101 1201 emp state UP TN TN UK MP emp district Dayal Bagh emp_name em ohn Ajeet Lora Lill Steve emp_zip 282005 222008 282007 292008 222999 emp Agra Chennai Chennai Pauri Gwalior Urrapakkam Bhagwan Ratan Primary key. (emp id) Non-key attribute: the remaining attributes except for emp_id Question: Does the above relation be in 2NF? (hintl: identify functional dependencies first; hint2: using the conclusion appearing in slides directly) 4. 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. What are the total capacity and the useful capacity of a cylinder? Calculate the average time it would take to transfer 20 random blocks, and compare this with the time it would take to transfer 20 consecutive blocks using double buffering to save seek time and rotational delay 1) 2)