D- when you finish from my assignment i have to submit in turnitin and that website its looking or searching in my assignment words if i taken from any resource of ( internet, students , books, newspaper …) so you have be careful in that to not become higher then 5%
* please go though the question and follow the steps please. If there is any thing inform me
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 at all. 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.
A) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, associative entities, attributes of each entity including primary key, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design. (30 marks)
B) Analyze the above given scenario and discuss about the possible structure of the relations (the number and name of the columns, datatypes etc.) and the referential integrity constraints to be implemented in the above design. State any assumptions necessary to support your design.