Tabulation System Database Schema and System Features

Tabulation System Database Schema and System Features

Database Schema

Manage Schedule of Activities (activityid, datefrom, date to, activity name, description)

Manage Events (eventid, date, name of event, description)

Manage Contestant (contestantid, name, department, eventid)

Manage Judges (judegeid, judgename, username, password)

Manage Criteria (criteriaid, criterianame, percentage, eventid)

Manage Scores (scoreid, eventid, judgeid, criteriaid, contestandid, score, category, date)

Reports

• Overall Winner for specific event
• Winner per Criteria for specific event

Judge

• Select Events and Login to the System
• Select Contestant
• Display the criteria to be graded
• Submit scores

System Flow

Admin

1. Admin will encode all the events
2. Admin will encode all the contestants
3. Admin will encode all the judges
4. Admin will encode all the judging criteria

Judges

1. The judge will have to select first activity or event before he or she logs on to the system.
2. The system will present the list of candidates for that specific event.
3. After the judge has selected a candidate, the system will present the list of judging criteria for that event.
4. The judge will now rate and save the score.
5. The system will then return to the list of candidates, and will repeat the steps from 3 to 5.

Admin

1. View and print the results/winner for specific event (3^rd, 2^nd, 1^st, grand winner)
2. View and print the results/winner per judging criteria for a specific event (best in gown, best in talent, etc.)

Development Tools:

We can develop the project using the following programming languages:

• Visual Basic and MS Access
• Visual Basic and MySQL
• C# and SQL Server
• PHP, MySQL and Bootstrap
• Web and Mobile version using NodeJS, AngularIonic and Apache Cordova