Core Database Principles

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, Database Systems: Design, Implementation, and Management Think of a similar example of how each of these concepts would be reflected in a database design for your own organization.

THEN

Post a brief analysis of the connection between entity relational modeling and relational databases. 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.

References:

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

• Chapter 3, “The Relational Database Model” (review) (pp. 71-106)
• Chapter 4, “The Entity Relationship Model (ERM)” (review) (pp. 117-152)

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
• Chapter 3, “Create Simple Forms” (pp. 91–114)
• Chapter 4, “Display Data” (pp. 115–134)