Problem regarding the forida now real estate

Assignment Help Basic Computer Science
Reference no: EM131076091

Forida Now Real Estate

Tanya Pierce, President and owner of Florida Now Real Estate is seeking your assistance in designing a database for her business. One of her employees has experience in developing and implementing Access-based systems, but has no experience in conceptual or logical data modeling. So, at this point Tanya only wants you to develop a conceptual data model for her system. You are to use our entity-data diagramming notation (rather than the book's notation; Crows foot symbols).

Tanya has some very specific needs for her system. There are several aspects of the business that need to be represented in the data model. Of central interest are properties that are listed or sold by the company. Note that a separate division of Florida Now handles raw land, so your system only has to deal with developed property. For all types of properties, Tanya wants to keep track of the owner (client), the listing and selling dates, the asking and selling prices, the address of the property, the Multiple Listing Service (MLS) number, and any general comments. In addition, the database should store the client that purchases a property. There are some specialized data that need to be stored, depending on the type of property. For single family houses she wants to store the area (for example UCF or Conway), the size of the house in square feet, the number of bedrooms and baths, the size of the garage (for example, 2 car), and the number of stories. For condominiums, the database should track the name of the complex, the unit number, the size in square feet, the number of bedrooms and baths, and the type of community (coop or condo). For commercial properties, she needs to know the zoning, size in square feet, type (industrial, retail, or office), and the general condition of the property.

Tanya also wants the database to store information about her real estate agents, such as their name, home address, home phone number, mobile phone number, email address, and their real estate license number. Also, the database should track which agent lists and sells each piece of property. Note that she has a separate system that tracks selling agents and listings from outside brokerages,  so you don't have to worry about external agents. However, sometimes a property will be listed and sold by the same Florida Now agent, but other times one Florida Now agent will list a property and another will sell it.

Of course, Tanya thinks that it would be good to have the database track information about Florida Now's clients, such as their name, phone number, and street and email addresses. Also, she wants to be able to record comments about the client. Florida Now offers referral fees to clients who refer potential customers to the brokerage. The database should store these referral relationships between clients, including the amount and date of the referral payment. Note that only one client can be paid for a referral. In other words, it is not possible for two clients to be paid for referring the same client. Finally, Tanya wants to be able to use the database to examine the effectiveness of various advertising outlets. For each outlet, the database should store the name of the outlet (for example, realestate.com or the Orlando Sentinel), the main contact person and their phone number. She also wants to know how much it cost to advertise each property on any outlet used, and when a property was advertised on each outlet used for that property. Keep in mind that a property may be advertised on multiple outlets, and that the cost of advertising on an outlet might vary from property to property.

Create an entity relationship diagram that captures Tanya's database requirements. The ERD should indicate all entities, attributes, and
relationships (including maximum and minimum cardinalities). Also be sure to indicate primary key attributes.

You must draw the ERD using computer software such as Visio, PowerPoint or Word. In addition, you must resolve all M:N (manyto- many) relationships and multi-valued attributes. State any assumptions you make. Remember that your assumptions must be reasonable and must not violate any stated requirements. Think through the entities, and attributes for each entity.

Reference no: EM131076091

Questions Cloud

What is the maximum number of records that can be stored : What is the maximum number of records that can be stored?
Role of information security policy : Using the paper in Weeks 2 and 3 add an additional 3-to 4-pages describing the importance of policies and standards for maintaining information systems security.
Percentile of the lognormal distribution : a. Use Equation (4.13) to write a formula for the median ,m of the lognormal distribution. What is the median for the load distribution of Exercise 79?
Provide sample statute citations and describe the statutes : Identify civil/administrative enforcement statutes. Provide sample statute citations and describe the statutes and available sanctions.
Problem regarding the forida now real estate : Tanya Pierce, President and owner of Florida Now Real Estate is seeking your assistance in designing a database for her business. One of her employees has experience in developing and implementing Access-based systems, but has no experience in con..
Create a single node that contains the inserted item : Note that insertion into an empty B-tree will create a single node that contains the inserted item.
Chemical masses that travel to the main stem of a river : Nonpoint source loads are chemical masses that travel to the main stem of a river and its tributaries in flows that are distributed over relatively long stream reaches, in contrast to those that enter at well-defined and regulated points.
Are you more likely to fall up or fall down : Please explain the difference between falling up and falling down in relation to criminal justice. Are you more likely to fall up or fall down? Why do you feel this way? ( minimum of 500 words).
Important to reduce one carbon footprint : Nowadays it is very important to reduce one's carbon "footprint" (how much carbon we produce in our daily lifestyles). Minimizing the use of fossil fuels and instead resorting to renewable sources of energy. What is the annual effective IRR of this i..

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  What are the two limitations of static packet filtering

In their purest form, netbooks are PCs designed to have little or no software stored on them. Instead, they are designed to use cloud computing, in which the software and data are both stored on Internet servers. Netbooks in this pure form can onl..

  The importance of reports

Explain in your own words the importance of report writing and why you believe it is critical to the system forensics industry. Discuss the need for forensic reports when testifying as an expert witness.

  Create the computer system needed to store information

create the computer system needed to store and organize the information they collect. Whodunit would like your company to design a system to help them categorize, sort, store, and otherwise manipulate the thousands of artifacts they collect using ..

  Indicate how an http server might apply it

find out about the programming interface for this mechanism, and indicate how an HTTP server might apply it.

  Representing information by predicate-calculus sentences

Represent this information by predicate-calculus sentences in such a way that you can represent the question Is there a member of the alpine club

  What is the lowest and highest addresses

Assume a 2^20 byte memory what is the lowest and highest addresses if memory is word addressable, assuming a 32-bit word.

  Write a little driver program with at least 5 values passed

Provide functions to insert/append nodes and remove nodes from the linked list. Be able to display the contents of the list. Write a little driver program with at least 5 values passed in (so that 5 nodes are created) as you insert/append, delete and..

  Information related to configuration management a

Information related to configuration management and preventative maintenance Industry standards in configuration management and control Training approaches to allow for adaptive maintenance and confidence.

  Eclipse program project

Write a complete program that stores and prints participants in a party. As part of your program, write a Party class that implements these members:

  Use case description versus activity diagram

Consider a system needed to store information about computers in a computer lab at a university, such as the features and location of each computer. Ascertain the domain classes that might be included within the domain model. Discuss whether or not y..

  What is a potential drawback of this kind of media

What is a potential drawback of this kind of media. Describe the experience of participating in this exercise, a new technology that helps you become socially connected. This technology can take the form of instant messaging or an online network th..

  The task is to animate a cat chasing a mouse

The task is to animate a cat chasing a mouse as it tries to get close enough to catch it (within 1 foot). Of course, as the cat continues to chase the mouse, the mouse is also running away and moves to random positions, trying to lose the cat. You wa..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd