You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. Thesales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（） A: Define the new column as NUL B: Update the FriendlyName column to the same valueas the productName column. Alter the FriendlyName column to be NOT NUL C: D: Define the new column as NOT NULL with a default value of ’Undefined.’ E: Define the new column as NUL F:  Use application logic to enforce the data constraint. G: Define the new column as NULL with a default value of ’Undefined.’