Topics: Database normalization, Transport, Time Pages: 9 (697 words) Published: March 21, 2015

A Case Study
Presented to
The Faculty of STI Global City

In Partial Fulfillment
Of the Requirements for the
Theory of Database


Danizon Montallana
Miyelcen Malou Dabu
Ely Ynson

Mr. Michael Pinero & Ms. Kristine Kay Dalere
Project Advisers

October 21, 2014

Phase 1 – Project proposal

1.1 Background of the study
In 2004, Christian Palermo started a taxi company in Ecoville, Ayala. A business that began with a few taxis grew to a fleet of 10 by 2007. Huelar-Palermo Transport Service is located nowadays in Paranaque. The company currently has a fleet of almost 50 vehicles. Palermo is privately held and is operated by his mother, Mrs. Palermo. Close, personal attention, care and involvement make for effective management and the retention of key personnel, resulting in excellent customer service. Palermo serves over 200 customers per day. Many citizens have expressed appreciation for such efficient and dependable transportation services. Palermo’s vision is “Driven for Excellence.” This ideal is carried by all Palermo team members to guide them in the provision of excellent customer service. Palermo’s company mission is to exceed our customers’ needs by providing professional, courteous ground transportation solutions, to create superior business opportunities for our drivers, and to develop an ideal working environment for our employees.

1.2 Project Business Rules
Each day the operator schedules a driver week days. The operator will call or txt the driver if he is available for conformation. Lacking of helper Palermo himself (the operator) checks the vehicle before the trip. Checking the vehicle eats a lot of time starting from 5 am he the operator needs to haste the checking. After that Palermo will give a certain amount of money for the gas. Then the driver is good to go for the 12 hrs work time. After the drivers claim their vehicle for the duty, the operator needs to check the past records. It's hard because he will scan all over the place. Because of manual archiving, almost of the time, he will fail to finish all.

1.2 Statement of the Problem
1.2.1 General Problem
How to design and develop a computerized system that will hasten the process and reduce efforts consumed in monitoring of Huelar Palermo Transport Service. 1.2.2 Specific Problems
By the manual recording, Huelar-Palermo Transport Service encounters many problems such as: Manual archiving
Record loss and data redundancy
Monitoring Large-scale expenses

1.3 Statement of Objectives
1.3.1 General Objectives
The study aimed to design and develop a computerized system that will hasten the process and reduce efforts consumed in monitoring of Huelar Palermo Transport Service. 1.3.2 Specific Objectives
To give an accurate status of the vehicle.
To eliminate record loss and data redundancy.
To track Maintenance, Expenses and Accidental.

1.4 Significance of the Study
The reason why this study is significant can be explained from three aspects;  To the Admin, this study will help the Huelar-Palermo Transport Service to improve their current present use of monitoring by making an integrated system that will help them to make the process more sufficient and less time consuming. This system will also help to satisfy the Admin needs by using the propose system in an easy and accessible way. To the student, this study will help the student to practice the skills in making an integrated information system that will help the Huelar-Palermo Transport Service to make their job much easy. To the future researchers, this study will give them idea on how the monitoring system works. Also, more of the case study are discussing payroll and inventory system. 1.5 Scope and Limitation

The system can Track Large-Scale Expenses, monitor Components and Status of the Vehicle, and can Monitor...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • documentation Research Paper
  • Documentation Research Paper
  • Essay about Documentation
  • Essay about documentation
  • Documentation Essay
  • documentation Essay
  • Documentation Essay
  • Documentation Essay

Become a StudyMode Member

Sign Up - It's Free