LOGICAL AND PHYSICAL DESIGN OF A CYBER CAF
... A cyber café provide opportunity for Internet access. Nairobi has a population of more than 2 million, with less than 200 cyber café’s. ... If the project is set up in a location with high-income group, the amount of traffic on the café will be less because majority of the people will have personal computers at their home. ... The majority of the Internet factor for success of the project is the quality of service provided to the customers, which include customer’s privacy, speed of Internet and the atmosphere in the café. ... video chat facility, or a small snack café along with the Internet service. With more services provided under the same roof, more traffic can be generated in the Internet café. SOCIAL FEASIBILITY The reason why cyber cafes attract a large percentage of customers is due to their easy availability and the cost element. Users who access the web from their offices still find more reason to visit the cyber cafes. The level of conjecture and meeting ground for many Kenyans in the cyber café has risen up tremendously. There are some that sit in cyber cafes and talk to their friends just in the same cyber café enjoying the chatting euphoria now quite synonymous to many browsers. It is the type of touch one gets in a particular cyber café that makes them to stick on to a particular cyber café. Besides the fact that the cheapest places to find, most cyber cafes now open up to late. ... PURPOSE OF THE PROJECT The purpose of the project is to: -Build a project that will assist staff handling the cyber café operations efficiently, fast and accurately. ... OPPORTUNITY The new system have opportunity in the following areas compared with old system: The computerized system should be able to reduce the clerical work by cyber café staff to create and file various reports. ... Cyber café Manager Supervisor, Cashier, Operators Watchman USER REQUIREMENTS. ... OBJECTIVE DESIGN OF THE NEW SYSTEM To build a powerful system package that can can help with cyber cafe management, accounting and billing. ... The system should provide safe and reliable control over cyber café cash collection. ... It should provide most information needed for cyber café business. ... Therefore, to some extent the quality of Internet in a cyber cafe depends on quality service of ISP. ... It is good though to mention that prices will remain a thorny and touchy issue especially so as long as the level of services is determined by one monopoly gateway Jambonet INFORMATION CONSIDERED FOR THE NEW DESIGN Different cyber café operators were interviewed about different aspects which include: Organization -policies -goals -objectives -organization structure User staff -authority relationships -job functions -information requirements -interpersonal relationships Work itself -workflow -methods and procedure -workshedules CYBER CAFÉ KEY FUNCTIONS INPUTS PROCESS OUTPUTS Client requisition --------------------- ----------- Internet service Payment --------------------- --------------- Scanning service I. ... P -------------------- --------------- Fax service Client address --------------------- --------------- Telephone facility Clint list -------------------- ---------------- Printing service Computers -------------------- ---------------- Inventory report ------------- Daily report ------------ Monthly report ------------ Quarterly report ------------ Inventory report ------------ Account report ------------ CD writing DESIGN OF FILE FORMAT/DATA BASE. NO FIELD NAME DATA TYPE SIZE DESCRIPTION 1 Client-name varchar 30 Full name of client 2 Collector varcher 15 Name of person taking delivery of items 3 contact varcher 18 Name of the contact person 4 Email-add Varcher 20 Email address 5 Fax-no Varcher 10 Fax number 6 Invoice-no varcher 15 Unique invoice number issued 7 Jobcard-no Varcher 19 Unique identity allocated to each new job or repair work 8 Labour charge Interger 7 Charges for labour only 9 LPO-number varcher 15 Local purchase order number 10 manufacturer varcher 20 Name of computer maker company 11 Material-cost Interger 7 Charges for parts and consumables 12 Mobile-no Varcher 15 Mobile phone contact person 13 Model-type varcher 15 Model/type description of computer manufacturer 14 Officer varcher 15 Name of personnel in charge 15 Postal-add varcher 50 Post office box number, town or city 16 Service data varcher 30 Data for which the services offered to the customer 17 Receipt-no Interger 8 Payment serial number receipt number 18 Requisition-no Interger 9 Receiving request forms serial number Serial-no varcher 15 Owners/manufacturer unique number Status varcher 200 Current condition of the computer Telephone-no varcher 25 Fixed telephone number and extension if applicable Time-taken Interger 3 Duration spent on the computer Type-of-service Interger 40 The specific kind of service offered Client varcher 20 customers Make-inquiry Varcher 19 Specify the kind of service to be offered Computer-use Varcher 15 Provision of computer use DESIGN ON PROGRAMS/PROCESS DESIGN HARDWARE CONSIDERATION TOOLS REQUIRED FOR THE PROJECT -21 Pentium computer, AMD processor, 32 MB RAM, 100 Mhz -Minimum software configuration: Window ’98, -4 digital leased lines are recommended because of high level of reliability, bandwidth range of 2 Mbps.