Consider designing a real estate J2EE Web based system. The system requires implementing the following set of technologies: 1)JSP 2)JavaServlet 3)JDBC 4)SQL as a programming database 5)XML 6)Tomcat Web Server 7)CSS 8)HTML 9)Pure Java Skills 10)And etc The system also requires building an Oracle database which keeps information about homes, appliances, agents, owners and locations in Michigan.

Typical information kept in the database includes

Homes: FloorSpace, Floors, BedRooms, BathRooms, LandSize, YearConstructed. Homes can be further categorized into mansions, apartments, townhomes and condos. They will have all the properties of a home, but they will have distinguishing properties from homes and from one another. For example, mansions must have more than 6,000 sqft of floor space and more than 2 acres land size, and apartments cannot have more than one floor. The set of such homes are distinct - no two homes will be simultaneously an apartment and a mansion, for example.

Location: A home can have an identification number and resides in a unique address. Notice that even though condos may have the same address, their unit number distinguishes them from each other. You need to account for this fact also. An address, on the other hand, while unique, its components may not. For example, a street may have several houses, a city will have several streets, and several zip codes. No two streets have the same name within a zip code. A city will have a changing population. Several cities will make up a county. All county names are unique.

Appliances: Appliances have a model name or number, year, a maker, a name and a price. Homes will include numerous appliances made by different manufacturers. Appliances are identified either by their model number, or by the make and the name of the appliance.

Agents: Agents are identified using a unique agent identity. Agents sell homes to different people called home owners. Agents sell the homes to an owner who will own the homes for some period of time, and can sell them to another person through an agent possibly at different price. Two agents cannot sell the same home at the same time. Agents receive commission (percentage) on the purchase price of a home. The rate of commission is determined by the real estate company the agent works for. She/he is allowed to work for many different companies such that the company will have an office in the city he/she sells homes.

Owners: Home owners have a name, a unique social security number, number of dependents (family members), income, age and a profession.

Design the J2EE system keeping in mind that users of this system may ask some of the following questions for a variety of reasons.