The system also requires building an Oracle database which keeps information abo

Question

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

Explanation / Answer

The oracle database in this can have the following schema. Here schema refer to the over all desing of the database.

1) Homes_Table(home_identification_number, home_name, home_owner, floor_space, floors, bed_rooms, bath_rooms, land_size, year_constructed, home_address)
2) Home_Category(home_identification_number, home_category)

Here home_identification_number is primary key in Home_Table and foreign key in Home_Category table

3) Appliances_Table(model_no, model_name, name, maker, yearofMaking, price)

Here model_no is the primary key

4) Agent_Table(agent_id, agent_name, sold_home_id, sold_home_owner, timeDuration_of_houseSell)

Here agent_id is the primary key

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.