1. Assignment Overview
This assignment is to build a simple website for the Western Sydney Hotel (WSH). The main
functionality of the website includes: allowing customers to register, login, search and book rooms, and
allowing hotel administrators to browse any table in the database, and change room prices.
2. Database description
It is important to understand the design of the database for the website before creating individual html
or php pages. Take some time to review the details in this section before proceeding with website page
implementation.
2.1 Database tables
The WSH uses a MySQL database named ‘westernhotel’ to store the information about it’s rooms,
customers, administrators, and room bookings. A pre-populated copy of the westernhotel database is
available to each TWA student. Subsection 2.2 of this document describes how to connect to your
database, and also provides a PHP page allowing you to examine the data initially in your database.
Note that details on data types supported in MySQL can be obtained from
http://www.w3schools.com/sql/sql_datatypes.asp.
Specifically,

Category: Essays