✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
A university database uses a normalised schema with separate Students, Majors, and Departments tables. A report query joins all three tables. The IT department proposes denormalising by copying the major name and department building directly into the Students table. Which statement correctly describes the trade-off?