Data Model and designing of data models
Mid Term
Your submission should be an essay of 5-10 pages (double spaced) in total. The material for these questions is found in the text (Chapters 1-5) and/or the lectures (primarily the text).
- What are the advantages and disadvantages of the relational model?
- What is the role of the data model in the database design process?
- Describe a specific challenge in the creation of a data model, and how to potentially overcome it.
- Identify and explain three (3) potential negative outcomes that could result from by an inaccurate data model.
- Identify and explain three (3) potential negative outcomes that could result from failing to understand user data requirements.
- When designing a database, what are the advantages and disadvantages of using a prototype?
- Identify and explain potential advantages and disadvantages of including senior business managers and executives in data modeling exercises.
- Critique an aspect of the text. Identify one (1) topic and/or explanation that could have been improved, in your opinion.
Reference specific pages from the text that support your answers as needed. You may use other external sources as well, but all externally-sourced material must beaccompanied by a footnote.
