Complete the following:

Part III: Using the description below (which is not in our textbook) create an ERD for the real estate firm. Instructions

Follow the instructions below:

For all the problems use the Crow's foot notation. Do not create the Chen or UML diagrams, even if the author tells you to do so. . Include connectivities (tick-marks and circles). You do not need to include verbs on your relationships. The exception is if there are two or more relationships between the same two tables. Include all the attributes described in the problem. Note that for some of these problems the author has intentionally left out most/all of the attributes. Do not make up non-key attributes.Your ERD should include the appropriate primary keys and foreign keys, even if the author omitted them. Create them if necessary. Keep it simple and straight forward. If you have a Product entity then an appropriate primary key would be Product_Number or Product_Id.Include solid or dashed lines for strong/weak relationships.Do not use multi-valued attributes or derived attributes.I only need the completed ERD in Crow's foot notation. You do not need to answer any of the author's questions, create lists, etc. When the author says to identify something you should include it in the ERD.Do not use any ternary relationships. Convert these into one to many relationships.Make sure you have no redundant data. See section 3-7 starting on p. 101 (12th edition). Other NotesThe point level for this assignment has increased.This assignment may take you longer to complete than previous assignments. Don't wait until the last day.Do not complicate the problem by adding to it. Your imagination can lead you astray. Do not add non-key attributes or entities that are not explicitly in the problem. Note that this is very easy to do without thinking about it. The human mind likes to fill in the blanks.Don't forget that instances of entities (rows in tables) never show up on an ERD.The organization that the database is for is almost never an entity. Often times it is never stored in the database.Some information in the problems is irrelevant to the ERD. This is common in data modeling.

Main/Displaylmage.aspx Section cis2710sp 18&File-Hwo2c,png 22. Prepare an ERD for a real estate firm that lists property for sale. Also prepare a definition for each entity type, attri- bute, and relationship on your diagram. In addition, draw a data model for this situation using the tool you have been told to use in your course. The following describes this organization: The firm has a number of sales offices in several states. Attributes of sales office include Office Number (identi- fier) and Location. . Each sales office is assigned one or more employees Attributes of employee include Employee ID (identifier) and Employee Name. An employee must be assigned to only one sales office . For each sales office, there is always one employee as- signed to manage that office. An employee may manage only the sales office to which he or she is assigned. The firm lists property for sale. Attributes of property in- clude Property ID (identifier) and Location. Components of Location include Address, City, State, and Zip Code. Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed or may have no properties listed . Each unit of property has one or more owners. Attributes of owners are Owner ID (identifier) and Owner Name. An owner may own one or more units of property. An at- tnbute of the elationship between property and owner is Percent Owned