Touchline : The Soccer Information System

NETAJI SUBHASH ENGG. COLLEGE

4Th year INFORMATION TECHNOLOGY

Project Members

Gaurav Mukherjee Arpan Das

Gautam Chandra Chanchal Banerjee Krishnendu Dutta

Project Coordinator

• Mr. Parag Guha Thakurta

Introduction Football is played at a professional level all over the world, and millions of

people regularly go to football stadium to follow their favourite team, whilst billions more avidly watch the game on television.

A very large number of people also play football at an amateur level. According to a survey conducted by Fédération Internationale de Football Association (FIFA), football's governing body, published in the spring of 2001, over 240 million people regularly play football in more than 200 countries in every part of the world. Its simple rules and minimal equipment requirements have no doubt aided its spread and growth in popularity.

In many parts of the world football evokes great passions and plays an important role in the life of individual fans, local communities, and even nations; it is therefore the most popular sport in the world. Because of this it is often dubbed the World's Favourite Pastime.

The aim of this project was to use the available database handling software packages to create such a software package which would help any person inquisitive to know anything related to present day football which would help him to get the answer to any question like which teams play in England, France etc., who scored the goals in last weekend’s matches, league statistics, league fixture, match statistics, player information etc and many more like that.

This report presents the designs of our project, which includes the following components:-The abstract of the problem and its possible solution, the problem solving methodology used till the present state of development and the system design (E-R Diagram) developed till date.

Project Overview The problem being dealt with in this project is to design and develop a

software which would allow a user to keep track of the what is going on in the world of football by helping him to get any information regarding the matches played, leagues around the world, team information, player statistics, manager statistics etc. It would also allow a particular single user i.e. the Administrator (which will be password protected) with certain privileges like inserting, deleting and updating data which will not be available with the general user. The general user will be allowed only to enter his query by selecting the options available to him through the graphical user interface and view the information displayed.

The proposed solution to the above mentioned problem includes

designing E-R Diagrams firstly to establish the relations between the tables to be created to hold the data and then designing the graphical user interface through which the user will interact with the system.Next the appropriate codes need to be written which would fetch the required data from the database and process them according to the user’s query to provide the desired information as the output of the system to the user. Certain specific privileges will be granted to the user marked as the administrator o help him to enter, delete and update data as and when required.

Software Used

o Oracle 9i o Microsoft Visual Basic 6

Description of the software components of the proposed system and their

interaction• The system opens with a welcome screen designed for the user

(general user or administrator) to log on to the system. Next according to the logged on user’s status (i.e. either general user or administrator) screens open which ask the user to pick their choice of what kind of information they require and then follow the next instructions to specify their requirements and finally submit the query which would be next processed .Up to this the user interfaces will be designed using Visual Basic. The processing of data will be done by the query processor of the database package i.e. Oracle which stores the data at the backend.

• If the user is logged on to the system as administrator, then along with all features available to the general user, options will be available to him specially which would open user interfaces designed with Visual Basic to enter, delete and update data into the database which is implemented using Oracle.

Sample Home Page

Sample Administrator Page

Sample Search Page

Sample Edit Page

E-R Diagram

THANK YOU…