CIS 515 Discussion Questions 1and 2

“Maintaining Data Integrity” Please respond to the following:

• Many times, database designs do not include the proper use of integrity rules and indexes. Provide a specific example where correcting such an omission would enhance data integrity and database performance.
• Enumerate the specific fields to index, or integrity constraint to add.
• Analyze what would occur without this change.

“Aggregate Queries” Please respond to the following:

• Suppose you are an IT professional to support database reporting functionality for a Human Resources system. Compose one aggregate function query that would allow executives of the organization to extract useful summary data from a database system.
• Demonstrate how an aggregate function would help the organization understand employee performance and leverage talent within the organization.