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. The sales 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?()
- ADefine the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
- BDefine the new column as NOT NULL with a default value of ’Undefined.’
- CDefine the new column as NULL. Use application logic to enforce the data constraint.
- DDefine the new column as NULL with a default value of ’Undefined.&rsquo