GROUP 9

Enrique Jingco, Mario Tereso Rosales, Samson Paradela

I. Introduction

The Cebu Schools Athletic Foundation Inc. (CeSAFI) is one of the most anticipated annual sporting events in Cebu City.
CeSAFI is open to both college and high school levels. All local high schools, colleges, and universities are eligible to compete in
various major sporting events which include Basketball, Football (Soccer), and Volleyball. CeSAFI is regularly participated by schools
like the University of San Carlos (USC), University of the Visayas (UV), University of Cebu(UV), University of San Jose - Recoletos
(USJ-R), Don Bosco College (DBC), and many other local schools. This said sporting event provides an environment for the student
athletes of the various schools to showcase their talents and abilities in the various major sporting events.

As far as we know CeSAFI has not yet launched an official website. CeSAFI also has no official database in which they keep
track of all the participating schools, sporting events, players, schedules. To my knowledge, coaches form respective schools and
sports will have to secure a CeSAFI player registration form and submit it before a certain deadline. This makes registration a very
tiresome process. This is the first concern of our project, to make registration automated and online. The main purpose of our project
is the creation of a major CeSAFI database which is capable of registering players, keeping tracks of various organizational records,
and scheduling of events. Through this database, a user will be well informed about what schools or players are participating in
different events, and when and where the games are going to be held. This also helps the different schools to register their players in
different events much faster and organized. This project aims to help CeSAFI in making a big step towards the future of their
organization.

Project Objectives:
1.) To make player registration automated
2.) To keep track and organize organizational records
3.) To make scheduling of games and events automated
4.) To provide user-friendly, accurate, up-to-date, and reliable information for interested people who would like to find out about
CeSAFI related information
II.

1.) Requirement Analysis

a) Corporate Planning Objectives
• Organizational Units
o Registration Department
o Encoding Department
o Records Department

• Organizational Locations
o CeSAFI Admin Office

• Business Functions
o Registration of players
o Registration of Schools
o Scheduling of events
o Result Input
o Awards Input
o Information center for CeSAFI related data

• Entity Types
o Database Administrator
o School Administrator
o Player / User
o Season
o Awards
o Events

• Information Systems
o Result Management
o School Information Update
o Player Information Update
o Event Schedule Update
b) Three Matrix

Business Function to Data Entity Matrix

Information System to Data Entity Matrix

Business Function to Organizational Unit Matrix

c) Gantt Chart
2.) Analysis

a) DFD

Context Diagram
LEVEL 0

LEVEL 1: REGISTRATION
LEVEL 1: UPDATE
LEVEL 2: PLAYER REGISTRATION
LEVEL 2: SCHOOL REGISTRATION
B. Business Rules

Registration Rules:
1. A participant/player/athlete must be a valid student of the participating school.
2. A participant/player/athlete may join an event if he/she has successfully completed the requirements for said event.
3. A participant/player/athlete can only join one (1) event.
4. A school will be considered eligible to participate in an event if the player quota reaches the minimum requirement.

Administrator Rules:
• School Administrator
1. A school must have one (1) school administrator.
2. The school administrator must have one (1) valid account with a valid username and password.
3. The school administrator is the one in charge for all school-player transactions. (Encoding/Editing/Deleting)
• Database Administrator
1. A database administrator must have one (1) valid account with a valid username and password.
2. The database administrator oversees the operation of the whole CESAFI database transactions.

3. Logical Database Design

a.) ERD
Award_ID

Event_Type_Name Rank Game_Result AWARD

Event_Type_ID

Award_Name
Has

EVENT_TYPE Year
GAME

Player_Name
Venue Date

Player_ID
has

Result Year
Age

EVENT SEASON PLAYER Height

Weight
Event_ID
joins
Event_Name
Gender

Team_Name TEAM School Birthday

Status
Team_ID

School_ID No. of Years

School_Name No_of_Plauers
b.) 3NF
4. Physical Database Design

Table Name Player

