Based on the following information requirements, construct an ER model. If you believe that you need to make additional assumptions, clearly state them. There are a number of sales offices in the...


Based on the following information requirements, construct an ER model. If you<br>believe that you need to make additional assumptions, clearly state them.<br>There are a number of sales offices in the firm. Attributes of SalesOffice include<br>QfficeNo, Location, and Budget. Each sales office is assigned one or more<br>agent. Attributes of Agent include AgentID. Firstname, LastName and HireDate.<br>An agent must be assigned to only one sales office. For each sales office, there<br>is always one chief agent assigned to manage that office. Each chief agent<br>cannot manage more than one office.<br>An agent handles more than one property. Each property is handled by more<br>than one agent (e.g., listing agent, seller's agent or buyer's agent). Attributes of<br>Property include PropertyID, Type, StreetNo, City, State and ZipCode. There are<br>two types of properties: House and Land. Additional attributes of House include<br>NoOfBedrooms and NoOfBathrooms. Additional attributes of Land include Usage<br>(e.g., farm or residence) and Acreage. re<br>Each unit of property has one owner. Attributes of Owner are OwnerID,<br>FirstName, LastName and Phone. An owner owns one or more unit of property.<br>

Extracted text: Based on the following information requirements, construct an ER model. If you believe that you need to make additional assumptions, clearly state them. There are a number of sales offices in the firm. Attributes of SalesOffice include QfficeNo, Location, and Budget. Each sales office is assigned one or more agent. Attributes of Agent include AgentID. Firstname, LastName and HireDate. An agent must be assigned to only one sales office. For each sales office, there is always one chief agent assigned to manage that office. Each chief agent cannot manage more than one office. An agent handles more than one property. Each property is handled by more than one agent (e.g., listing agent, seller's agent or buyer's agent). Attributes of Property include PropertyID, Type, StreetNo, City, State and ZipCode. There are two types of properties: House and Land. Additional attributes of House include NoOfBedrooms and NoOfBathrooms. Additional attributes of Land include Usage (e.g., farm or residence) and Acreage. re Each unit of property has one owner. Attributes of Owner are OwnerID, FirstName, LastName and Phone. An owner owns one or more unit of property.

Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here