1. Engineering
  2. Computer Science
  3. as part of the normalization process we remove redundant and...

Question: as part of the normalization process we remove redundant and...

Question details

As part of the normalization process, we remove redundant and duplicate data from tables and put these into child tables, and establish a relationship between the two tables. The disadvantage of this is that we have combine this information back together to present a complete picture to the end user. What does SQL Server call this operation of combining multiple tables together to present this picture and write a query demonstrating this concept.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution