"The Entity Relationship Model" Please respond to the following:
- Defining relationships within a database can improve search capabilities and optimal performance of the database in the long run. Identify at least two relationship strength types that can be used within the entity relationship model.
- Using the classifications from part one of this discussion; provide a real word scenario that demonstrates each relationship strength classification.
"Preparing an Adequate Data Model" Please respond to the following:
- Using specialization hierarchies can provide an efficient application development structure. Justify the use of surrogate primary keys for a database design. Provide an example to support your response.
- Historical data can be important to measuring performance. Give an example on how time-variant data can be properly captured and maintained within a database system.