Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Follow the step-by-step instructions presented in class to create a UML class diagram from the following system description of the Sonoran Real Estate Agency (SREA).

image text in transcribedimage text in transcribed

Follow the step-by-step instructions presented in class to create a UML class diagram from the following system description of the Sonoran Real Estate Agency (SREA). Please use LucidChart for drawing and use proper naming conventions for classes and attributes throughout all steps in the assignment. Please write down your assumptions in a separate textbox in LucidChart when necessary. You do not need to upload this document. Please upload the diagram in PDF format. You may export PDF from LucidChart following our tutorial. Before uploading, rename your file as [FirstName LastName MIS 331 HW 2] (the document extension will remain pdf). Replace FirstName and LastName with your name. Clients are identified by a Client ID, and SREA records clients' legal name and preferred name. Each client is represented by one agent. An agent is identified by an Agent ID and has a legal name, phone number, and email address stored in the system. An agent lists houses. Each house is identified by a House ID, and SREA records its address, size, and number of bedrooms. Each house is listed by one agent. Agents can (and are encouraged to) have multiple clients and list many houses, although a new agent who just begins the job may not have a client or list a house yet. Each house is owned by one owner. An owner is identified by an Owner ID and has a phone number, email address, and a preferred method of contact. Owners get recorded in SREA's system when they have at least one house in the system. All houses listed by SREA can be categorized into two exclusive types: houses-to-rent and houses-to-sell. For houses-to-rent, SREA records their monthly rent; for houses-to-sell, SREA records their list price, sale price, and sale date. Sale price and sale date are null when a house has not been sold yet. Every client can buy multiple houses-to-sell, and a house-to-sell can only be bought by one client. Every client can also rent multiple housesto-rent. A house-to-rent can be rented by multiple clients over the time period of the SREA database. SREA records the total time duration of renting for each pair of a client and a house-to-rent. A house-to-rent may not be rented by anyone yet. A new client may not buy or rent any houses yet. Clients can visit houses before they make a rental or purchase decision. It is common that a client visits multiple houses, and a house is visited by many clients. A new client may not visit any houses yet, and a house may not be visited by anyone yet. SREA records the number of times a client visits a particular house to understand their interest. Clients can choose to refer other clients, and they can refer multiple clients if they want to. A client can be referred by only one other client. SREA does not require referrals to become a client

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

Database Management With Website Development Applications

Authors: Greg Riccardi

1st Edition

0201743876, 978-0201743876

More Books

Students also viewed these Databases questions