Question

3 (16) You are hired to build a database for a local association of realtors. The database has to contain information about the properties that are for sale in the area, realty agencies and agents, as well as keep track of the history of property sales. In particular, you are told the following about the desired database: o The database has to contain information about the realty agencies. Each agency has an ID, name, address and a phone number The database also must have a list of all realty agents. For each agent, the database stores his/her ID, name, phone number and the agency of employment. Each agent works for exactly one agency ° The key part of the database is the property listing. Each property offered for sale has the following information associated with it: unique listing number, listing date, current price, property address, seller's name, type(house, townhouse, condominium), number of bedrooms, number of bathrooms, number of floors, square footage, age, and how many cars can fit in the garage (0 no garage). In addition, each property is being sold by exactly one realty agency, and within the agency, by exactly one agent. The database must also list all the property transfers (sales) that have already occurred. Each property transfer consists of the listing number, date of property transfer, names of the buyer and the seller, names and agencies for the agents for the buyer and the seller and the purchase price. (4) Specify all entity sets present in the database. For each entity set, specify its attributes and indicate the primary key (4) Specify all relationship sets present in the database. For each relationship set, specify the entity sets it associates with each other and any additional attributes that may be needed. (4) Specify any cardinality constraints present in the database. (4) Draw the Fully-attributed data model diagram of the database. 1) 2) 3) 4)

Answer 1

i have solved the problem. but because of network issue i am not able to upload images of answer now. so pls wait for sometime. i will upload it within few hours. till then pls don't put downvote...........sorry for inconvenience.