Due by Thursday 12/3; but you can do this earlier if you want. If you get started now, you should have plenty of time. Team work is allowed, and all team members must be present at the demo. Demos can be given during class time on either Tuesday 12/1 or Thursday 12/3.
Send a zip file containing your code, database, database generation script, and any other relevant files (e.g., photo image files) to schwartz@cs.fsu.edu. When sending your project code, be sure to include the names of all your team members in the email.
You are to create an on-line real estate listing service. The are numerous commercial websites that you can use as guides, including the service provided by the Tallahassee Democrat at www.tdo.com, as well as the ones at www.realtor.com, and www.homes.com. Just provide the basic functionality, i.e., means for people who want to sell houses to post an ad on the website and means for people who want to buy a house to search the website and view the ads returned by the search. There is no need to provide user accounts or login processes.
The ads should contain basic information about the house, such as price, number of bedrooms, number of bathrooms, square footage, whether it has a fireplace, or a swimming pool, is waterfront property, etc., as well as the address and a photo. It should also include contact information for the realtor or seller.
The search functionality should allow for searching by various criteria, including price range, number of bedrooms and bathrooms, and other features (fireplace, swimming pool, etc.) if desired by the user. Return search results ordered by price, from highest price to lowest.
You will need to create a Cloudscape database for this. You can use the sql scripts provided with the textbook as guides. Instructions on how to use the ij facility for running scripts can be found in the usefulthings directory.
It is recommended that you use the bookstore application from Deitel Chapter 11 as a guide for this. The project may be implemented using Sun Microsystems J2EE, in the manner described in that chapter, or using Apache Tomcat, following the examples in Deitel Chapter 10. In any case, your project must employ an eXtensible Stylesheet Language transformation and use a file analogous to book.xsl in the Deitel bookstore application.
For working with photos, just create a directory of images and have them loaded into the HMTL as needed for the displays. Don't worry about giving the user a means to upload files (even though this really isn't all that difficult). Manually copying them into the images directory is okay for this assignment.