Final Answer:
Design base relation schemas so that:
No Redundancy exists in tuples
No Anomalies will occur.
Step-by-step explanation:
Designing base relation schemas with the goal of preventing redundancy and anomalies is crucial for maintaining the integrity and efficiency of a database. Redundancy refers to the unnecessary repetition of data, which can lead to wasted storage space and potential inconsistencies. Anomalies, on the other hand, are irregularities in data manipulation operations, such as insertions, updates, or deletions, that can compromise the accuracy and reliability of the database.
To elaborate, redundancy can arise when the same information is stored in multiple places, making updates difficult and increasing the likelihood of inconsistencies. Anomalies, including insertion, deletion, and update anomalies, can occur when the database schema is not properly designed, leading to unintended consequences during data manipulation. By avoiding redundancy, one ensures that each piece of information is stored in a single location, streamlining updates and reducing the risk of anomalies.
This design principle aligns with the normalization process, which aims to organize data in a way that minimizes redundancy and enhances data integrity. In summary, the choice of (a) Redundancy, Anomalies as the answer underscores the importance of a well-structured database schema to maintain data consistency and accuracy.