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.
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. Prepare an example on how time-variant data can be properly captured and maintained within a database system.