Envisioning a Database Design

 For this Discussion, you reflect on a selected scenario and consider the database design that you would employ in that scenario.

To prepare:
  • Select one of the scenarios from those that your Instructor has posted.
  • Review the Learning Resources.
  • Consider a database design that you might use to collect and/or convert the data to an electronic format.
  • Review the lists and tables throughout the assigned readings and model them for listing your tables.
By Day 3 of Week 3

Post a list of the tables including the fields (rows) that you would include in each table to convert the data from the scenario you selected into a database. Be specific. Explain the rationale for your decision and support your decision with citations from this week’s Learning Resources. Describe the benefits of converting the data from paper to electronic form and explain why. Be specific and provide examples.

Harrington, J. (2016). Relational database design and implementation (4th ed.). Cambridge, MA: Morgan Kaufmann.
Chapter 3, “Why Good Design Matters” (pp. 47–54)
Chapter 4, “Entities and Relationships” (pp. 55–88)

Patrician, P. A., Loan, L., McCarthy, M., Brosch, L. R., & Davey, K. S. (2010). Towards evidence‐based management: Creating an informative database of nursing‐sensitive indicators. Journal of Nursing Scholarship, 42(4), 358–366.