Analyze the following business rules of the real estate company listed below: An

Question

Analyze the following business rules of the real estate company listed below: An Agent can work with many Clients A Client can only have one Agent An Agent is based out of one Office A Office can have many Agents based out of it An Agent can have many Assistants An Assistant can work with multiple Agents An Agent can work with many Properties A Property can only have one Agent assigned to it A Property can only have one Status There are multiple Statuses that are available for a Property (For Sale. Sold, Under Contract, Leased, and Available for Lease) Once you have reviewed the Business Rules, complete the following: Identify at least 6 entities and 5 relationships. Once you have identified the entities you should identify at least 7 attributes for each entity. Using the entities, attributes, and relationships create a data dictionary using MS Office or Excel.

Explanation / Answer

Entities:

Relationships:

Attributes:

Agent:

name, id, no. of clients, names of clients, office, assistant, properties

Client:

id, name, agent id, agent name, propety, related property status, contact

Office:

id, address, list of agents, list of properties, contact

Assistant:

id, name, number of agents, list of properties dealing with, names of agents

Status:

names, properties, agents dealing with properties, agent and property id's

Property:

name, location, agent dealing with, status

Data Dictionary(using MS-Word)

table name: new

indexes:

views:

-na-

storage procedures:

-na-

functions:

-na-

3. Change the connection string as per the SQL Server credentials

4. Add references to Microsoft ActiveX Data Objects Library from the menu Tools->References.

5. Run the macro by pressing F5 from the VBA editor.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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