Question

Create a relational model and ER diagram based on the following info.

Emerald Realty Group, Inc. is a local real estate company that is specialized in leasing office space to businesses. The company does not own all the properties it leases. The company has its own suppliers and customers. We refer to the person or the company that owns the office space as a supplier. A customer is the person or the company that rents the office space. Emerald Realty Group, Inc. facilitates the process of leasing properties to customers. For the services provided, the company gets royalties from the suppliers. The amount depends on the value of the property leased. Currently, the company uses file folders to keep their business information. As the size of the business is growing, it is getting difficult to manage this information. Emerald Realty Group, Inc. is interested in building a database that will enable them to better manage the business. Database Design We present the main entity types of this database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF, decompose it into 3NF relations. 1. Customers: The main attributes are identification number, name, address, name and telephone number of the contact person, etc. 2. Suppliers: The main attributes are identification number, name, address, name and telephone number of the contact person, etc. 3. Property: The main attributes are identification number, name, address, price, size, descriptions, etc. Note the following: (a) A property owned by a supplier is leased to a customer on a particular date, for a particular monthly rent, for a particular time period. In addition to this, details about the general liability insurance are recorded; (b) Customers have certain requirements about the property they will rent. The requirements are related to the size of the property, location, monthly rent, etc; (c) When a supplier asks for service, the following information is recorded: date, amount to be paid in royalties, etc.

Answer 1