Need help with database!

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: Floors, BedRooms, BathRooms, LandSize, Year Constructed. 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 sq.ft 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