Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment : Design the ER diagram for the following mini world using ER quely defined by home identifier, address (street address, city, state), a number

image text in transcribed
Assignment : Design the ER diagram for the following mini world using ER quely defined by home identifier, address (street address, city, state), a number of bedrooms and a number of bathrooms and an associated owner Each owner has a Social Security Number, first name, last name, phone, and profession An owner can spouse one or more homes Agents 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, name, phone number and an associated office When an owner agrees to list a home with an agent, a commission and a selling price are determined. An office has office identifier, phone number, the manager name, address and an optional agent number. Many agents can work at one office A buyer entity type has a Social Security Number, first name, last name, phone, preferences for the number of bedrooms and bathrooms, and a price range.An agent can work with many buyers, but a buyer works with only one agent

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Spatial Databases 2nd Symposium Ssd 91 Zurich Switzerland August 1991 Proceedings Lncs 525

Authors: Oliver Gunther ,Hans-Jorg Schek

1st Edition

3540544143, 978-3540544142

Students also viewed these Databases questions

Question

=+C&B (especially taxation) laws, regulations, and practices?

Answered: 1 week ago

Question

=+designing international assignment C&B packages.

Answered: 1 week ago