कौन सी स्थिति रिलेशनल डेटाबेस डिज़ाइन में डीनॉर्मलाइजेशन (denormalization) की आवश्यकता को सबसे स्पष्ट रूप से इंगित करती है?

Match LIST-I with LIST-II regarding Relational Database Normalization Concepts: LIST-I (Decomposition Concept) A. Lossless Join Behavior B. Lossy Join Behavior C. Dependency Preservation Benefit D. Dependency Preservation Violation Consequence LIST-II (Description / Outcome) I. Spurious (phantom) tuples appear, making the data incorrect. II. Business rules cannot be enforced without expensive cross-table joins. III. Every functional dependency can be enforced within one decomposed table. IV. The original relation is perfectly reconstructed without extra or missing tuples. Choose the correct answer from the options given below:

Match LIST-I with LIST-II based on the strict core conditions and architectural requirements of advanced Normal Forms: LIST-I (Normal Form) A. BCNF B. 4NF C. 5NF D. 3NF LIST-II (Core Architectural Requirement) I. Every non-trivial join dependency requires all components to logically be super keys. II. Every determinant in a non-trivial functional dependency must strictly be a super key. III. No non-prime attribute transitively depends on the primary key through another non-prime attribute. IV. Every non-trivial multivalued dependency requires its left-hand side to be a super key. Choose the correct answer from the options given below: