ITM 100 Midterm Review - Week 5
Exam Questions with Correct
Answers
Foreign Key - Answer-A field that links one table to another. Example: Customer ID in
the Orders table.
Data Redundancy - Answer-Having the same data stored in more than one place.
Example: An email address in two spreadsheets.
Integrity Constraint - Answer-Rules that keep data accurate and valid. Example: You
can't create an order for a customer who doesn't exist.
Scalability - Answer-A system's ability to handle more users or data without problems.
Example: A site that stays fast when more people join. Extra: Databases must adapt as
businesses grow.
Performance - Answer-How quickly a system processes information. Example: A report
loading in seconds. Extra: Good performance = fast, smooth operations.
Data Security - Answer-Protecting data from unauthorized access or loss. Example:
Password-protected databases. Extra: Data is a company asset that must be protected.
Business Intelligence (BI) - Answer-Using data to make better business decisions.
Example: Analyzing sales trends to plan future products. Extra: Turns data into useful
insights for managers.
Data Aggregation - Answer-Collecting data from many sources into one place. Example:
Combining reports from all store branches. Extra: Gives a complete view of business
activity.
Collaborative Filtering - Answer-Recommending things based on what similar users
liked. Example: "People who bought this also bought ..." Extra: Used by sites to
personalize suggestions.
Recommendation Engine - Answer-A program that suggests things based on your
activity. Example: Netflix recommending movies. Extra: Uses data mining and past
behavior.
Exam Questions with Correct
Answers
Foreign Key - Answer-A field that links one table to another. Example: Customer ID in
the Orders table.
Data Redundancy - Answer-Having the same data stored in more than one place.
Example: An email address in two spreadsheets.
Integrity Constraint - Answer-Rules that keep data accurate and valid. Example: You
can't create an order for a customer who doesn't exist.
Scalability - Answer-A system's ability to handle more users or data without problems.
Example: A site that stays fast when more people join. Extra: Databases must adapt as
businesses grow.
Performance - Answer-How quickly a system processes information. Example: A report
loading in seconds. Extra: Good performance = fast, smooth operations.
Data Security - Answer-Protecting data from unauthorized access or loss. Example:
Password-protected databases. Extra: Data is a company asset that must be protected.
Business Intelligence (BI) - Answer-Using data to make better business decisions.
Example: Analyzing sales trends to plan future products. Extra: Turns data into useful
insights for managers.
Data Aggregation - Answer-Collecting data from many sources into one place. Example:
Combining reports from all store branches. Extra: Gives a complete view of business
activity.
Collaborative Filtering - Answer-Recommending things based on what similar users
liked. Example: "People who bought this also bought ..." Extra: Used by sites to
personalize suggestions.
Recommendation Engine - Answer-A program that suggests things based on your
activity. Example: Netflix recommending movies. Extra: Uses data mining and past
behavior.
