the purpose of kilobytes real state information system is to assist agents as th
ID: 3581139 • Letter: T
Question
the purpose of kilobytes real state information system is to assist agents as they sell houses.sellers contact the agency and an agent is assign3d to help the seller complete a request form.
information about the house and lot taken from the form is stored in a computer disk file. personal information about the is cooked by the agent o a sellers personal info sheet and stored in a filing cabinet. when a buyer contacts the agency, he or ahe fills out a buyer request.
every two weeks, he agency send prospective buyers a homes-for-sale magazine and a key for ny he magazine containing street addresses.
periodically, the agent Wil will find a particular house that satisfies most or all of a specific buyers requirements,as indicated in the buyers requirement a report distributed weekly to all agents. the agent will occasionally photocopy a picture of the house along with coral data and send the multiple listing services sheet to the potential buyer.
when the buyer selects a house, he or she fills out a purchase agreement that is forwarded through the real state agency t the seller, who responds with an offer acceptance or a counteroffer. after a purchase agreement has been accepted, the agency sends an apraisal request to an appraiser, who appraises the value of the house and lot. the agency also notifies its finance company with a form
Seller name
Last name
home address
State
Agent name
Last name
Agent ID #
Phone #
House price
Agency name
Buyer name
Last name
Nora
Edwards
1204 bryant Road
New Jersey
Kendra
Bonnickesen
7513
201-915-5487
$ 589,000.00
Rosa Agency, Inc
John
Blogss
Ben
Smith
101 Lake City Way
Maryland
Shannon
McLain
9842
973-703-2133
$ 365,000.00
Century 21
Mark
Brigan
Ajay
Patel
15 New st.
New York
Estela
Pundt
6651
320-446-9138
$ 439,900.00
Di Sabato
Jane
Cooper
Candy
Burnett
76 Taylor st.
Connecticut
Frank
DeSoto
9006
354-703-2133
$ 540,000.00
Mid Realty
Patrick
Bradley
create 3NF Database Normalization
Seller name
Last name
home address
State
Agent name
Last name
Agent ID #
Phone #
House price
Agency name
Buyer name
Last name
Nora
Edwards
1204 bryant Road
New Jersey
Kendra
Bonnickesen
7513
201-915-5487
$ 589,000.00
Rosa Agency, Inc
John
Blogss
Ben
Smith
101 Lake City Way
Maryland
Shannon
McLain
9842
973-703-2133
$ 365,000.00
Century 21
Mark
Brigan
Ajay
Patel
15 New st.
New York
Estela
Pundt
6651
320-446-9138
$ 439,900.00
Di Sabato
Jane
Cooper
Candy
Burnett
76 Taylor st.
Connecticut
Frank
DeSoto
9006
354-703-2133
$ 540,000.00
Mid Realty
Patrick
Bradley
Explanation / Answer
Buyer(Buyer name, last name(unique key combining first name and last name), house price)
Agent(agent name, phone, agent id,last name, agency name, foreign key(combining first name and last name of buyer) ) (unique key combining agency name and agent id)
seller(seller first name, last name,home address,state ,foreign key(combining agency name and agent id))
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.