You are testing a database schema for an e-commerce platform. During your test, you discover that some tables have redundant data and duplicate entries. What type of issue have you identified, and what should be the next step to address it?
- Data Consistency; Implement unique constraints to prevent duplicate entries
- Data Integrity; Apply foreign key constraints to establish relationships between tables
- Data Redundancy; Normalize the database tables to remove redundant data
- Data Security; Encrypt the redundant data to prevent unauthorized access
This scenario indicates a problem with data redundancy, which can lead to inefficiency and inconsistency in the database. The next step should involve normalizing the database tables to remove redundant data and ensure data integrity, thus optimizing database performance and reducing storage requirements.
Loading...
Related Quiz
- ETL testing involves verifying data accuracy, completeness, and ____________.
- In SQL, the "ROLLBACK" statement is used to ____________ a transaction and undo its changes.
- Advanced test data generation tools often incorporate _________ algorithms to generate complex and realistic data scenarios.
- How can database testing tools like SQLUnit help in ensuring data consistency during testing?
- Which testing technique is used to evaluate the performance of a database under heavy loads?