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), phone (OWNER#), and profession (PROF).
• An owner can have one or more owned homes.
• Agents (AGENT) can represent owners in the sale of a home. An agent can list many homes, but only one agent can list a home.
• An agent has a unique agent number (AGENT_ID), name (ANAME), phone number (AGENT#), and an associated office (OOFF).
• When an owner agrees to list a home with an agent, a commission (COMM) and a selling price (PRICE) are determined.
• An office (OFFICE) has an office identifier (OFF_ID), phone number (OFF#), the manager name, (MNAME) address (OADD), and an optional agent number (AGENT_ID).
• Many agents can work at one office.
• A buyer entity (BUYER) type has a Social Security Number(BSSN), first name, (BFirst_Name) last name (BLast_Name), phone (Buer#), preferences for the number of bedrooms (NBed_Pref) and bathrooms (NBath_Pref), and a price range (PRICE_Range).
• An agent can work with many buyers, but a buyer works with only one agent.
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
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...
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...
Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to...
Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to create the model. The correct syntax must be used. Remember to list out all alternate keys, secondary keys, and foreign keys. Entity Relationship Diagram (ERD) Draw the data model for the situation using LucidChart, Microsoft Visio, Word or other ERD Drawing Program. When drawing the objects, be sure to use the correct shapes, and syntax. Example: Entity is a rectangle box, and the name...
A real estate firm keeps track of the houses for sale and customers looking to buy...
A real estate firm keeps track of the houses for sale and customers looking to buy houses. A house for sale can be listed with this firm or with a different one. For your information, being "listed" with a firm means that the house owner has a contract with an agent who works for that firm. Each house on the market has price, address, owner, and a list of features, such as the number of bedrooms, bathrooms, type of heating,...
Conceptual data diagram The ABC university keeps track of each student's name, student number, social security...
Conceptual data diagram The ABC university keeps track of each student's name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address, and to the student's last name. Both social security number and student number have...
question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have...
question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly. ------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will...
Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create...
1) Create Conceptual Schema Diagram
2) Create a fully attributed Loagical Data Model Diagram
3) Create the SQL script that will generate the data model
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...
Create ER model to a taxi company
The company is composed of many offices: Each office has:o A name, a city and a telephone number.o Each office has a Manager, several taxi owners, drivers and one administrative staff. The Manager is responsible for the day-to-day running of the office:1. Check the number of Jobs2. Check the number of complete jobs3. Check the number of failed jobs and the reason.Each manager has a name, ID, Office number, address, age(Less than 64) and telephone number (can have more than...
C PROGRAMMING: Define a set of data structures to store the information for a large real...
C PROGRAMMING: Define a set of data structures to store the information for a large real estate agency. The agency can be described with: agency name, headquarters, address (street, city, state, zip), and the records for up to 100 real estate agents located in different cities. Each realtor can be described with the following data: agent name, office address (street, city, state, zip), phone number, and houses for sale (consisting of up to 10 house records, each of which has...
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...
A real estate firm keeps track of the houses for sale and customers looking to buy houses. A house for sale can be listed with this firm or with a different one. For your information, being "listed" with a firm means that the house owner has a contract with an agent who works for that firm. Each house on the market has price, address, owner, and a list of features, such as the number of bedrooms, bathrooms, type of heating,...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
1) Create Conceptual Schema Diagram
2) Create a fully attributed Loagical Data Model Diagram
3) Create the SQL script that will generate the data model
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...
Most questions answered within 3 hours.
-
Last year, sanitation engineer crews in Buffalo, New York,
collected 124 tons of trash per day....
asked 38 minutes ago -
A wire is drawn through a die, stretching it to six times its
original length. By...
asked 8 minutes ago -
with SCREENSHOTS PLEASE
Linux+ Guide to Linux Certification Project 9-4 In this hands-on
project, you view...
asked 9 minutes ago -
You are calculating the present value of $5,000 that you will
receive at the end of...
asked 10 minutes ago -
Convert 31 ft^2 to yd^2
Round your answer to two decimal places.
asked 42 minutes ago -
Assume that a randomly selected subject is given a bone density
test. Those test scores are...
asked 26 minutes ago -
.The life of light bulbs is distributed normally. The standard
deviation of the lifetime is 20...
asked 45 minutes ago -
Pretend that you are a developmental psychologist and the
superintendent for a school district in MA...
asked 25 minutes ago -
If you add 4.00 mL of pure water to 6.00 mL of .750 M NaCl
solution,...
asked 45 minutes ago -
Mr. Lam had recently had a heart attack that caused a secondary
pericarditis, Dressler syndrome, with...
asked 31 minutes ago -
At 5 am your alarm goes off. Genes are expressed in response to
that stimulus and...
asked 46 minutes ago -
Why is the short-run Phillips curve downward sloping? Explain
the reasons behind the downward slope of...
asked 41 minutes ago