Consider the following database which keeps track of information about the Nobel Prize winners since 1900:

Year Category Winners last name Winners first name Birthdate Nationality

2010 Physics Novoselov Konstantin 08/23/1974 Russian

2010 Literature Vargas Llosa Mario 03/28/1936 Peruvian

2009 Medicine Edwards Robert 09/27/1925 English

We will assume that there can only be one winner per category every year (this is not always the case in reality, but it will do for our purpose here). However, a given candidate may win more than one prize in any year or several years (an example of this was Marie Curie).

a. Identify the candidate key(s) and primary key.

b. Draw the dependency diagram and identify the partial and transitive dependencies (if applicable).

Thanks!