You are interested in knowing the value of PNAME when PNUMBER= 1500. Use your knowledge of physical design (indexes) to outline your solution for 1NF and 2NF. Which one is more efficient and why? Question 2 Consider the following 1NF relation R1 (SSN, PNUMBER, PNAME, HOURS) The normalized (2NF) relations of R1 can be represented as the following R11 (PNUMBER, PNAME) R12 (SSN, PNUMBER, HOURS) Assume we have the following 5 records stored in these tables. SSN PNUMBER PNAME HOURS 100 1000 Hadoop 50 220 1200 CRM 200 280 1000 Hadoop 40 300 1500 Java 100 120 1000 Hadoop 120 PNUMBER PNAME Hadoop CRM Java 1000 1200 1500 2 NF SSN PNUMBER 100 1000 220 280 300 120 1200 1000 1500 1000 HOURS 50 200 40 100 120