Answer the following question to analyze the database in the following image:

1) Understand the current database

a. List out all the possible candidate keys in the database

b. Decide a primary key for the database and explain why you choose it among the candidate keys you identified in 4.1a

c. Show the structure of the database using outline notation

2) Understand the dependencies in the database

a. Draw a dependency diagram for the database

b. Is there any partial or transitive dependency? If so, explain it

Country Name Country Code - Year GDP Population 1 Afghanistan 2 Afghanistan 3 Afghanistan 4 Afghanistan 5 Afghanistan 6 Afghanistan 7 Afghanistan 8 Afghanistan 9 Afghanistan 10 Albania 11 Albania 12 Albania 13 Albania 14 Albania 15 Albania 16 Albania 17 Albania 18 Albania 19 Algeria 20 Algeria 21 Algeria 22 Algeria 23 Algeria 24 Algeria 2004 $5, 2005 $6,275,076,016 2006 $7,057,597,615 2007 $9,843,851,009 26,349,243 2008 $10,190,534,63627,032,197 2009 $12,486,950,469 27,708,187 2010 $15,936,784,436 28,397,812 2011 $17,870,159,08229,105,480 2012 $20,496,777,409 29,824,536 2004 $7,464,446,950 2005 $8,376,483,740 2006 $9,132,562,332 2007 $10,704,661,571 2008 $12,968,652,891 2009 $12,118,580,597 2010 $11,858,166,295 2011 $12,959,563,902 2012 $12,648,095,824 2004 $85,324,997,370 33,461,345 2005 $103,198,650,29833,960,903 2006 $117,026,655,31434,507,214 2007 $134,977,867,932 35,097,043 2008 $171,000,162,58135,725,377 2009 $137,211,795,394 36,383,302 24,018,682 24,860,855 25,631,282 285,461,999 3 3,216,197 3,196,130 3,179,573 3,166,222 3,156,608 3,151,185 3,150,143 3,153,883 3,162,083 ALB ALB ALB ALB DZA DZA DZA DZA DZA DZA 2 3