Download Automation of Banquet Hall Booking System: Module Description and Technologies Used and more Assignments Computer Networks in PDF only on Docsity!
Automation Of Banquet Hall
Consulting System
1. INTRODUCTION
In this project we supposed to make the best, complicated and as simple as possible using with Structure and Modular techniques and menu Oriented Interface. In this project each customer’s activity in computerized way rather than manually which is time consuming. The main aim of entire activity is to automate the process of day to day activities of booking banquet hall for any events, parties etc. and many more. There are some functions that are performed by the system. Check hall availability Login page Hall Booking Record Keeping Function Request for other devices Payment 1.1 Background During the past several decades personnel function has been transformed from a relatively obscure record keeping staff to central and top level management functions. There are many factors that have influenced this transformation like technological advanced professionalism and general recognition of human beings as most important resource. This Banquet Hall Booking System is designed to handle all the primary information required to calculate monthly statement. Separate Database is maintained to handle all the details required to generate the current statements and all activities of booking halls. So this project intends to introduce
more friendliness in the various maintenance and searching of available Banquet Hall in your district for meetings , family functions or any cultural events.. 1.2 Objective The main objective of the entire activity is to automate or updating daily booking of Banquet Hall like book hall , lightening and video recording etc. and also automate the process day to day activities. So we can create a master file which is update the data automatically. This project gives some more features are:- No paperwork Time efficient Cost efficient Automatic data validation User friendly environment Data security and reliability Ease of performance checks.
Payment Policy Cancellation policy Request for other devices Availability of Audio System DJ System availability and cost Lightening availability and charges Video Recording facility Payment Payment detail (online credit card) Sending confirmation e-mail after booking
3. SURVAY OF TECHNOLOGIES:-
The need of today’s software development is competence in a Graphical User Interface (GUI) based Front-end tool, which can connect Relational Database engines. This gives the programmers the opportunity to develop client-server based commercial applications. So we use two platforms Front-end like ASP.Net With C# and Back-end like SQL Server2005.
4. REQUIREMENT AND ANALYSIS
4.1 Problem Definition This section will gives us to automate database hourly or daily, to update all booking available in the database and also manage their availability check each and every time. 4.2 System Analysis The main purpose of conducting system analysis is to study the various processes and to find out its requirements. These may include ways of capturing or processing data, producing information, controlling a business activity or supporting management. The determination of requirements entails studying the existing details about it to found out what these requirements are. System analysis has been conducted with the following objectives in mind:
- Identify the customers’ need.
- Evaluate the system concept for feasibility.
- Perform economic and technical analysis.
- Allocate functions to hardware, software, people, database, and other system elements.
- Establish cost and schedule constraints.
- Create a system definition that forms the foundation for all subsequent engineering work. System Analysis includes requirement analysis. The requirement analysis task is a process of discovery, refinement, modeling, and specification. Requirement analysis allows the software engineer to refine the software allocation and build
Feasibility study includes seven distinct but inter related type of feasibility. These are: Technical feasibility: Focus is on establishing whether the technology needed for the proposed system is available and how this technology can be integrated within the organization. Technologies included are: a. Hardware b. Software c. Application development environment Economic feasibility: It is concerned with the returns or benefits of the organization are likely to derive from investment in the new system. Estimated costs of new system development and operation must be balanced against projected tangible as well as intangible benefits. Operational feasibility: It is an evaluation to determine whether a system is operationally acceptable. Two important dimensions to be accessed are ability and motivation to use the system.
4.3 Cost / Benefits Analysis:
Cost/Benefit analysis is performed to ascertain whether the costs in the system match with the benefits it will provide. The various kinds of costs incurred in the development and implementation of the system include: Hardware Costs:- Cost incurred in purchase of hardware, i.e., computer and its Peripherals. Personnel Costs:- Include the salaries of the EDP staff as well as perks of personnel involved in the development of the system. Facility Costs:- Expenses incurred in the preparation of the physical site. This includes flooring, wiring, lighting, etc. Operating Costs:- Including all the costs associated with the day to day operation of the system. Supply Costs:- Variable costs that increase with increased use of paper, ribbon, risks. Under Cost/Benefit analysis of the “MARKET-I” a software for shares it was analyzed that the firm is ready to do one time investment but doesn’t want high operational expenses. As a result of which the operating cost has been reduced as no user training is needed and only paper and ribbon costs will have to be incurred after regular intervals.
Banquet Hall Booking System Customer Admin Booked Hall update DataBase Administrator
st
Level Data Flow Diagram
**1. 0 Hall Availability Checking
- 1 Login Page
- 3 Cancel Booking
- 2 Banquet Hall Booking
- 4 Transaction Customer Admin** Retrieve availability Check information Database Hall Database Registration Login Registered Data Verify Updating Payment & Sending Confermation
HALL DETAIL Name has District Hall_Code CLIENT REGISTRATION DETAIL Set ADMIN Name Password Admin_Id Register CLIENT LOGIN Login_Id Account_No Client_Id^ Name Occupation Address Login_Id Password AVALIBILITY DETAIL Update Check Available BOOKING DETAIL Date Time Area Hall_Code Hall_Name No of Person Purpose Booking_Id OTHER DEVICES has May request for Audio System DJ Lightining Video Recording TRANSACTION DETAIL Payment Account_No Pan_No Credit Card No Client_Id May Cancel CANCELLATION DETAIL Time Date Booking_Id Send confirmation detail Dob Date/Time Hall_name Hall_code District
5. DATABASE Tables:-
1. BANQUET_HALL_Master:- FIELD NAME
TYPE SIZ
E
DESCRIPTION
Hall_Code Numer ic 20 Primary Key, which is uniquely identify to the hall. Hall_name Varch ar 60 Name of hall Address Varch ar 80 Address of hall. District Varch ar 30 Name Of The District where Hall is situated Rooms Numb er 5 No of rooms in a banquet hall.
2. BOOKING_DETAILS:- FIELD NAME
TYPE SI
ZE
DESCRIPTION
Booking_id Varcha r 20 Primary Key, which is uniquely identify to the booked hall. Hall_Code Numeri c 20 identify to the hall Hall_Name Varcha r 20 Name of the Hall Area Varcha r 30 Hall area name. Time Time 20 0 Particular time of booking Date Date 8 Date of booking No_of_Pers on Numbe r 10 Total person to attend the ceremony Purpose Varcha r 20 Purpose of hall booking
Account_No numbe r 20 Account Number of Customer Date date 10 Date of payment Cust_member_id numeri c 20 identify to the customer.
5. FEEDBACK:- FIELD NAME
TYPE SIZ
E
DESCRIPTION
Cust_memb er_id varch ar 20 Identifies the Member ID of customer. Comp_Nam e varch ar 20 Name of the Company E_mail varch ar 30 E_mail identifies to company Comment varch ar 200 Comments of the Company Date date 8 Date of feedback
