Question
The official Nobel Prize website provides information on all previous winners (or laureates) in a JSON file called laureates.json, which is included in the downloadable
The official Nobel Prize website provides information on all previous winners (or "laureates") in a JSON file called laureates.json, which is included in the downloadable files. There is a JSON object for each winner and the top-level structure is one big JSON array of these objects. (a) Import this data into a database called nobel and a collection called laureates on a running MongoDB instance. 5 Marks Once you have imported the data, you can have a quick look at a few documents using the MongoDB extension for VS Code. Note that sometimes the winner is an organisation. They have encoded this fact using three values for the gender field (male, female and org). Also, each laureate has a born and died field. In the case of laureates who are still alive, the died field has the special value "0000-00- 00". (b) Write a query to list the first name and surname of all laureates who were born in Ireland. (Note: The data shows five such winners.) 3 Marks (c) Write a query to list the first name and surname of all laureates who were either born or died in Ireland. (Note: Specifying that the person was either born or died in Ireland includes an additional three winners.) 6 Marks
(d) Write a query to find out how many people have won a Nobel Prize in physics on their own (i.e. not shared) this century. (Note: There has been no such winner.) 6 Marks (e) Write a query to find the firstname, surname and birth date of the youngest living (i.e. died:'0000-00-00') person to have won a Nobel Prize. Also show the prize category and year. (Note: The person in question is Malala Yousafzai, who won the 2014 Peace Prize as a 17-year-old.) 10 Marks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started