Analysis Of A Hotel Management System

analytic thinking Of A Hotel Management excogitateationThis is package which has mainly made for management of a Hotel. The software has been designed with front-end as VB and backend as Oracle. The project Hotel Management manages maintains the records of customers and live in the hotel. The board have different categories. So there charges and records exit be maintain accordingly. This software has been made in a substance ab drug user friendly interface, so that normal persons stool jibe, delete the entries of customers and handle both the transactions easily. dodge ANALYSISThe initial outline is made by knowing the user requirements. In analysis phase, we have analyzed theusers requirement such as-Addition of the record of the customer who comes into the hotel ,deletion of the record when customer leaves the hotel, printing and t every last(predicate)y of the bill ,record of facilities ready(prenominal) in the hotel ,allotment of the rooms etc. In this project we have also analyzed that the product or software should not be very speak toly but its quality and interface essentialiness be attractive. If any wrong operation is being performed then the software must invoke the operator accordingly.FEASIBILITY STUDYA feasibleness study is carried out to shoot the best system that must execution of instrument requirementand its working ability in an organization. The feasibility of the system has been with with(p) in three types--Technical feasibleness Study-Economical Feasibility Study-Behavioral Feasibility StudyTECHNICAL FEASIBILITYTechnically we have made feasibility in keeping mind about the hardware so that the designed software fag end work smoothly with maximum efficiency with the hardware. economical FEASIBILITYIn this we mainly calculate the cost of proposed system and the cost of customer and compare the cost to learn the users cost. The cost of hardware, facility cost, operational and supply costs are bringed. The cost of feasibility is also considered on this such as wiring, lightning, A.C. etc.BEHAVIOURAL FEASIBILITYWe have to consider the cost of staff which has special efforts to educate, sell train on parvenueways.SOFTWARE HARDWARE REQUIREMENTSThere are some software and hardware requirements of the software hotel management system.SOFTWARE REQUIREMENTS- ocular Basic.net as frontend-Oracle Database as backend-Windows 7 class PremiumHARDWARE REQUIREMENTS-Pentium- 4 processor-40 more GB for info storage-128 to 512 KB RAM-Printer for reporting and printingIMPLEMENTATIONTo weapon this project, HOTEL MANAGEMENT go forth require a visual basic as front end Oracle Database as back end.SYSTEM digitIn this software we have developed some forms. The brief comment about them is as follow-MDI FORMThis is the main form. It contains following field-HotelCustomer booking boardRoom course lookOn moving the cursor to any of the above fields, drop down menus give be displayed user can click on any of the options avail competent in them and their respective forms will open.HotelThe main purpose of this form is to add a new hotel to the entropybase. For this purpose, the user will be required to take up the Hotel id, Hotel Name and their address. After fill up all the entries, when we click on the on the save button, the record will be added to the database.CustomerIn this form, user can add a new customer to the records. For this purpose, the user will be required to fill the customer id, name of the occupants, their address. After filling all the entries, when we click on the Submit button, the record will be added to the database.ReservationThis is the reservation form where the user inputs customers reservation flesh out, for example Reservation Id, Customer Id, Hotel Id, Reservation date, stretch dates and so on. The user can select the type of rooms by inputting the room kinsperson id from the list box. The charges per day of this room are displayed in the list itself. After filling all the entries, when the user click save button, the records will be added to the database.CUsersWindows 7DesktopUntitled.pngRoomThis is the room form, where the user search total rooms in the hotel by the room occurrences manage hotel id, room number and room category id. After filling all the entries, when the user click search button, the user will be able to view the types of room by their room details.Room CategoryThis is the room category form where the user inputs details in the room categories in the hotel by the room details like category id, category name and number of beds. After filling all the entries, when the user click save button, the user will be able to view the types of room by their room detailsSearchThis form search all the database according the input of the user, If the input is found in the database, then message box input found and the result will be displayed, In the other hand, if the user inputs incorrect input, a monosodium glutamate b ox displays input not found please try again. And no result will be displayed.CUsersWindows 7Desktopsearch.pngSystem Study AnalysisPRINCIPLES OF SYSTEM ANALYSIS-Understand the problem before you begin to create the analysis model.-Develop prototypes that enable a user to understand how human machine fundamental interaction will occur.-Record the origin of and the reason for every requirement.-Use multiple views of requirements like create data, function and behavioral models.-Work to eliminate ambiguity.ENTITY RELATIONSHIP DIAGRAM (ERD)Entity-Relationship DiagramThis depicts kind in the midst of data inclinations. The attribute of each data objects noted in the entity- relationship plat can be described using a data object description. Data flow diagram serves two purposes-To tolerate an induction of how data are transformed as they move through the system.-To depict the functions that transformation the data flow.Data ObjectsA data object is a representation of almost any co mposite information that must be understood by the software. By composite information, we mean something that has a number of different properties or attributes. A data object encapsulates data only there is no reference within a data object to operations that act on the data.Attributes Attributes define the properties of a data object and take on one of three different characteristics. They can be used to-Name an instance of data object.-Describe the instance-Make reference to some other instance in other table.RelationshipData objects are attached to one another in a variety of different ways. We can define a set of object relationship pairs that define the relevant relationships.E-R DIAGRAMCUSTOMERHOTELCHECK INwayINFORMATIONwayROOM RECORDCUSTOMERHOTELCHECK OUTCUSTOMERROOMROOM PRICEHOTELDATA MODELINGData modeling defines elementary data objects, composition of each data object, and attributes of the object and other objects and between objects and processes.Hotel Table palm fic titious characterHotel IdVarchar2Hotel NameVarchar2 shell outVarchar2CityVarchar2 bid NoNumberNumber of StarsVarchar2Customer Table cogitations sheathCustomer IdVarchar2First NameVarchar2Last NameVarchar2GenderVarchar2AddressVarchar2Phone NoNumberEmail AddressVarchar2ReservationFieldsTypeReservation IdVarchar2Customer IdVarchar2Hotel IdVarchar2Reservation DateDateArrival DateDateDeparture DateDateRoom CategoryVarchar2StatusVarchar2Total CostNumberRoomFieldTypeHotel IdVarchar2Room NumberNumberCategory IdVarchar2Room CategoryFieldTypeCategory IdVarchar2Category NameVarchar2Number Of BedsNumberSearchIn this function, room, customer as user can search detail from the database according to their authentication.CONCLUSIONThis project have been designed in a great user friendly and largely providing attribute interface and tp meet the requirement of a Hotel Management System.. The project is working with quick answer and same level of security is also maintained. The Oracle database is ma intained and frontend with Visual Basic.In this designing system, I have used an ER Diagrams overall this project teaches us the essential skill like-Understanding the Oracle database discussion and query processing.-Using system analysis and design techniques like ER diagram and Data modeling in designing the system.