August 2002
Intermediate to advanced
528 pages
10h 12m
English
(You may use the table relationship diagram in Figure 1.11 with these questions.)
| 1: | Identify the tables to which you have access. |
| 2: | Identify the name of the columns in the Employee table. |
| 3: | Retrieve the employee department, last name, first name, and current position. |
| 4: | Retrieve the same columns as those in question 3, but combine the Last Name and First Name columns. Preface each name with Mr. |
| 5: | Compute the future wages for each employee if he or she receives a 6-percent raise, a bonus of $2,300, and a deduction of $250 for charity. |
| 6: | Retrieve all of the employees in the database, and display their first and last names. Order the employees by department. |
| 7: | Retrieve all of the employees in the database, and display their first and ... |