This paper circulates around the core theme of You are suggested to read the entire specification first, and then start with the tasks that are already covered by our online modules. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
This project is to build a website for the imaginary Western Sydney Hotel which allows customers to search and book rooms, and staff members to manage bookings and rooms. However, some of the requirements will be different, so you should strictly follow this specification in completing the project.
You are suggested to read the entire specification first, and then start with the tasks that are already covered by our online modules.
1 Database description
Since the design of the database for the website decides many facets of project implementation, we detail the design of the database first.
1.1 Western Sydney Hotel (WSH) basics
The WSH has only one 4-story building. On each floor, there are a certain number of 1-bed rooms, 2-bed rooms, and 3-bed rooms. Each room is uniquely identified by a Room ID. The Room ID has the following format: FNN, where F indicates the floor and can be ‘G’, ‘1’, ‘2’, or ‘3’, and NN consists of two digits that indicate the room number on a floor. For example, the room ID ‘121’ means a room with number 21 on the first floor.
The WSH website uses an SQL Server database. You should follow our online module 8 to create a local database file for this database, and name it ‘WesternHotel.mdf’.