HomeworkLib
Question

You have been asked to develop a real estate database to track homes, realtors, and owners.    ...

  1. You have been asked to develop a real estate database to track homes, realtors, and owners.     Homes are either rented or owned and have an address, a number of bedrooms, a number of bathrooms, and square feet. An owner has a SSN, name, spouse (owner may not have one), profession, and spouse’s profession (if no spouse, then no spouse’s profession). Owners might have several homes to sell, but a home has only one owner.   Agents represent owners in the sale of homes, and have a name, office identifier, and phone number. Agents are paid on a commission basis, based on the selling price of the home sold. Agents can represent many owner and homes, but each home or owner will only be assigned to or work with one agent.

  1. Identify the potential entities
  1. Draw a matrix to represent the relationships between the entities identified in part a.
  1. Write out the DATABASE business rules to represent the relationships between the entities identified in part a & b.
  1. Draw the ERD, including all “fixes”
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

ER Diagram

0 0
Add a comment
Know the answer?
Add Answer to:
You have been asked to develop a real estate database to track homes, realtors, and owners.    ...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • An ER Diagram

    Design an ER diagram to model a mini-Zillow (home buying) application with the following assumptions. Specify key attributes of each entity type and (min, max) constraints on each relationship type.• Each home (HOME) is uniquely identified by a home identifier (HOME_ID), street address (STR), city (CITY), state (ST), a number of bedrooms (NBed) and a number of bathrooms (NBath), and an associated owner (OWNER). • Each owner (OWNER) has a Social Security Number (OSSN), first name (OFirst_Name), last name (OLast_Name),...

  • 3 (16) You are hired to build a database for a local association of realtors. The database has to...

    3 (16) You are hired to build a database for a local association of realtors. The database has to contain information about the properties that are for sale in the area, realty agencies and agents, as well as keep track of the history of property sales. In particular, you are told the following about the desired database: o The database has to contain information about the realty agencies. Each agency has an ID, name, address and a phone number The...

  • Database design Part One (Conceptual Database Design) As a database developer, you have been asked to...

    Database design Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...

  • Mr. Bob Dillon is a collector of china pieces. He needs a database is to store...

    Mr. Bob Dillon is a collector of china pieces. He needs a database is to store data about his collection. Each piece in this collection is to be identified by a unique ID value. Bob knows of several agents that work on getting these pieces shown in prestigious exhibitions. Each exhibition has an ID, a name, a venue, a start date and an end date. For all items shown, there is a deadline for returning them to the item owners....

  • Q3: You have been hired to design a database for prescriptions for RX pharmacies and your...

    Q3: You have been hired to design a database for prescriptions for RX pharmacies and your first job now is to design an ER model for this database using the following description of that world. i. patients are identified by their SSN and have other attributes as names, addresses, and ages. ii. Doctors are identified by their SSN and have other attributes as names, specialty, and years of experience. iii. Each pharmaceutical company is identified by name and has a...

  • Due to your experience in designing the database for the "Legendary League" game, you have been...

    Due to your experience in designing the database for the "Legendary League" game, you have been asked to design the ER diagram for a bigger database to manage the events for the "Legendary League" eSports Oceanic Championship (OC). The requirements are as follows: Registered teams compete in the OC. Each team has a name, and a number of team members. A team also maintains a rank throughout the OC, reflecting how well it is doing in the championship. Team members...

  • TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please...

    TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please mark the Primary and Foreign Key ..... Deliverable: Word document with grade sheet followed by Part 1 ERD and the Part 2 relational schema. Part 1: Draw the ERD for the following situation. 8 pts Be sure to: Convert all many-to-many relationships to associative entities. Make sure each regular entity has an appropriate identifier. Make sure attribute names are unique within the ERD Wally...

  • 21. The local city youth league needs a database system to help track children who sign...

    21. The local city youth league needs a database system to help track children who sign up to play soccer. Data needs to be kept on each team, the children who will play on each team, and their parents. Also, data needs to be kept on the coaches for each team. Draw a data model with the entities and attributes described here. Entities required: Team, Player, Coach, and Parent Attributes required: Team: Team ID number, Team name, and Team colors...

  • You are a database consultant with Ace Software, Inc., and have been assigned to develop a...

    You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with the owners to discuss their business and watch their operation...

  • 6-dt-content-rid-11 91 82071-1/courses/1 1025.201 860/Scanned%20from%20MIS%20Xeroxpdrag 3. (42 points) This problem was inspired by a real-world database...

    6-dt-content-rid-11 91 82071-1/courses/1 1025.201 860/Scanned%20from%20MIS%20Xeroxpdrag 3. (42 points) This problem was inspired by a real-world database problem found in the news: Rental-owner database seen as solution to problem properties. A municipality (city) is creating a new database to help manage problems with rental properties within the city. They need to keep track of basic information (description, address, etc.)on the properties being rented within the city. They will store information on two types of rental properties, houses and apartments. These have...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT