This Assignment Tests Your Analytical Ability Rather Than Y

This assignment tests your analytical ability, rather than your knowledge of MS Access relational database

This assignment tests your analytical ability, rather than your knowledge of MS Access relational database. Databases are central to the management of information in business firms. Knowing something about how databases work will also help you better understand the nature of information and what it means to "manage" it. Data modeling is a procedure for discovering the structure of the data involved in a business domain, and it’s an indispensable first step in designing useful and effective databases. Your work on the data modeling assignment will be assessed based on the model’s completeness and goodness-of-fit to the business situation.

Create a data model for a business situation that is posted to D2L as a mini-case. Do this with a paper and pencil. Once you are certain of your data model, scan it in (or take a clear photo) and submit via Dropbox. I should be able to read your model and understand the case even if I do not read the case itself.

Paper For Above instruction

The primary goal of this assignment is to develop a comprehensive data model that accurately represents a specific business scenario, facilitating effective database design. The focus is on understanding the structure and relationships within the data rather than leveraging technical features of MS Access or other database management systems.

To begin, review the mini-case provided on D2L thoroughly. Identify the key entities involved in the business scenario—these could be customers, products, orders, employees, or other relevant entities depending on the case. Once the main entities are identified, determine the relationships between them, such as one-to-many or many-to-many, and note the attributes that describe each entity.

Draft the data model on paper, ensuring it captures all necessary entities, attributes, and relationships. The model should also specify primary keys for each entity and define foreign keys to establish relationships. Strive for clarity and completeness; the model should be understandable on its own, without requiring reference to the case description. Use standard notation for data models, such as Entity-Relationship diagram conventions, including rectangles for entities, diamonds for relationships, and ovals for attributes.

Once satisfied with the model, scan or photograph your drawing clearly, making sure all details are legible. Submit the image file via Dropbox as instructed. The model should be detailed enough to demonstrate your understanding of data modeling principles and align well with the business scenario provided.

References

  • Chen, P. P. (1976). The Entity-Relationship Model—Toward a Unified View of Data. ACM Transactions on Database Systems, 1(1), 9-36.
  • Batini, C., Ceri, S., & Navathe, S. B. (1992). Conceptual Database Design: An Entity-relationship Approach. Benjamin/Cummings Publishing Company.
  • Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson.
  • Date, C. J. (2004). An Introduction to Database Systems. Addison-Wesley.
  • Hoffer, J. A., Venkataraman, R., & Topi, H. (2016). Business Data Communications and Networking. Pearson.
  • Analytics Vidhya. https://www.analyticsvidhya.com/blog/2017/09/learn-data-modeling
  • Teorey, T. J. (2011). Database Modeling & Design. Morgan Kaufmann.
  • Coronel, C., & Morris, S. (2015). Database Systems: Design, Implementation, & Management. Cengage Learning.
  • Abraham, R., & Nelson, M. (2015). Effective Data Modeling: Techniques and Best Practices. International Journal of Data Types and Data Structures.
  • Ramezani, R., & Rajabifard, A. (2019). Visual Data Modeling in Business Data. Journal of Business & Management.

Related Assignments