Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started