YOU ARE ADDING A NOTES COLUMN TO A TABLE NAMED CUSTOMERS. YOU ARE...

11. You are adding a Notes column to a table named Customers. You are instructed that the Notes column must always contain a value, even if the value is “No notes available.” Unfortunately, many stored procedures you use to add data to the Customers table omit the Notes column, and it is impractical to redesign the stored procedures. What is the easiest way to ensure that the Notes column in the Customers table always has a value assigned?A. Define the Notes column as NULL. Create a default constraint on the Notes column with the default value of “No notes available.”B. Define the Notes column as NOT NULL. Create a default constraint on the Notes column with the default value of ‘No notes available’.C. Define the Notes column as NOT NULL. Create a check constraint on the Notes column.D. Define the Notes column as NULL. Create a check constraint on the Notes column.