Application: Relational Databases

To prepare:

• Review the information on relational database models in the course text,Database Systems: Design, Implementation, and Management
• Focus on the key terms listed at the end of Chapter 3.
• Review how to create an entity relationship model.
• Examine the information contained in Figure 3.17 on page 93.

To complete:

• Answer questions 17–22 about database design found on pages 112 in the course text, which refer to Figure 3.17 on page 93.
• Use the available templates for your responses.

References:

1. Coronel, C. & Morris, S. (2017). Database systems: Design, implementation, and management (12th ed.). Boston, MA: Cengage Learning

• Chapter 3, “The Relational Database Model” (pp. 71-106)

  When developing relational databases, tables are used to group related entities. This chapter explores the details behind table creation and utilization.

• Chapter 4, “Entity Relationship (ER) Modeling” (pp. 117-152)

  This chapter describes ER modeling and the benefits it has for its end users. When designing a database, the designer has to consider the relationship between the design plans and the end users’ needs while also ensuring connections between data that will yield accurate information.

2. Cox, J. & Lambert, J. (2013). Step by step: Microsoft Access 2013. Richland, WA: Microsoft Press.

Chapter 1, “Explore Mircosoft Access 2013” (pp. 3–52)

This chapter provides an overview of the skills and capabilities of Microsoft Access 2013. It reviews the concepts of database design and introduces the main components of a database; tables, forms, queries, and reports.

3. Goodwill Community Foundation, Inc. (2010). Access 2010. Retrieved fromhttp://www.gcflearnfree.org/office

4. Pollock, A. (2010). Access 2010 essential training. Retrieved from http://www.lynda.com/Access-2010-tutorials/essenti…