awiswasi / whoisyourdatabase Goto Github PK

Story 2:  

As a potential visitor I would like to see a list of all the teams sorted by team name and stadium name so that I can locate specific team information more quickly.

Point 2 and 3 

Description:

All baseball teams and stadiums are listed, with sort options for stadium features

Sprint Assignment

Programmers

Prioritizing

• 2 points

List of Assumptions

• Basic UI window set up

• Baseball stadium database loaded

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The website created by doxygen will have a full description of all data and functions, and will have grough that shows the relations between classes. (Doxygen)

• Database is successfully loaded into a readable table

• Table can be sorted by all values

• Allow for option to view total of a selection

Tasks

• Create table of database

• Ensure sorting is functional

Tests

• Ensure sorting is functional for all values, especially numeric :)

• Table of database shows all teams in database

• Table of database displays data correctly

Story 1:  

As a baseball enthusiast I would like to see all of my favorite baseball team's information so that I can see how cool they are.

Point 1 on direction 

Description:

Selecting a baseball team will display the team and stadium information.

Sprint Assignment

• Sprint 1

Programmers

• Dylan

Prioritizing

 ~ 1 point base line :D

List of Assumptions

• Basic UI window set up

• Baseball team database loaded

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The website created by doxygen will have a full description of all data and functions, and will have grough that shows the relations between classes. (Doxygen)

• User is able to select a baseball team and view corresponding stadium data including: stadium name, seating capacity, location, playing surface, league, date opened, distance to center field, ballpark typology, and roof type.

Tasks

• Create display for information relating to individual team and stadium including stadium name, seating capacity, location, playing surface, league, date opened, distance to center field, ballpark typology, and roof type

• Create widget to allow for baseball team selection

Tests

• First/last team load correctly

• Correct information is displayed for each team

• User is unable to select invalid team

Story 5:  

As a baseball fan who has wasted far too many tickets, I would like to have a list of open roof types by team names so that I can better choose a team to root for. 

Description:

The user can view a list of stadiums and their teams sorted by open roof types.

Sprint Assignment

Programmers

• Austin Simpson

Prioritizing

• 2 story points

List of Assumptions

• Database is filled with needed info.

• Function to display a list of teams and stadiums.

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The user is able to choose to sort the list of stadiums (and their teams) by roof type.

Tasks

• Create a function that is able to sort the list of stadiums and their teams by roof type.

Tests

• Use the display function to show the list and check the list to ensure that the order is correct.

Story 9:  

As a student, I would like to display a list of the National League team names and their stadiums sorted by stadium name and park typology.

5. Determine the minimum spanning tree (MST) connecting all the MLB stadiums using Prim's or Kruskal's algorithm. Display the associated mileage.

6. Perform a DFS starting at Oracle Park (San Francisco Giants). If there is a choice, always choose the shortest distance. Display the associated mileage.

7. Perform a BFS starting at Target Field (Minnesota Twins). If there is a choice, always choose the shortest distance. Display the associated mileage.

-> ?

Description:

The user can display the National League teams sorted by their corresponding stadium name and park typology.

Sprint Assignment

Programmers

• Awf Wiswasi

Prioritizing

List of Assumptions

• Database is filled with needed info.

• Function to sort the National League teams by stadium name.

• Function to sort the National League teams by park typology.

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The website created by doxygen will have a full description of all data and functions, and will have grough that shows the relations between classes. (Doxygen)

• An admin can select the admin button on the main menu and must input a username and password to access the admin functionality 

• An admin page has been created with the buttons "Edit colleges" and "Edit souvenirs" 

• An admin can add a souvenir in the edit souvenirs page 

• An admin can delete a souvenir in the edit souvenirs page

Tasks

• Create a function that lets the user display National League teams by stadium name.

• Create a function that lets the user display National League teams by park typology.

Tests

• Use the display function to show the National League teams sorted by stadium name and by park typology to ensure that the user can display them either way.

Story 14:  

As an admin, I would like to have a login page so that I can use the admin functions.

Point 1 on direction 

Description:

Selecting a baseball team will display the team and stadium information.

Sprint Assignment

• Sprint 1

Programmers

• Dylan

Prioritizing

 ~ 1 point base line :D

List of Assumptions

• Basic UI window set up

• Baseball team database loaded

Definition of Done

• Login screen allows user to access admin functions.

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The website created by doxygen will have a full description of all data and functions, and will have grough that shows the relations between classes. (Doxygen)

• Admins can access to login page where they can enter a username and password to gain access to admin functions.