Description Player information
SQL statement CREATE TABLE Player (Player_ID
varchar(10), F_Name varchar(50),
L_Name varchar(50), M_Name
varchar(50), Gender varchar(6), Birthday
long, Age int, Height int, Weight int, Status
varchar(20), No_year int )
Attributes Data Type Description
Player_ID varchar , not null Uniquely identifies the
player.
F_Name varchar , not null First name of the player.
L_Name varchar , not null Last name of the player.
M_Name varchar , not null Middle name of the player
Gender varchar , not null Gender of the player.
Birthday long int, not null Birthday of the player.
Age Int, not null Age of player
Height Int, not null Height of player
Weight int, not null Weight of player
Status varchar , not null Status of player (active or
inactive)
No_year Int, not null Number of years played in
CESAFI
Table Name Awards
Description List of possible awards a player can attain
SQL statement CREATE TABLE Awards (Award_ID
varchar(10), Award_Name varchar(50),
Year int, Player_ID varchar(10))
Attributes Data Type Description
Award_ID varchar, not null Uniquely identifies the
award.
Award_Name varchar, not null Name of the award.
Year Int, not null The year award was given.
Player_ID varchar, not null Uniquely identifies the
player who has the award.
(Foreign Key)

Table Name Team

Description List of teams from schools participating in
team sporting events
SQL statement CREATE TABLE Team (Team_ID
varchar(10), Team_Name varchar(50),
School_ID varchar(10))
Attributes Data Type Description
Team_ID varchar, not null Uniquely identifies the
team.
Team_Name varchar, not null Name of the team.
School_ID varchar, not null Uniquely identify the team’s
school. (Foreign Key)
Table Name School
Description List of schools participating in CESAFI
SQL statement CREATE TABLE School (School_ID
varchar(10), School_Name varchar(50),
No_of_Players int)
Attributes Data Type Description
School_ID varchar, not null Uniquely identifies the
school.
School_Name varchar, not null Name of the school.
No_of_Players Int, not null Number of registered
players in school.

Table Name Event

Description List of events in CESAFI
SQL statement CREATE TABLE Event (Event_ID
varchar(10), Event_Name varchar(50))
Attributes Data Type Description
Event_ID varchar, not null Uniquely identifies the
event.
Event_Name varchar, not null Name of the event
Table Name Event Type
Description Sub-category of events (e.g. 500 meter
breast stroke)
SQL statement CREATE TABLE Event_Type
(Event_Type_ID varchar(10),
Event_Type_Name varchar(50), Event_ID
varchar(10))
Attributes Data Type Description
Event_Type_ID varchar, not null Uniquely identifies the
event type.
Event_Type_Name varchar, not null Name of the event
Event_ID varchar, not null Uniquely identifies the
events. (Foreign Key)

Table Name Season

Description Identifies the season CESAFI was held.
SQL statement CREATE TABLE Season (Event_ID
varchar(10), Team_ID varchar(10),
Player_ID varchar(10), Result varchar(50),
Season_Year int)
Attributes Data Type Description
Event_ ID varchar, not null Uniquely identifies the
event type. (Foreign Key)
Team_ID varchar, not null Uniquely identifies the
team. (Foreign Key)
Player_ID varchar, not null Uniquely identifies the
events. (Foreign Key)
Result varchar, not null Describes who won, how
many points, and other
result data pertaining an
event.
Season_Year Int, not null Year of the season
Table Name Game
Description Identifies each individual game in CESAFI
SQL statement CREATE TABLE Game (Event_ID
varchar(10), Event_ID varchar(10),
Game_Result varchar(50), Venue
varchar(20), Date varchar(10), Rank int)
Attributes Data Type Description
Event_Type_ID varchar , not null Uniquely identifies the
event type.(Foreign Key)
Player_ID varchar , not null Uniquely identifies the
player.(Foreign Key)
Game_Result varchar , not null Describes who won, how
many points, and other
result data pertaining an
game.
Venue varchar , not null Venue of the game.
Date varchar , not null Date of the game.
Rank Int, null Rank of the player. Initially
null.
5.) Views and Forms

Home
News
Sporting Events
Schools
Calendar
Database Administrator Page
School Administrator Page (USC)
Player Registration / Edit Player Information (Admin, School Admin)
List of Players (Admin, School Admin)
Schedule Events / Edit Scheduled Events (Admin)
List of Events for the month (Admin)