1. Introduction
  • 1.1 Product Overview
    • This project is to create a web-based system for inputting data for a sports league over a wide range of sports. Not only should this system be able to store different leagues (per sport), teams in the leagues, and players on the teams, but it should also store scheduling information (per sport), like weeks, days in a week, games in a day, teams playing in the games, game time, game location, etc. Even more detailed, the system should allow for individual stats to be kept track of and scores to be submitted for games and all of that to be kept track of in the database. The web-based system should also present the information in an aesthetically pleasing way for anyone to view. To do this, the system will most likely use but is not limited to using HTML, Javascript, jQuery, PHP, and XML.

  • 1.2 Human Resources
    • The people that are going to (and currently) use this website are the students and faculty of MVNU. They will all use the viewing capabilities of the website, so they’ll be able to see when games are, who’s playing who, what the standings of the different leagues are, etc. As far as using the website to actually input data, just the MVNU intramural staff will be using that interface.

  • 1.3 Business Context Not applicable.
2. User Requirements
  • 2.1 User Objectives Users would like to be able to use this site to change the data in the database without needing to have any experience with programming or working with code at all, so the interface should be user friendly and should be completely web-based.
    • ěThe system shall provide an interface for editing sports leagues and schedules. This includes adding, editing, and deleting capabilities for weeks, days, games, leagues, teams, and players.
    • ěThe system shall have a database to store all league and schedule information, including team and individual stats.
    • ěThe system shall have interfaces for viewing schedules, leagues, and individual stats.
    • ěThe system shall have interfaces for viewing upcoming events, intramural staff information, and the intramural calendar.
    • ěThe system shall have a database to store upcoming events and the intramural staff information.

  • 2.2 Similar System Information
    • This product is a stand-alone product.

  • 2.3 User Characteristics
    • The user community will only be able to use basic web site navigation and input straight forward forms in web sites.

  • 2.4 User Problem Statement
    • The user’s problem is that currently there isn’t really a good way for information regarding intramurals to be made available for everyone to see in a consistent way. There were attempts made to create an area on the MVNU SGA website to show the intramural schedules, standings, and stats, but the amount of work needed to keep up the information was very taxing because the HTML had to be changed and then updated and the stats had to be calculated by hand and stored in files that weren’t used by the site itself.
3. Functional Requirements

I. Data Input

  • Description - The system should allow users to input data and store that data in a database.
  • Inputs - The input data should be simple forms and it a keyboard and mouse would be used to input it.
  • Outputs - The data produced would be the forms that are stored in the database.
  • Criticality - This is very important because if the website doesn’t allow for input, then people with no experience with databases would have to go directly into the database and input the data manually.
  • Technical issues - The code used to put the data in the database will need to be tailor-made for this data, so everything regarding how the data is represented will need to be determined before this system is created.
  • Risks - If this requirement isn’t met, then if the intramural staff doesn’t have someone who can manually input data into a database then the website will be pointless because it won’t have any data in it. If the staff does, it will still require a lot of time and maintenance to input data into the database manually and it would be easy to make mistakes while inputting data.
  • Dependencies with other requirements - This is dependent on a working database and a user-friendly user-interface.
II. Working Database
  • Description - There needs to be a database that stores all of the information for the website.
  • Inputs - The inputs are forms sent from the website to the database.
  • Outputs - The output is data from the database.
  • Criticality - Extremely important. Without a database, no information can be stored so everything would need to be hardcoded into the HTML.
  • Technical issues - Trying to figure out how to normalize all of the data.
  • Risks - Without a database, everything will have to be hardcoded, so the problem of a high maintenance website won’t be fixed.
  • Dependencies with other requirements - This is dependent on a working user-interface for data entry.
III. User Interface for Data Entry
  • Description - There needs to be a user interface designed so that anyone can input data into the database.
  • Inputs - Inputs would just be HTML, JS and CSS to format the environment.
  • Outputs - The output would be what the user sees on the monitor.
  • Criticality - Pretty important, without the user interface it might be difficult to know how to input the data.
  • Risks - A bad user interface wouldn’t really fix the problem of difficulty entering and updating data.
  • Dependencies with other requirements - This is dependent on the database because it needs to show the most current data stored in the database.
