Question 1 of 30
In a relational database, a company is analyzing its customer data to improve its marketing strategies. The current database structure has a single table that includes customer ID, customer name, purchase history, and customer feedback. However, the marketing team has noticed redundancy in the data, particularly with customer feedback being repeated for multiple purchases. To enhance data integrity and reduce redundancy, the database administrator decides to apply normalization techniques. What is the most appropriate first step in the normalization process for this scenario?
Decompose the table into separate tables for customers and feedback, establishing a one-to-many relationship.
Create a single table that includes all customer information and feedback without any changes.
Merge the purchase history and customer feedback into one table to simplify data retrieval.
Add additional columns to the existing table to capture more detailed customer feedback.

Preparing for Microsoft 98-361 Software Development Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free