The Entity Relationship Model''

Defining relationships within a database can improve search capabilities and optional 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''

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 ca be important to measuring performance. GIVE an example on how time-variant data can be property captured and maintained within a database system.