DRAG DROP
You develop a Microsoft SQL Server database. The database contains a table named Level that is defined by the following Transact-SQL statement:
There are thousands of rows in the Level table, with significant duplication of data in the Color column. Seventy-five percent of the rows in the table have Color="Red". Fifteen percent of the rows in the table have Color="Yellow". The remaining ten percent have Color="Green".
You want to normalize the color information in this table. You create a table named Colors that is defined by the following statement:
You populate the new Colors table by using the following Transact-SQL statement:
INSERT Colors (ColorName) SELECT DISTINCT [Color] FROM [Level]
You need to ensure that the following requirements are met:
The Level table uses only colors that exist in the Colors table.
Data redundancy in the Level table is reduced.
Data integrity is enforced during the normalization process.
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Select and Place:
