INF322 Week 3 Discussion (dq1+dq2)

INF322 Week 3 Discussion  

Dq1

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. Respond to at least two of your classmates’ posting

Dq2

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? Respond to at least two of your classmates’ postings.

Customer Service Database. Show a SQL Query and screenshot your results in a Word document to submit to your instructor. There will be 4 results with explanations required for this assignment.