This is package which has chiefly made for direction of a Hotel. The package has been designed with front-end as VB and backend as Oracle. The undertaking Hotel Management manages maintains the records of clients and room in the hotel. The suites have different classs. So there charges and records will be maintained consequently. This package has been made in a user friendly interface, so that normal individuals can add, cancel the entries of clients and manage all the minutess easy.
SYSTEM ANALYSIS
The initial analysis is made by cognizing the user demands. In analysis stage, we have analyzed the
user ‘s demand such as: –
Addition of the record of the client who comes into the hotel, omission of the record when client leaves the hotel, printing and computation of the measure, record of installations available in the hotel, allocation of the suites etc. In this undertaking we have besides analyzed that the merchandise or package should non be really dearly-won but its quality and interface must be attractive.
If any incorrect operation is being performed so the package must raise the operator consequently.
FEASIBILITY STUDY
A feasibleness survey is carried out to choose the best system that must public presentation demand
and its working ability in an organisation. The feasibleness of the system has been done in three types: –
-Technical Feasibility Study
-Economical Feasibility Study
-Behavioral Feasibility Study
TECHANICL FEASIBILITY
Technically we have made feasibleness in maintaining head about the hardware so that the designed package can work swimmingly with maximal efficiency with the hardware.
ECONOMICAL FEASIBILITY
In this we chiefly calculate the cost of proposed system and the cost of client and compare the cost to run into the users cost. The cost of hardware, installation cost, runing and supply costs are considered. The cost of feasibleness is besides considered on this such as wiring, lightning, A.C. etc.
BEHAVIOURAL FEASIBILITY
We have to see the cost of staff which has particular attempts to educate, sell train on new
ways.
SOFTWARE & A ; HARDWARE REQUIREMENTS
There are some package and hardware demands of the package hotel direction system.
Software REQUIREMENTS
-Visual Basic.net as frontend
-Oracle Database as backend
-Windows 7 place Premium
Hardware REQUIREMENTS
-Pentium- 4 processor
-40 & A ; more GB for informations storage
-128 to 512 KB RAM
-Printer for describing and printing
Execution
To implement this undertaking, HOTEL MANEGEMENT will necessitate a ocular BASIC as frontend & A ;
Oracle Database as backend.
SYSTEM DESIGN
In this package we have developed some signifiers. The brief description about them is as follow: –
MDI FORM
This is the chief signifier. It contains following Fieldss: –
Hotel
Customer
Reservation
Room
Search
On traveling the pointer to any of the above Fieldss, drop down bill of fares will be displayed user can snap on any of the options available in them and their several signifiers will open.
Hotel
The chief intent of this signifier is to add a new hotel to the database. For this intent, the user will be required to make full the Hotel Idaho, Hotel Name and their reference. After make fulling all the entries, when we click on the on the saveA button, the record will be added to the database.
Customer
In this signifier, user can add a new client to the records. For this intent, the user will be required to make full the client Idaho, name of the residents, their reference. After make fulling all the entries, when we click on the Submit button, the record will be added to the database.
Reservation
This is the reserve signifier where the user inputs client ‘s reserve inside informations, for illustration: Reservation Id, Customer Id, Hotel Id, Reservation day of the month, Arrival day of the months and so on. The user can choose the type of suites by inputting the room class Idaho from the list box. The charges per twenty-four hours of this room are displayed in the list itself. After make fulling all the entries, when the user chink save button, the records will be added to the database.
Degree centigrades: UsersWindows 7DesktopUntitled.png
Room
This is the room signifier, where the user hunt entire suites in the hotel by the room inside informations like hotel Idaho, room figure and room class Idaho. After make fulling all the entries, when the user chink hunt button, the user will be able to see the types of room by their room inside informations.
Room Category
This is the room class signifier where the user inputs inside informations in the room classs in the hotel by the room inside informations like class Idaho, class name and figure of beds. After make fulling all the entries, when the user chink save button, the user will be able to see the types of room by their room inside informations
Search
This signifier hunt all the database harmonizing the input of the user, If the input is found in the database, so message box “ input found ” and the consequence will be displayed, In the other manus, if the user inputs incorrect input, a monosodium glutamate box displays “ input non found please seek once more ” . And no consequence will be displayed.
Degree centigrades: UsersWindows 7Desktopsearch.png
System Study & A ; Analysis
PRINCIPLES OF SYSTEM ANALYSIS
-Understand the job before you begin to make the analysis theoretical account.
-Develop paradigms that enable a user to understand how human machine interaction will happen.
-Record the beginning of and the ground for every demand.
-Use multiple positions of demands like edifice informations, map and behavioural theoretical accounts.
-Work to extinguish ambiguity.
ENTITY RELATIONSHIP DIAGRAM ( ERD )
Entity-Relationship Diagram
This depicts relationship between informations objects. The property of each information objects noted in the entity- relationship diagram can be described utilizing a information object description. Data flow diagram serves two intents:
-To provide an initiation of how informations are transformed as they move through the system.
-To depict the maps that transformation the information flow.
Datas Objects
A information object is a representation of about any composite information that must be understood by the package. By composite information, we mean something that has a figure of different belongingss or properties. A information object encapsulates informations merely there is no mention within a information object to operations that act on the information.
Properties: Attributes define the belongingss of a information object and take on one of three different features. They can be used to ;
-Name an case of informations object.
-Describe the case
-Make mention to another case in other tabular array.
Relationship
Datas objects are connected to one another in a assortment of different ways. We can specify a set of object relationship braces that define the relevant relationships.
E-R DIAGRAM
Customer
Hotel
Check IN
Room
Information
Room
Room Record
Customer
Hotel
Check OUT
Customer
Room
ROOM PRICE
Hotel
DATA Mold
Data mold defines primary informations objects, composing of each information object, and properties of the object and other objects and between objects and procedures.
Hotel Table
William claude dukenfields
Type
Hotel Id
Varchar2
Hotel Name
Varchar2
Address
Varchar2
City
Varchar2
Telephone No
Number
Number of Stars
Varchar2
Customer Table
William claude dukenfields
Type
Customer Id
Varchar2
First Name
Varchar2
Last Name
Varchar2
Gender
Varchar2
Address
Varchar2
Telephone No
Number
Email Address
Varchar2
Reservation
William claude dukenfields
Type
Reservation Id
Varchar2
Customer Id
Varchar2
Hotel Id
Varchar2
Reservation Date
Date
Arrival Date
Date
Departure Date
Date
Room Category
Varchar2
Status
Varchar2
Entire Cost
Number
Room
Field
Type
Hotel Id
Varchar2
Room Number
Number
Category Id
Varchar2
Room Category
Field
Type
Category Id
Varchar2
Class Name
Varchar2
Number Of Beds
Number
Search
In this map, room, client as user can seek item from the database harmonizing to their hallmark.
Decision
This undertaking have been designed in a great user friendly and mostly supplying attribute interface and tp meet the demand of a Hotel Management System.. The undertaking is working with speedy response and same degree of security is besides maintained. The Oracle database is maintained and frontend with Visual Basic.
In this designing system, I have used an ER Diagrams ; overall this undertaking teaches us the indispensable accomplishment like ;
-Understanding the Oracle database handling and question processing.
-Using system analysis and design techniques like ER diagram and Data mold in planing the system.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