Tasks

• Create display for login screen.

• Create widget to allow for baseball team selection

Tests

• First/last team load correctly

• Correct information is displayed for each team

• User is unable to select invalid team

Story 3:  

As a potential visitor, I would like to filter all teams/stadiums by their league so that I can find specific teams to my interests.

Description:

The user can view a list of teams/stadiums sorted by American league/National league.

Sprint Assignment

Programmers

• Dylan

Prioritizing

• 3 story points

List of Assumptions

• Basic UI window set up

• Baseball stadium database loaded

• Table display is done

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The website created by doxygen will have a full description of all data and functions, and will have grough that shows the relations between classes. (Doxygen)

• Table can be filtered using:

• Team league (American/National)

• Roof type

• "Display only the stadium(s) and corresponding team name(s) 

• "that has the greatest distance to center field."

• "that has the smallest distance to center field."

• A button has been created so that a student can select  to go to the 1 closest universities 

• A recursive function has been created that selects a series of universities that are closest to one another. 

• A plan is displayed.

Tasks

• Create filtering options

• Create "View Total" option for a given value in selection

Tests

• Filter options remove correct teams for temporary display

• "View Total" options display correct totals for filtered and unfiltered data

Story 1:  

As a baseball enthusiast I would like to see all of my favorite baseball team's information so that I can see how cool they are.

Point 1 on direction 

Description:

Selecting a baseball team will display the team and stadium information.

Sprint Assignment

• Sprint 1

Programmers

• Dylan

Prioritizing

 ~ 1 point base line :D

List of Assumptions

• Basic UI window set up

• Baseball team database loaded

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The website created by doxygen will have a full description of all data and functions, and will have grough that shows the relations between classes. (Doxygen)

• Admin users will have the ability to change the prices of the traditional souvenirs

• Admin users will have the ability to add new traditional souvenirs

• Admin users will have the ability to delete traditional souvenirs

Tasks

• Create display for information relating to individual team and stadium including stadium name, seating capacity, location, playing surface, league, date opened, distance to center field, ballpark typology, and roof type

• Create widget to allow for baseball team selection

Tests

• First/last team load correctly

• Correct information is displayed for each team

• User is unable to select invalid team

Description:
Admin users will have the ability to do the following:
a. change the prices of the traditional souvenirs
b. add new traditional souvenirs
c. delete traditional souvenirs

Story 6:  

As a history buff, I would like to see a list of stadiums and their corresponding team names in chronological order so that I can feel better about the world. 

Description:

The user can view a list of stadiums and their teams sorted from oldest to newest.

Sprint Assignment

Programmers

• Austin Simpson

Prioritizing

• 2 story points

List of Assumptions

• Database is filled with needed info.

• Function to display a list of teams and stadiums.

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The user is able to choose to sort the list of stadiums (and their teams) in chronological order.

Tasks

• Create a function that is able to sort the list of stadiums and their teams from oldest to newest.

Tests

• Use the display function to show the list and check the list to ensure that the order is correct.

Story 7:  

As an event coordinator, I would like to see a list of stadiums and their corresponding team names sorted by seat capacity so that I can better plan my events.  

Description:

The user can display a list of stadiums and their team names, sorted by seat capacity.

Sprint Assignment

Programmers

• Awf Wiswasi

Prioritizing

• 2 story points

List of Assumptions

• Database is filled with needed info.

• Function to display a list of stadiums and their team names.

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The user is able to choose to sort the list of stadiums (and their teams) in chronological order.

Tasks

• Create a function that is able to sort the list of stadiums and their teams by seat capacity, ascending and descending.

Tests

• Use the display function to show the list and check the list to ensure that the order is correct.

Story 4:  

As a civil engineer, I would like to see a list of stadiums and corresponding teams sorted by park typology so that I can better design a different park. 

Description:

The user can view a list of stadiums and their teams sorted by park typology.

Sprint Assignment

Programmers

• Austin Simpson

Prioritizing

• Story points 2

List of Assumptions

• Database is filled with needed info.

• Function to display a list of teams and stadiums.

Definition of Done

• Code pushed to the repository that was created by the product manager from different branches. (Github)

• Product manager will check the code and merge to the master branch.(Github) 

• Code commented and documented with doxygen style comments. (Doxygen)

• The user is able to choose to sort the list of stadiums (and their teams) by park typology.

Tasks

• Create a function that is able to sort the list of stadiums and their teams by park typology.

Tests

• Use the display function to show the list and check the list to ensure that the order is correct.