Designing A Database

In this discussion assignment, you will begin the process of designing a database for Ms. Chavez at Move NOW! that will track the sales by city and by realtor, using similar data to Module 3. The data you’ll use is shown below:

Gutierrez – Sold 6 houses in the cities shown at the prices below:

Aurora – 105,000
Brighton – 352,000
Louisville – 647,000
Littleton – 529,000
Lakewood – 272,000
Lafayette – 785,000

Guled – Sold 4 houses at the following prices:

Erie – 748,000
Broomfield – 133,800
Aurora – 322,000
Sheridan – 569,000
Jones – Sold 5 houses at the following prices:

Aurora – 382,072
Denver – 822,000
Broomfield – 528,200
Lakewood – 455,000
Northglenn – 499,000
Part One: Database requirements and Initial 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 solution than Excel for this project.
Use Microsoft Word to identify 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.

Last Completed Projects

topic title academic level Writer delivered