Everyone has had some experience with data

Everyone has had some experience with data

Everyone has had some experience with data. Even if you are new to the Database world you have this experience since your personal information is data in many places. List an example of a database and how you interact with that database. One example might be as a customer receiving monthly bills. Another example might be your personal information collected at a medical office.

WRITE THIS ESSAY FOR ME

Tell us about your assignment and we will find the best writer for your paper.

Get Help Now!

Question 2

Running Access

If you have not already done so, install Microsoft Access (this is a free 30-day trial for Office 365 Home Premium). In the response to this forum, note that you have successfully installed the product and what you experienced in the install and as you first opened the tool. We will all start with a sample database to get familiar with Access in Week 2. If you have any issues or unexpected results, this is a great place to share your experience.

Databases are installed to help solve problems, improve processes, or provide a benefit to the organization. Do you have a scenario that you can share where you believe a Database helped/could help improve a process at your work or at another organization with which you are familiar? It can be for a new application or to replace an existing application or process. Respond to at least two of your classmates’ postings.

Question 4

Interviewing the Users

This week’s reading contained a section on interviewing the users. Why is this process important? Think about who uses the tool, what they use it for, and what is important for them to get the job done. Have you ever been involved in any of these types of interviews? If so, share your experience.

Question 5

Keys

Why is a Key important in a database? How does it help with Referential Integrity? Chapter 8 lists three compelling reasons why Keys are crucial to table structure. There is an example of a table and its’ key in Figure 8.2.

Question 6

Determining System Requirements

Identify the database or process you would like to begin to think about for your future database design. After you have developed a database idea, you need to plan the interviewing of your users. Interviewing will give you a better understanding of user needs, wants, and desires, as well as help you to determine your system requirements. What questions should you ask? How do you think this will help you in determining your table and field requirements? When do you think it would be important to make these decisions?

Question 7

Table Relationships