August 2002
Intermediate to advanced
528 pages
10h 12m
English
| 1: | A user you support is in need of a mailing list. The names of the employees on the list must be formatted with each employee’s title. Precede female-employee names with Ms. Precede male-employee names with Mr. This type of data does not exist in the database. You have been asked to create a database view that contains this feature. |
| 2: | Create a view that displays employee records and wages for the WEL department. Put a check option on the view. Using the view, change the department number to INT for employees living in plains. (You should not be able to update the record.) |