To prepare:  

  • Review the information in this week’s Learning Resources concerning relational and entity relational databases. Focus on how the two are interconnected.
  • Review information concerning cardinalities and consider what they are, how they are developed, and their role in database design.
  • Review information concerning business rules, what they represent, and how they are reflected in the entity relationship diagrams.
  • Review the conceptual model (Figure Q4.5) on page 150 of your text,  Coronel, C. & Morris, S. (2015). Database systems: Design, implementation, and management (11th ed.). Stamford, CT: Cengage Learning. Think of a similar example of how each of these concepts would be reflected in a database design for your own organization. Post by tomorrow 6/28/2016 550 words in APA format with 3 references 1) A brief analysis of the connection between entity relational modeling and relational databases. 2) Discuss a brief example of a conceptual model that could be used in your own organization and list at least one business rule and two cardinalities that apply to that model. Required Resources
 
  • Coronel, C. & Morris, S. (2015). Database systems: Design, implementation, and management (11th ed.). Stamford, CT: Cengage Learning.
 
    • Chapter 3, “The Relational Database Model” (review) (pp. 70–113)
    • Chapter 4, “The Entity Relationship Model (ERM)” (review) (pp. 115–160)
  • Cox, J. & Lambert, J. (2013). Step by step: Microsoft Access 2013. Richland, WA: Microsoft Press..
 
    • Chapter 2, “Creating Databases and Simple Tables” (pp. 53–90) In this chapter, the authors demonstrate how to create databases both from templates and manually, how to construct a table structure, and how to define the relationship between tables.
    • Chapter 3, “Create Simple Forms” (pp. 91–114) The focus of this chapter is creating forms, which enables standardized data to be entered into a database. The authors demonstrate how to create, format and customize the layout of forms.
    • Chapter 4, “Display Data” (pp. 115–134) This chapter concentrates on sorting and filtering information within a database in order to locate and display desired information. It begins with simple sorts and progresses through displaying information that matches specific, multiple criteria.
  Optional Resources   There are a wide variety of online tutorials available to assist with using Microsoft Access. Below are several you might consider, as needed:  
  • Goodwill Community Foundation, Inc. (2010). Access 2010. Retrieved from http://www.gcflearnfree.org/office This free resource provides a series of lessons, interactives, and video tutorials to assist in learning how to in the use Access 2010.
         ]]>

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Leave a Reply