dev-ops project

You will work on the project as a Scrum team. Details on Scrum are provided in Unit 01b

You work for an organisation that requires reporting on population information. You have been tasked with designing and implementing a new system to allow easy access to this population information. The organisation has provided you with an SQL database to work from available here.

The organisation has asked for the following reports to be generated:

All the countries in the world organised by largest population to smallest.
All the countries in a continent organised by largest population to smallest.
All the countries in a region organised by largest population to smallest.
The top N populated countries in the world where N is provided by the user.
The top N populated countries in a continent where N is provided by the user.
The top N populated countries in a region where N is provided by the user.
All the cities in the world organised by largest population to smallest.
All the cities in a continent organised by largest population to smallest.
All the cities in a region organised by largest population to smallest.
All the cities in a country organised by largest population to smallest.
All the cities in a district organised by largest population to smallest.
The top N populated cities in the world where N is provided by the user.
The top N populated cities in a continent where N is provided by the user.
The top N populated cities in a region where N is provided by the user.
The top N populated cities in a country where N is provided by the user.
The top N populated cities in a district where N is provided by the user.
All the capital cities in the world organised by largest population to smallest.
All the capital cities in a continent organised by largest population to smallest.
All the capital cities in a region organised by largest to smallest.
The top N populated capital cities in the world where N is provided by the user.
The top N populated capital cities in a continent where N is provided by the user.
The top N populated capital cities in a region where N is provided by the user.
The population of people, people living in cities, and people not living in cities in each continent.
The population of people, people living in cities, and people not living in cities in each region.
The population of people, people living in cities, and people not living in cities in each country.
Additionally, the following information should be accessible to the organisation:

The population of the world.
The population of a continent.
The population of a region.
The population of a country.
The population of a district.
The population of a city.
Finally, the organisation has asked if it is possible to provide the number of people who speak the following the following languages from greatest number to smallest, including the percentage of the world population:

Chinese.
English.
Hindi.
Spanish.
Arabic.
Country Report
A country report requires the following columns:

Code.
Name.
Continent.
Region.
Population.
Capital.
City Report
A city report requires the following columns:

Name.
Country.
District.
Population.
Capital City Report
A capital city report requires the following columns:

Name.
Country.
Population.
Population Report
For the population reports, the following information is requested:

The name of the continent/region/country.
The total population of the continent/region/country.
The total population of the continent/region/country living in cities (including a %).
The total population of the continent/region/country not living in cities (including a %).
Group Submission
The coursework must be delivered by a group. The aim of the module is to assess your ability to work as a team to deliver a product. Therefore, the majority of your coursework grade will be based on your team's ability to work together using the methods defined in the module.

The submission is assessed at two assessment points. Your submission is delivered via your GitHub repository which should also be submitted to Moodle.

Individual Assessment
Individual contributions to the team will be assessed by your peers and the module teaching team based on contributions towards each code review, and via the metrics gathered from tools such as GitHub. Individual contributions will lead to a scaling of the overall coursework grade if the module team have evidence that illustrates a lack of contribution to the team deliverable.

Groups must maintain a spreadsheet detailing individual team members contribution at each of the assessment points
We wish to determine the individual contribution to the team project. To do this, the team have to submit a single spreadsheet to Moodle defining the agreed contribution of each team member to the individual delivery points. This should be submitted in percentages with the total sum of individual contributions adding up to 100% at each point of assessment. For example: