Core Database Principles
When embarking on any new project or learning experience, it is essential that you have a strong foundation of understanding constructed from key concepts and parameters. As you begin your work with databases and database design, you should develop a firm understanding of key concepts and parameters that are critical to the foundation of all database design.
In this Discussion, you examine these key fundamental principles of database design.
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 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.