Need research paper for attachment.

The main mission of the project is to design a

computerized database system that

will manage bookings for hostel for College. This will replace the current manual

system that involves booking through manual process requiring the student to be

presented at the time of booking. The new system will be exp

ected to;

a)

Allow online booking

b)

Reduce the time taken to book a hostel

c)

To ensure that the first

-

come

-

first serve policy is applied effectively

d)

To reduce the redundancy of data

e)

Computerize the inventory of hostels

f)

Enable easy querying of unallocated beds

A

student booking needs first to present a bank slip to the accounts office to confirm

payment of fees and then given a receipt of fees payment. Then the student

proceeds to the accommodation department office and presents the receipt to the

house keeper whe

re the booking is allowed if the student at least has paid the

tuition fee.

The beds information are pre

-

filled first in the formation of the file in order to avoid

duplicates. Then when a student books, the bed booked is identified and ticked.

Then the details of the student is entered across the row of the bed.

Booking is usual

ly done before the beginning of the semester. When the student

comes to start a new semester, he or she goes to the accommodation office to be

allocated a mattress and a hostel key. This is viable only when the student has

completed fees with accommodation

fee inclusive.

There exists an opportunity of adding an inventory of hostels defaults such as

broken beds, power switches and lost keys among others which may prompt the

house keeper to effect the repairing of the default before allocating the hostels.

Al

so there exists an opportunity to introduce an online booking systems where the

students can change their booking status online through login procedures.

Tasks may be distributed easily to the finance department. Instead of the students

carrying the fees r

eceipt to the housekeeper after attending to the finance office,

there should be a file that records all the students who have paid fees and are

residents. This file should be instead taken to the accommodation office as a

reference of the students requiri

ng accommodation.

The main mission of the project is to design a computerized database system that

will manage bookings for hostel for College. This will replace the current manual

system that involves booking through manual process requiring the student to be

presented at the time of booking. The new system will be expected to;

a) Allow online booking

b) Reduce the time taken to book a hostel

c) To ensure that the first-come-first serve policy is applied effectively

d) To reduce the redundancy of data

e) Computerize the inventory of hostels

f) Enable easy querying of unallocated beds

A student booking needs first to present a bank slip to the accounts office to confirm

payment of fees and then given a receipt of fees payment. Then the student

proceeds to the accommodation department office and presents the receipt to the

house keeper where the booking is allowed if the student at least has paid the

tuition fee.

The beds information are pre-filled first in the formation of the file in order to avoid

duplicates. Then when a student books, the bed booked is identified and ticked.

Then the details of the student is entered across the row of the bed.

Booking is usually done before the beginning of the semester. When the student

comes to start a new semester, he or she goes to the accommodation office to be

allocated a mattress and a hostel key. This is viable only when the student has

completed fees with accommodation fee inclusive.

There exists an opportunity of adding an inventory of hostels defaults such as

broken beds, power switches and lost keys among others which may prompt the

house keeper to effect the repairing of the default before allocating the hostels.

Also there exists an opportunity to introduce an online booking systems where the

students can change their booking status online through login procedures.

Tasks may be distributed easily to the finance department. Instead of the students

carrying the fees receipt to the housekeeper after attending to the finance office,

there should be a file that records all the students who have paid fees and are

residents. This file should be instead taken to the accommodation office as a

reference of the students requiring accommodation.