You have been asked to develop a real estate database to track homes, realtors, and owners. ...
- 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.
- Identify the potential entities
- Draw a matrix to represent the relationships between the entities identified in part a.
- Write out the DATABASE business rules to represent the relationships between the entities identified in part a & b.
- Draw the ERD, including all “fixes”
Homework Answers
Add Answer to:
You have been asked to develop a real estate database to track
homes, realtors, and owners. ...
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...
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...
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...
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...
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 Mom and Pop Johnson video store in town. Mom and Pop 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 Mom and Pop to discuss their...
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 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,...
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...
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...
Most questions answered within 3 hours.
-
You have to write your code in C++ (as a cpp file) and prepare a
docx...
asked 31 minutes ago -
Why does the spectrum of bromocresol green changes at different
pHs? What causes the change?
asked 36 minutes ago -
Rice Company has a unit selling price of $690, variable costs
per unit of $390, and...
asked 1 hour ago -
The DeVille Company reported pretax accounting
income on its income statement as follows:
2018
$
425,000...
asked 1 hour ago -
Argue for or against the "Three Strikes"laws. Provide a rationale
to support your response.
asked 2 hours ago -
Bargaining Models: what is the "Obsolescing Bargain"?
Bargaining Models: what are the factors that would tend...
asked 3 hours ago -
1. A ball is thrown up into the air.
a) Draw motion diagram and the point-like...
asked 3 hours ago -
1) Because money eliminates the "double coincidence of wants"
problem, the development of money as a...
asked 4 hours ago -
Company AAA produces only one product which other manufacturers
purchase as a component for their final...
asked 6 hours ago -
An
item can be appended to an array-based list, provided the lenght is
less than the...
asked 6 hours ago -
Two particles each have a rest mass energy of 30 MeV and are
traveling with a...
asked 8 hours ago -
why
is vectorization a faster alternative to loops?
asked 9 hours ago