Instructions: Do not combine topics. Answer each letter separately. All answers must be at least five (5) sentences.Label each answer individually. Include any references.
1)"The Entity Relationship Model" Please respond to the following:
• A) 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.
• B) Using the classifications from part one of this discussion; provide a real word scenario that demonstrates each relationship strength classification.
2) "Preparing an Adequate Data Model" Please respond to the following:
• A) 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.
• B) 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.
3) "Change Control Management" Please respond to the following:
• A) As explained in the text, scope creep is very common in projects. A formal change control management is difficult to enforce and more often overlooked near the end of the project when scope creep is more common. Recommend strategies to enforce change control management. Appraise the advantages of having a change management board integrated by members from different functional teams or departments.