This problem gave me all the info needed to create an ERD for real estate. I put together the tables and did what I could to connect the tables based by the relationships one-to-one, one-to-many, and many-to-many. I had to take into consideration multivalued attributes. Some relationships will be optional. It would be good to label how each label connects (for example AGENT sells PROPERTY). Property is the supertype while Property types are the subtypes. This also needs to have maximum and minimum cardinalities. I could really use help connecting the rest of the tables taking into consideration the info I just gav
This problem gave me all the info needed to create an ERD for real estate. I put together the tables and did what I could to connect the tables based by the relationships one-to-one, one-to-many, and many-to-many. I had to take into consideration multivalued attributes. Some relationships will be optional. It would be good to label how each label connects (for example AGENT sells PROPERTY). Property is the supertype while Property types are the subtypes. This also needs to have maximum and minimum cardinalities. I could really use help connecting the rest of the tables taking into consideration the info I just gav
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
This problem gave me all the info needed to create an ERD for real estate. I put together the tables and did what I could to connect the tables based by the relationships one-to-one, one-to-many, and many-to-many. I had to take into consideration multivalued attributes. Some relationships will be optional. It would be good to label how each label connects (for example AGENT sells PROPERTY). Property is the supertype while Property types are the subtypes. This also needs to have maximum and minimum cardinalities. I could really use help connecting the rest of the tables taking into consideration the info I just gave.
Transcribed Image Text:+
囲
Vi
Agent
РК AGENT ID
(1,1)
First Name
Last Name
Address
City
State
Zip
Agent Job
Home Number
Agents can sell
no properties or
sell many. It's
optional
(1,2)
K PK.FK1
AGENT ID
Mobile Number
PK.FK2
AGENTJOB ID
Email Address
Property sold
License Number
Property listed
(1.1)
23
(1,1)
Property Data
>C(1.N
Assumption:
A client can have
(1,N)
many referrals
PK PROPDATA ID
Client
ClientiD
PK CLIENT ID
1,1)
Buyer
First Name
Listing Date
Last Name
Pa
Listing Price
Phone Number
Client Referrals
(1.N PK.FK1
Selling Date
Address
CLIENT ID
Selling Price
City
PK,FK2 CLIENTREF ID
Asking Price
State
Referral Name
MLS Number
Zip
Relationship
General Comments
Email Address
Payment Amount
Client Comments
Payment date
Transcribed Image Text:All changes saved
IN)
(1.N)
Property Data
PK.
PK PROPDATA ID
PK.
ClientID
Buyer
Listing Date
Listing Price
Selling Date
Seling Price
Asking Price
MLS Number
General Comments
Family Home
Condo
Commerical
PK FAMILYHOME ID
PK COM ID
(1,3)
(1,1) PK CONDO ID
Location
Zoning
Complex Name
Property sq. ft.
Unit Number
Property sq. ft
Number of bed/bath
Property sq. ft.
Garage size
Number of bedrooms
Number of stories
Commercial Type
Number of bathrooms
PK,FK1
COMID
1,1)
PK, FK2 COMTYPE ID
Advertising Outlet
Industrial
PK ADVOUTLETID
Retail
Outlet Name
Condo Type
Office
Contact Name
Assumption:
Condo has more than
PK.FK1
CONDO ID
(1,2)
one attribute which can
be put in another table.
The max # of condo
Phone Number
PK.FK2
CONDOTYPE ID
Advertising Cost
types is 2.
Co-op
Advertising Date
Condo
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY