DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-II
Draw an ERD for a Real Estate company based on the instructions below:
The firm has a number of sales offices in several cities. We need to store unique office no, address and city for each sales office. Each sales office employs one or more employee id, name , address , city and salary .For each sales office there is always one employee assigned to manage that office. An employee only manage one sales office s/he is assigned to.
The firm lists many properties for sale. The necessary attributes needs to be stored are property id, type(villa, apartment etc.) price and address.Each property must be listed with only one sales office but a sales office may have many properties listed.
Each property should have at least one or more owner and an owner may have many properties. For each owner we need to store unique id, name , phone no, address.