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)