Overview:

In the Exploration section of this module, you learned about relational databases, including when to use Access vs. Excel. Prior to creating a database, it is necessary to determine the purpose of your database, as well as identify the tables and fields in each table.

Instructions:

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.

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.