ECU Web Application Project: Competitors, Games, Events, and Reports

This project requires the development of a web application with several interconnected modules. The core functionalities include a login module for admin and event manager users, with specific access permissions. The Games Management module will allow adding, editing, and deleting game information, including details like game code, name, duration, description, and rules. The Competitors Management module will handle competitor data, including personal information, participation in games, and validation rules to ensure data integrity. The Events Management module will facilitate the addition and deletion of event details, including game association, venue, date, time, description, and the recording of event outcomes. Finally, the Reports Management module will provide functionalities to display event information, search event photos, and export results in Word or PDF format. The application must adhere to specified business rules, including data validation, unique constraints, and the use of .Net's Rapid Application Development features. The project emphasizes the importance of database connections, consistent design, and thorough testing.

The system you will build has a number of related modules which are listed below;
1. Login Module
2. Games Management
3. Competitors Management
4. Events Management
5. Reports management
The detailed functionality of each module is provided in the following sections.
1)Login Module
This module will provide login functionality for the two predefined users, namely, Admin
and Score Manager. Admin will be able to access Competitors and Games management
modules, whereas Event manager will be able to access Events and Reports management
modules. Both users will be able to login into the system using username and password,
can perform their required tasks and then log out of the system. You don’t need to
develop add/edit/delete functionality for this module, rather, the UserID, UserName,
UserPassword and UserType will be stored directly in the database.
The main fields that describe a login module include;
1. UserID (1 & 2)
2. UserEmail ([e-mail] & [e-mail])
3. UserPassword (Admin#1 & Event#1 )
4. UserType (0 for Admin, 1 for Event Manager )
Business Rules
 The only valid combination of username and password should allow access to the
system.
 Once logged in, admin should be able to access Competitors and Games
management modules only, whereas Event manager should be able to access
Events and Reports management modules only.
2)Games Management (Add/edit/delete)
This part of the application allows you to add, edit and delete games information from the
database. You need to create records for at least 3 games namely running, cycling and
swimming.
The main fields that describe this module include;
1. Game_ID
2. Game_Code
3. Game_Name
4. Game_DurationInHours
5. Game_Description (Short description about the game)
6. Game_RulesBooklet (PDF or Word Document for upload)
Business Rules
 There can be only one instance of a game in the system
 Game Code must be 7 characters in length and a mixture of 4 uppercase
characters and 3 numerals
 Validation for blank Game_Name, Game_Code, and Game_RulesBooklet

3)Competitors Management (Add/edit/delete)
This part of the application allows the system user to add, edit and delete competitor’s
information from the database. You need to create records for at least 25 competitors.
The main fields that describe this module include;
1. Competitor_ID
2. Competitor_Salutation
3. Competitor_Name
4. Competitor_DoB
5. Competitor_Email
6. Competitor_Description (Short commentary about competitor -100 words)
7. Competitor_Country
8. Competitor_Gender
9. Competitor_ContactNo
10. Competitor_Website (if any)
11. Competitor_Photo
Additionally, each competitor can participate in various games (many-to-many
relationship). Therefore, this module will capture this information in a separate table for
each new competitor added to the database.
1. Game_ID
2. Competitor_ID
Business Rules
 There can only be one instance of a competitor’s email in the table
 Validation required for blank competitor’s name, country, gender, valid email
 A competitor has to participate in at least one game.
4)Events Management (Add/Delete)
This part of the application allows you to add and delete event information.
The main fields that describe this module include;
1. Event_ID
2. Game_ID
3. FeatureEvent
4. EventVenu
5. EventDate
6. EventStartTime (On Web Form, Pre-Populate it using system information)
7. EventEndTime (On Web Form, Pre-Populate it using game duration information)
8. EventDescription (Short description about event – Max 100 words)
9. WorldRecord
This module will also record the outcome of the event i.e.
1. Event_ID
2. Competitor_ID
3. Competitor_Position (1st,2nd,3rd,4th …. )
4. Competitor_Medal (Gold, Silver, Bronze – otherwise No)
Additionally, the following information is also captured for each event in a separate table
1. Photo_ID
2. Event_Photo (Store the path of uploaded image path)

3. Event_PhotoTags (Keywords describing the photo)
4. Event_ID
Business Rules
 There can only be one instance of an event in the table
 At least one photo for the event
 Validation for blank Game_ID, Event_Venue, Event_Description and Event
Details
5)Reports management (Display, Search, Export results)
Once the various sections of the application are developed that allow adding of
competitors, games, and events information, you need to build some reporting functions
that allow system users to;
 Display events information from the database and then tally up the list of
countries and their Gold, Silver and Bronze medals plus their total number of
medals. This list is to be presented in order of most through least medals. Where
two (or more) countries have exactly the same medal count and type of medals
then they have to have the same position number on the ladder (i.e. if they are
both 8th, then both need to have 8 in front of their name) and appear in
alphabetical order. Below the list of medal winning countries, we also want a list
of Athletes who have set a world record (and for what sport)
 Support for search
o Search the events photos and display the results on a web page.
o Search the database for events information and export the results in Word
or PDF format.
Assignment Development:
How you build your application from a logic and presentation perspective is up to you. It
is recommended that you have a Main Menu page with links to each of the sub-sections
listed above, each of which in turn may have their own sub-sections if necessary. As well
as building a functional and validated data processing system, try to use the presentation
and design features available in .Net to build an appealing, easy to navigate web
application. Your task is to exploit the Rapid Application Development features of the
.Net environment to maximum effect – you are not expected to hand-code this
assignment from scratch. You will use hand-coding when needed, usually to help glue
two or more components together or to tweak how a component operates.
Test your site thoroughly to make sure that all database connections and data objects
work correctly, especially across different machines uses different folder locations
(desktop and my documents for instance) to ensure that no fixed-path issues occur.
Consider using screen mockups of what each page will look like before commencing you
coding, and try and keep the overall look and feel consistent. You can try
https://moqups.com/ https://www.youtube.com/watch?v=p38jXuc98qg
Criteria Mark Weighting
1) Manage Competitors, Games, Events and Reporting (add, edit,
delete)

2) Search and display results, Exporting of Results as word/pdf ,
Photos upload and display, Upload PDF/Word document
3) Data Validation against Business Rules (validation on blanks, allowable
values etc)