Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following scenario modeling project management activities in an organization. A Real Estate company offers to its clients the option of purchasing a property

Consider the following scenario modeling project management activities in an organization. A Real Estate company offers to its clients the option of purchasing a property using repayment schemes of over 1 year, 2 years, 3 years, 4 years or 5 years. A Client may purchase one or more property under the scheme. Similarly a property may be purchased by a client or may not be purchased. When a client wants to purchase, he or she gets to choose one of the repayment scheme options for each purchase or may pay the whole amount in one go, meaning a repayment scheme option may be selected by one or more client or may not be selected at all. A client will have a unique number, a name, an address, and a phone number. A repayment scheme option will have a unique repayment scheme number, a name and the number of years for repayment. A property will have a unique property code, type, address, age of the building and a price. The company employs many sales representatives who work on selling the properties, A property can be dealt by any number of sales representatives and a sales representative deals with many properties owned by the company. Whenever a property is sold a sales representative, the company pays commission its sales representatives, so it tracks the date of sale of the property and the commission amount paid for audit purpose. A sale representative will have a unique salesperson ID, a name, a phone number and an email address.

based on this scenario can you please help me to draw ER diagram with relationship and cardinality ??

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional SQL Server 2000 Database Design

Authors: Louis Davidson

1st Edition

1861004761, 978-1861004765

More Books

Students also viewed these Databases questions