gitgotgo1 / sem Goto Github PK
View Code? Open in Web Editor NEWRepository of GitGotGot Java application using SQL to output reports
License: Apache License 2.0
Repository of GitGotGot Java application using SQL to output reports
License: Apache License 2.0
As a user I want to be able to see the top number of populated capital cities in the world where the number is specified by me
As a user I want to be able to see the population of any city specified by me
We are currently missing templates for feature requests and bug tracking.
As a user I want to be able to see the population of the world
As a user I want to be able to see all the countries in a region organised by population from largest to smallest
As a user I want to be able to see the top number of countries in a region where the number is specified by me
As our project is to be worked on by several members of the team we need to setup our project to the following requirements:
As a team we need to define our Code of Conduct to set out our plan and responsibilities going forwards as a team.
As a user I want to be able to see the population of any country specified by me
As a user I want to be able to see all the cities in a region organised by population from largest to smallest
As a user I want to be able to see the name, continent, region, population and capital of any country specified by me
As a user I want to be able to see the top number of populated capital cities in a region where the number is specified by me
As a user I want to be able to see all the cities in a country organised by population from largest to smallest
As a user I want to be able to see the number of people who speak Chinese, English, Hindi, Spanish and Arabic from the largest number of speakers to the smallest numbers of speakers. I also want to be able to see what percentage of the world's population this number of speakers is for each language.
As a user I want to be able to see the top number of most populated countries in the world where the number is specified by me.
This ticket contains all information required of our team to complete our project. each of the items in this ticket will eventually be broken down into workable tickets for each of us with user stories, use cases, and work estimates.
The tickets that will be created based on the information found within this ticket will be done so via ZUBE.io
You will work on the project as a Scrum team. Details on Scrum are provided in Lecture 2, including an FAQ on how to apply Scrum in the module.
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:
Country Reports:
- 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 the world where N is provided by the user.
- The top N populated countries in a region where N is provided by the user.
City Reports:
- 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.
Capital City Reports:
- 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.
Population Reports:
- 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 %).
As a user I want to be able to see all the countries in a continent organised by population from largest to smallest
As a team we need a kanban board in which to reflect the progress of each ticket/task we raise and work on in this project.
As a user I want to be able to see all the capital cities in a continent organised by population from largest to smallest
We could develop a front end interface for the application to run our reports. Ideally we should have this in place before we go ahead and build out each report.
i dont know much about Java applications, i know there's swing framework for GUI - we could use something like this?
As a user I want to be able to see the top number of populated cities in the world where the number is specified by me
As a user I want to be able to see the population of people living in cities, and people not living in cities of each region
As a user I want to be able to see the population of a continent specified by me
We need to create a GitHub project containing a repository for each of us to access and update in branches to meet the requirements of the coursework.
As a user I want to be able to see the population of people living in cities, and people not living in cities of each country
As a user I want to be able to see the population of any region specified by me
As a user I want to be able to see the top number of countries in a continent where the number is specified by me
As a user I want to be able to see the total population of any contient, region and country specified by me. As well as the number and percentage of these people living within cities and the number and percentage of these people not living within cites.
As a user I want to be able to see all the cities in a continent organised by population from largest to smallest
As a user I want to be able to see the top number of populated cities in a continent where the number is specified by me
As a user I want to be able to see the population of people living in cities, and people not living in cities of each continent
As a team we need to create a backlog of tasks and issues to work through as part of this coursework.
As a user I want to be able to see the name, country, district and population of any city specified by me
As a user I want to be able to see the population of any district specified by me
Readme should contain the following badges:
As a user I want to be able to see the top number of populated cities in a country where the number is specified by me
As a user I want to be able to see the top number of populated capital cities in a continent where the number is specified by me
As a user I want to be able to see all the capital cities in the world organised by population from largest to smallest
As a user I want to to be able to see all the countries in the world organised by population from largest to smallest
As a user I want to be able to see the top number of populated cities in a region where the number is specified by me
As a user I want to be able to see all the capital cities in a region organised by population from largest to smallest
As a team producing a java reporting application we require for code review 1 a release v1.0 of our project.
No matter what state the current master repo is in as long as it builds and runs, we need to create it as our first release.
Travis is currently failing on master, this needs looked into and fixed.
Codecov is causing PR's to fail even when they aren't reducing the coverage. It's also causing several warnings in the Travis log due to a missing yml file.
As a user I want to be able to see all the cities in the world organised by population from largest to smallest
As a user I want to be able to see all the cities in a district organised by population from largest to smallest
As a user I want to be able to see the name, country and population of any capital city specified by me
We should have a full deployment pipeline setup for GitHub releases and cloud deployment through google services.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.