DUET44
begin
the process of designing a database for Ms.
Chavez at Move NOW! that will track the
sales by city and by realtor, using the same
data you used in Module 3 shown below.
Murray - Sold 8 liouses in the cities shown
at the prices below:
٠ Denver - 1ه5,ه0ه
٠ Brigliton - 352,٥٥٥
٠ Louisville - 647,٥٥٥
٠ Aurora - 529,00٥
٠ Lakewood - 272,000
٠ Lafayette - 785,٥00
٠ lone Tree - 674,٥٥٥
٠ Broomfie!d - 426,0٥٥
Gu!ed - So!d 4 houses at the fo!!owlng
pdces:
٠ Lous!v!!!e-738,٥0٥
٠ Broomfie!d - 123,800
٠ Aurora - 342,000
٠ Thornton - 569,000
Jones - So!d 5 houses at the fo!!ow!ng
prices:
٠ Aurora - 1,782,072
٠ Denver - 922,000
٠ Broomfield - 728,200
٠ Lakewood - 255,000
٠ Thornton-499,000
Part ٥ne: Database requirements and Inỉtìa!
Post Requirements:
٠ Describe, in detail, the purpose of this
database and its intended use.
٠ Describe what reports you intend to
run using this database.
٠ Describe, in detail, why Access would
be a better soludon than Excel for this
project.
٠ Use Microsoft Word to idendfy the
name of each of the Tables in your
database. Under each Table name, list
the fields contained In the table.
٠ Your database must have at least two
Tables, and should show the
relationship between the two tables.
You should learn a lot in this discussion, as
there will be differing ideas on exactly how
this should be done. I strongly recommend
reading All classmates' posts on this for
better understanding.