(Solved): 2) Consider the Purchase Details table shown below, with the primary keys underlined (in this exam ...

2) Consider the Purchase Details table shown below, with the primary keys underlined (in this example the primary key is composed of two fields), and the following data: Purchase Details: Customer ID Store ID 1 1 2 3 1 3 1 Competition Miami Marathon 2 Question 2: Is the Purchase Details table in 2NF? Why? 3) Consider the Competition table shown below, with the primary keys underlined (in this example the primary key is composed of two fields), and the following data: Competition: Chicago Marathon City Los Angeles San Francisco Paris Marathon Los Angeles New York Year Winner 2017 Jose Perez Winner's date of birth 2018 Mei Smith 2018 Frank Lang New York Marathon 2019 Joe Masterson 9/3/1999 Question 3: Is the Competition table in 3NF? Why? (and if not, how can you convert it into 3NF?) 1/1/1975 1/4/1983 5/3/1978