Transcription
3/16/2015HotelManagementsystemCapstone Paper Draft VersionXiyi Li
1Hotel Management SystemWith the improved quality of life, the way people live changes as well as theirconsuming attitudes. Under this circumstance, restaurant and hotel have plenty of space todevelop in a modern way. Traditional hotel business mode is no longer suitable in thisinformational era. Professional and international service management system would helpshorten the distance between companies and the world, increase the business efficiency inorder to improve the service quality, customer’s satisfaction, and company’s core competence.So being that I am interested in system development, I decided to create a hotel informationmanagement system for small hotel business as my capstone project. I also want to learnmore about database, for example, how to make more complex database and queryinformation in a more sufficient way. Another motivation I had for doing this project is myinterest in user interface design. I have developed a great appreciation for website designafter I took the fundamentals of programming class. I learned a great deal of website designand development skills. Then I took system analysis and design class, which enhanced myanalysis ability in developing an integrated system. I learned how to apply the C# code to theaspx.net pages, as well as how to create a content management system. It is really excitingthat I am going to develop a system on my own, of course it is a challenge for me, andhowever, I believe that I will learn a lot after overcoming difficulties. Because once I havemet all those challenges and get the project done, the reward is a properly working systemwhich would make me feel satisfied.After figuring out what I should do, I started to think about how to accomplish thisproject. Based on the requirement and need of hotel management, the project is aimed tobuild a basic functional system in order to achieve the efficiency in the hotel management.Considering that hotel keeps a huge amount of files to handle reservation details, bills and
2inventory items, the overall mission of the system development is to make the hotel quicklyand easily complete the hotel management task. Although this system is intended for hotelemployees, different types of employees have different permissions when using the system.Three types of users are separated in the system, they are manager (admin), front-desk clerk,and employees from other departments who only have permission to read. Later, Isummarized the whole project into four steps. 1. Analyze the services needed in the hotelmanagement system, which I think is very important in developing a system. 2. Use UML tobuild the structure of the system, which is a deeper way of analyzing the system structure. 3.Design the system, Web interface and the database, which I might have difficulties indatabase connection because I didn't learn much about it before. 4. Summary the system anddiscuss the development of the system, which is a “learn from past” session. Since I had ageneral idea to go with, I had to get several software and technologies to make it happen. Iwill use C# language as a programming language to build the system. The platform that thesecodes will be run is .NET frameworks. The software Microsoft Visual Studio 2013 will beused to implement the codes. Microsoft SQL Server 2014 will be used to create the database.I feel excited and worried at the same time, because I am not sure if I can make it workeventually. However, I am willing to try to put the pieces together step by step and I figuredthat if I couldn’t figure out how to do something, I could get some support from classmatesand the internet.Since my computer doesn’t have enough capacity to support all the software, Idecided to accomplish my capstone project in CIS&T lab. Users and Function of the systemI started the project from analyzing the users and functions of the system. Threeclasses of users will be involved in the system: hotel manager, front-desk clerk and staff fromother departments. Front-desk clerk will receive, verify, and register customers’ information
3through the management information system; hotel manager will be in charge of managingthe basic information on the system, including the reservation details, guests information, andthe accounts of the front-desk clerk; people from other departments need to log into thesystem to see reservation information and prepare for related work, such as cleaning the roomfor next guests. The whole system includes the backstage database and front end the userinterface. User interface provides hotel staff an easy way to manage reservation and retrievethe information of guests. Hotel manager will have the highest privilege who can review andmanage the reservation, the room status, and information of the guests and employees. Frontdesk clerk has the second privilege who is in charge of the reservation, check in and checkout, as well as manage and query guests’ information. People from other departments such ashouse-keeping department can only have the read permission who can see from the systemwhich room needs to be clean, and notify receptionist to change the status of the room. Use case diagramAs I mentioned before, this hotel management system is meant for two different typesof users – front desk server and manager. Also, I made some modifications about the users ofthe system. I am thinking of cutting off the customer side and only the staff of the hotel to usethe system, which means customers could only make reservation by phone.Whole system use case diagram
4This diagram shows two subsystem within the whole system, which are front customerservice subsystem and back office management subsystem. Customers and front-desk serversinteract with each other and produce data through the front customer service subsystem;managers can use back-stage management subsystem to get information and manage data.Customer service subsystem use case diagramWhen customer needs to make reservation, ask for room details, or has other requirements,he/she could call the front-desk person to ask for the services. The front-desk person registersthe information of the customers with the customer service subsystem, and make reservationas well as update customers’ information. Data generated in this subsystem automaticallygoes to back-stage management subsystem. In addition, manager can use this subsystem tomanage the activities happened between customer and front-desk person.Back-stage management subsystem use case diagram
5Through the management function, manager can manage the spending record ofcustomers, detailed information of customers, and information about rooms as well asemployees. Based on these information, business report about the hotel can be formed.Above was my analysis of the hotel management system, and the next thing I had todo is to design the user interface and database.The “Hotel” database will include five tables – UserInfo, CustomersInfo, RoomsInfo,RoomStatus, and History.1. UsersInfo is used to store the basic user information of the hotel management systemNumberField NameData StructureRemark1UserIdIntUser’s ID2Namenvarchar(50)User’s 0)0-male; 1-famale5Emailnvarchar(50)Email address6Telephonenvarchar(50)Telephone eceptional; 10-administrator;100-others2. CustomersInfo is used to store the basic information of the customers who stay in thehotel.NumberField NameData StructureRemark1CIdentituIdnVarchar(50)ID number2CNamenVarchar(50)User’s Name3CPhonenVarchar(50)Telephone number3. RoomsInfo is used to store the basic room information
6NumberField NameData StructureRemark1RoomIdIntroom ID2RCategoryIdIntNumber of room tpye3RPositionnVarchar(50)Room location4DescriptionnVarchar(50)Description of room5PriceMoneyRoom price4. RoomStatus is used to show whether the room is available or not.NumberField NameData StructureRemark1Room IDIntRoom’s ID2StatusintRoom status5. History is used to track the business record.NumberField NameData StructureRemark1EndTimeIntDeparture time2RoomIdIntRoom ID3TotalPricenVarchar(50)Sum of consumption4Emailnvarchar(50)Email address5CnamenVarchar(50)Customer name6CphonenVarchar(50)Telephone number1. Home page design
7There will be two types of user using the system – hotel manager and front-desk person.User‘s different permission will be assigned when he/she is identified. After user enters thehome page (login page), he/she need to enter user name and password and click “log in”button. If the identification is verified, a massage will be showed in a label. If theidentification is denied, a massage will be showed asking reenter login information.2. Room Management page design
8This part is for the room management. If user wants to search for room information, he/shecan just search by the room number; if new room needs to be added, user can simply click“add room” button; if room information needs to be modified, user can click the link “detail”;if there is room which is no longer needed, user can click “delete” button.3. Reserve and check out page designThis part provides front-desk person with the status of current information for each room.User can search room based on room type, room status and room number. When you clickthe room, there will be detailed information in below. If the room is available, reservationfunction will be provided; if the room is not available, check out service will be provided.After I finished the front-end user interface design, unfortunately, I have to face withmy weakest part – database. I spent couple of days trying to figure out how to use SQLServer Management Studio (SSMS) to connect to the server, because I kept getting the errormessage saying I cannot connect to SQL Server. I looked up online searching for support,
9and tried many solutions. Unluckily, none of them worked. Finally I realized it was becausethe server name on connection window was wrong. After changed the server name, Isuccessfully connected to the server. It was a great lesson for me, which is never rush tryingto get help from somewhere else before you go through all the possible solution you couldfind out.Because I didn't take the information structure class at the University of Pittsburgh atBradford, I borrowed some study materials from my classmates and watched some onlinevideo about SQL Server. I followed the steps to create tables, wrote query code to add, delete,query, change the data stored in these tables. It didn't seem to be hard until I applied it to myproject. The relationship between tables can be very confusing sometimes and I kept mixingthem up. I did encounter a small problem when trying to connect SQL Server database to C#because there was some missing component in VS 2013 installation. After I downloaded theSQL Server Data Tool, the connection was successful.Now I am trying to get the login page work and make hotel room informationsearchable. I used the similar code as one of my other project, but it doesn't seem to work.
10
Above was my analysis of the hotel management system, and the next thing I had to do is to design the user interface and database. The “Hotel” database will include five tables – UserInfo, CustomersInfo, RoomsInfo, RoomStatus, and History. 1. UsersInfo is used to store the basic user information of the hotel management system
