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.
- Review the information in this weeks 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.