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 descriptionSince 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) basicsThe 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'.