This is group 20's coursework submission for the SET08103 course at Edinburgh Napier University
- Docker
- Docker Compose
- Maven 4.0.0
- JDK 11.0.2
mvn install -DskipTests=true
java -jar target/SET08103-G20.jar {ip address}
Where {ip address} is the ip address of the SQL server you wish to connect to.
32 requirements of 32 have been implemented, which is 100%.
| ID | Name | Met | Screenshot |
|---|---|---|---|
| 1 | All the countries in the world organised by largest population to smallest. | Yes | Link |
| 2 | All the countries in a continent organised by largest population to smallest. | Yes | Link |
| 3 | All the countries in a region organised by largest population to smallest. | Yes | Link |
| 4 | The top N populated countries in the world where N is provided by the user. |
Yes | Link |
| 5 | The top N populated countries in a continent where N is provided by the user. |
Yes | Link |
| 6 | The top N populated countries in a region where N is provided by the user. |
Yes | Link |
| 7 | All the cities in the world organised by largest population to smallest. | Yes | Link |
| 8 | All the cities in a continent organised by largest population to smallest. | Yes | Link |
| 9 | All the cities in a region organised by largest population to smallest. | Yes | Link |
| 10 | All the cities in a country organised by largest population to smallest. | Yes | Link |
| 11 | All the cities in a district organised by largest population to smallest. | Yes | Link |
| 12 | The top N populated cities in the world where N is provided by the user. |
Yes | Link |
| 13 | The top N populated cities in a continent where N is provided by the user. |
Yes | Link |
| 14 | The top N populated cities in a region where N is provided by the user. |
Yes | Link |
| 15 | The top N populated cities in a country where N is provided by the user. |
Yes | Link |
| 16 | The top N populated cities in a district where N is provided by the user. |
Yes | Link |
| 17 | All the capital cities in the world organised by largest population to smallest. | Yes | Link |
| 18 | All the capital cities in a continent organised by largest population to smallest. | Yes | Link |
| 19 | All the capital cities in a region organised by largest to smallest. | Yes | Link |
| 20 | The top N populated capital cities in the world where N is provided by the user. |
Yes | Link |
| 21 | The top N populated capital cities in a continent where N is provided by the user. |
Yes | Link |
| 22 | The top N populated capital cities in a region where N is provided by the user. |
Yes | Link |
| 23 | The population of people, people living in cities, and people not living in cities in each continent. | Yes | Link |
| 24 | The population of people, people living in cities, and people not living in cities in each region. | Yes | Link |
| 25 | The population of people, people living in cities, and people not living in cities in each country. | Yes | Link |
| 26 | The population of the world. | Yes | Link |
| 27 | The population of a continent. | Yes | Link |
| 28 | The population of a region. | Yes | Link |
| 29 | The population of a country. | Yes | Link |
| 30 | The population of a district. | Yes | Link |
| 31 | The population of a city. | Yes | Link |
| 32 | The number of people who speak Chinese, English, Hindi, Spanish or Arabic in the world. | Yes | Link |
| #1 | #2 | #3 | #4 | Final | Avg | |
|---|---|---|---|---|---|---|
| Johann Leonhardt | 43% | 23% | 35% | 33% | 27% | 32.2% |
| Jacob Barrow | 20% | 31% | 25% | 22% | 17% | 23.0% |
| Toby Cook | 15% | 26% | 25% | 20% | 33% | 23.8% |
| Raish Allan | 22% | 20% | 15% | 25% | 23% | 21.0% |