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:

For this discussion, we will be discussing what fields and table relationships are needed to create your Module 4 Capstone assignment. Please complete the following actions and supply at least one outside source that you used to help with the concepts of this forum:

What tables and fields are you expecting to develop within your database? Are there any special settings/properties you will put on the fields?

What is going to be the "primary key" for each table?

How are you going to "link" your tables (create a table relationship) to have elements from one talk to the other?

Part One: Database requirements and Initial Post Requirements:

Describe, in detail, how you will address bullet points 1-3 listed above.

Describe, in detail, why Access should be used in this situation (i.e. the difference between a monthly analysis and long-term data recording).

Feel free to utilize Word, PowerPoint, or any program to help you illustrate your concepts as necessary.

Supply at least one outside source that you used to help with the concepts of this forum.

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.