A Portable Software Application. With The Centric Focus Of Providing Detailed Reports On Specific Geographical Demographics Provided By An Organisational Database
| ID | Requirement Name | Met Requirement? | Screenshot |
|---|---|---|---|
| 1 | All the countries in the world organised by largest population to smallest. | Yes |  |
| 2 | All the countries in a continent organised by largest population to smallest. | Yes | |
| 3 | All the countries in a region organised by largest population to smallest. | Yes | |
| 4 | The top N populated countries in the world where N is provided by the user. | Yes | |
| 5 | The top N populated countries in a continent where N is provided by the user. | Yes | |
| 6 | The top N populated countries in a region where N is provided by the user. | Yes | |
| 7 | All the cities in the world organised by largest population to smallest. | Yes | |
| 8 | All the cities in a continent organised by largest population to smallest. | Yes | |
| 9 | All the cities in a region organised by largest population to smallest. | Yes | |
| 10 | All the cities in a country organised by largest population to smallest. | Yes | |
| 11 | All the cities in a district organised by largest population to smallest. | Yes | |
| 12 | The top N populated cities in the world where N is provided by the user. | Yes | |
| 13 | The top N populated cities in a continent where N is provided by the user. | Yes | |
| 14 | The top N populated cities in a region where N is provided by the user. | Yes | |
| 15 | The top N populated cities in a country where N is provided by the user. | Yes | |
| 16 | The top N populated cities in a district where N is provided by the user. | Yes | |
| 17 | All the capital cities in the world organised by largest population to smallest. | Yes | |
| 18 | All the capital cities in a continent organised by largest population to smallest. | Yes | |
| 19 | All the capital cities in a region organised by largest to smallest. | Yes | |
| 20 | The top N populated capital cities in the world where N is provided by the user. | Yes | |
| 21 | The top N populated capital cities in a continent where N is provided by the user. | Yes | |
| 22 | The top N populated capital cities in a region where N is provided by the user. | Yes | |
| 23 | The population of people, people living in cities, and people not living in cities in each continent. | No | |
| 24 | The population of people, people living in cities, and people not living in cities in each region. | No | |
| 25 | The population of people, people living in cities, and people not living in cities in each country. | No | |
| 26 | The population of the world. | No | |
| 27 | The population of a continent. | No | |
| 28 | The population of a region. | No | |
| 29 | The population of a country. | No | |
| 30 | The population of a district. | No | |
| 31 | The population of a city. | No | |
| 32 | The number of people who speak x languages from greatest to smallest by percentage of the world population: | No |
22/32 = 69%
To achieve the desired reports, our team will focus on the creating the desired software via the following steps:
- Understanding the SQL database structure and contents.
- Analyzing the report requirements and breaking them down into smaller, manageable tasks.
- Developing a plan for organising and delegating tasks among team members.
- Implementing the report generation functionality and testing it against the requirements.
- Refining and debugging the solution as needed, utilising develop, release, and master branches.
Our project utilises the renowned Gitflow version control workflow consisting of designing our software within three main Github branches: master, develop, and release.
The master branch represents the production-ready code and contains only the latest, stable releases of the software.
The develop branch is where all the new features and bug fixes are added and integrated into the code. This is the main branch for active development and is constantly updated as new changes are made.
The release branch is created from the develop branch and is used to prepare a new release of the software. This branch includes the necessary bug fixes, changes, and testing before the software is finally merged into the master branch and released. Once a release is completed, the release branch is deleted, and the cycle starts over with a new release branch created from the updated develop branch.
The provided SQL database will serve as the foundation for our population reporting system. Our team will take the time to familiarize ourselves with the database structure and contents to ensure that our solution is effective and efficient.
A private discord server has been established for the SCRUM team members to communicate in a focal environment with the necessary security protocols for discussing software architecture in a way which can be truly transparent.
- Java version 11 - to ensure all team members are running a synchronized version compatible with team software and hardware facilities
- MySql - A SQL server which will run the provided SQL database and will be shared amongst the team
- Git - Version Control for the team to contribute to the project collaboratively and on a non-local basis
- GitHub - To host the Git project
- Docker - To run both the SQL server and the Java project in a containerized environment with universally assigned toolkits and dependencies
- Intellij IDEA Community - An Easy to use IDE with streamlined Git Version Control and Java oriented features
Our team is committed to providing a comprehensive, efficient, and effective solution to the population reporting system. With a clear approach, individual contributions, a streamlined Gitflow workflow, a solid foundation in the SQL database, efficient communication, and a well-defined architecture, we are confident in our ability to deliver the desired reports.