Specify the following queries in SQL on the following database schema (keys are

Question

Specify the following queries in SQL on the following database schema (keys are in bold and underline): Customers(custID: String, cName: String, phone: String) Preferences(custID: String, fID: String) Agents(agentID: String, agentName:String) Houses(addressID: String, address: String, ownerID: String, agentID: string, firstDateOnMarket: DATE, forSalePrice: real) Owners(ownerID: String, ownerName: String, phone: String) Amenity(addressID: String, fID: String) Features(fID: String, category: string, description: string) The domain of each attribute is listed after the attribute name. The primary key attributes are underlined. The table Preferences lists all features required by the customer. In other words, each tuple describes a customer’s one preference feature ID; e.g., {(A1001, bd5), (A1001, ba3), (A1001, lot1}. A customer is interested in buying a house, if the set of all features specified by the customer is a subset of the amenities the house has. A record in the table House states who is the owner, and who is the real estate agent listing the house. Write the following queries in SQL.

Query4: Drop the price by 5% of houses that have been listed on the market for more than one year.

Explanation / Answer

Please find the answer of given question 4

UPDATE House set forSalePrice=forSalePrice-forSaleprice*5/100

where firstDateOnMarket<=(select ADD_MONTHS(SYSDATE, -(12 * 1)) from dual;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

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