Hotel management system + ERD diagram + testing

Please create a very simple website in php and use a mysql database set up and create a registration and login page. Furthermore the website should incorporate the following features: 1- A booking system, this involves reserving a room for a customer and un-reserving it when the customer leaves the hotel etc. 2- Each customer reserving a room should have the following details; a profile, name, id, address, marital status, the time period of reservation, type of the room. You have the choice to either delete the profile when the customer leaves or keep it in the system. 3- The hotel system should give information about the hotel rooms status i.e. how many rooms are reserved and how many are not, types of those rooms, how many customers are in the hotel. Please note that there are 150 rooms and 70 of these are single bed rooms, and 80 of these are double bed rooms. 1 to 70 are single rooms and 71 to 150 are double beds. 4- A waiting list to add customers to if the hotel is full. 5- The user of the program should know how much the customer paid and how much should he pay before leaving the hotel when he/she is about to leave. 6- Searching for a room by its number should be an available service in the program in order to check the room status (reserved or unreserved). 7- Also you need to find the rooms in the hotel. This service should display the room numbers and their types. (please only use the following types, single bed room, double bed room) 8- You can search for a person by name or id and then display his/her profile. Please note this needs to be as simple as possible with a very simple lay out, I am not looking for a sophisticated website. The database also needs to be very simple.