IV. User Interface for Data Viewing
  • Description - There needs to be a user interface designed so that anyone can view the data in the database in a way that’s easily understandable.
  • Inputs - Inputs would just be HTML, JS and CSS to format the environment.
  • Outputs - The output would be what the user sees on the monitor.
  • Criticality - Very important, this is the whole point of the system. If no one could see the data, there would be no point in having it in the first place.
  • Risks - A bad user interface would make it hard to require people to rely on the website to find out information regarding intramurals.
  • Dependencies with other requirements - This is dependent on the database because it needs to show the most current data stored in the database.
4. Interface Requirements
  • 4.1 User Interfaces - The user interface is just a webpage.
    • 4.1.1 GUI
    • 4.1.2 CLI - Not applicable.
    • 4.1.3 API - Not applicable.
    • 4.1.4 Diagnostics - Not applicable.

  • 4.2 Hardware Interfaces
    • A personal computer
    • A mouse
    • A keyboard.

  • 4.3 Communications Interfaces
    • The computer has to be connected to the internet.

  • 4.4 Software Interfaces
    • The computer needs to have a current version of one of the following web browsers.
      • Safari
      • Firefox
      • Google Chrome
      • Internet Explorer
5. Non-Functional Requirements
  • 5.1 Hardware Constraints
    • Personal computers.

  • 5.2 Performance Requirements
    • 1 GB of memory and an average bandwidth.

  • 5.3 System Environment Constraints
    • Not applicable.

  • 5.4 Security Requirements
    • The database should not only be available to intramural staff.
    • The editing area of the website should only be accessible by intramural staff members.
    • The usernames and passwords should only be accessible by intramural staff members.

  • 5.5 Reliability
    • The website shouldn’t crash.

  • 5.6 Maintainability
    • The editing area should be able to be used by anyone who is familiar with entering data.

  • 5.7 Portability
    • The website and database are both located in the same directory, so to move the site to another server, all you would have to do is zip the directory everything is in and move it all to the new server.

  • 5.8 Extensibility
    • Cannot be used with web browsers that aren’t specified in 4.4.

  • 5.9 Development Process Constraints
    • Apache server to host the website: allows HTML embedded PHP and SQL databases
    • PHP: easy-to-use server-side language
    • HTML: current standard in webpage-formatting
    • CSS: current standard in HTML styling
    • JS: easy-to-use client-side language.
    • JQUERY: easy-to-use JS library that makes the XHTML structure easy to manipulate
    • AJAX: easy way to call PHP files and an easy way to request XML documents
    • XML: easy way to store data
6. System Models:

  • Intramural Database (XML)
    • year: PK id, title
    • weekday (child of year entity): PK title
    • month (child of year entity): PK title
    • season (child of year): PK id, title
    • sport (child of season): PK id, title, scoring_unit
    • stat (child of sport): PK id, title, calculation
    • court (child of sport): PK title
    • league (child of sport): PK id, title
    • week (child of sport): PK id, title
    • team (child of league): PK id, title, wins, losses, points_for, points_against
    • player (child of team): PK id, first_name, last_name, athlete, gender, paid
    • day (child of week): PK id, FK title, FK month, day
    • game (child of day): PK id, FK team1_id, FK team2_id, team1_score, team2_score, FK court, time, ref

7. Operational Scenarios

Someone views the intramural site:

  1. The client requests the webpage.
  2. The server runs the PHP code on the webpage and then sends the resulting HTML, JS and CSS to the client.
  3. Client uses the CSS to format the HTML in the web browser.
  4. Webpage uses the JS to run client-side operations.
  5. Client makes an AJAX call to get the XML file that stores the database and parses it.
  6. All pages that require the database can be created using the database that has been parsed on the client side.
Someone edits the data stored on the database from the website.
  1. The user clicks the “Submit” button (or equivalent).
  2. The data needed to update the database is sent to the server using an AJAX call to a specific PHP file.
  3. The PHP file is ran and the database is updated and saved.
  4. The response text from the PHP file is sent back to the client.
  5. The client makes and AJAX call to receive the XML database and reparses it so that the database on the client is up to date.
  6. The information in the HTML is refreshed to reflect the change in the database.
Topic attachments
I Attachment Action Size Date Who Comment
Docxdocx Software_Requirements_Specification.docx manage 125.7 K 2011-12-09 - 16:26 MarcusHartzler Software Requirements Specification
Topic revision: r4 - 2012-05-16 - MarcusHartzler
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback