“Maintaining Data Integrity” Please respond to the following:
- Describe the importance of maintaining integrity rules throughout the database structure. Create at least three examples of common relationships that are used within a relational database system. Justify your response.
- Many times, database designs do not include the proper use of indexes. Provide a specific example on how an index could be used in order to enhance user search experience. List specific fields that you would index. Analyze what would occur if the proper index is not included, with respect to your example.