Using the data from Table 7-2, you need to create a view that allows users to add new employees. You want them to be able to add all the information except the pay rate. What changes do you need to make to the table to accomplish this?

Using the data from Table 7-2, you need to create a view that allows users to add new employees. You want them to be able to add all the information except the pay rate. What changes do you need to make to the table to accomplish this?

Using the data from Table 7-2, you need to create a view that allows users to add new employees. You want them to be able to add all the information except the pay rate. What changes do you need to make to the table to accomplish this?


Answer – Do nothing; the table is fine as is.

(To create an updateable view that will allow users to insert new records with everything except the Pay column, you do not need to make any changes because the Pay column is nullable; therefore, your users do not have to insert a value in the Pay column when inserting a new record.)