Project Introduction

In this project, we used basic SQL knowledge to build a house searching website. The user can search the house based on MLS, street address, zip code, house type and so on. After the user clicks a search button, the website will show them the search result. We also have managers to manage the website. We allow managers to modify the housing information. All in all, we think this is a good practice for us to learn SQL, PHP and HTML. We started from ER Diagram and then moved to create table, to normalize the table and at last, to write a SQL. (Build in fall 2011)

click to see the whole document