Difference between revisions of "Homework 6"
| Line 1: | Line 1: | ||
Complete the homework assignments listed below. Note all Practice Guides are located in Section 0 - Database Design Course Resources. | Complete the homework assignments listed below. Note all Practice Guides are located in Section 0 - Database Design Course Resources. | ||
| + | |||
| + | Database Design - Section 15, Practice Guide Anatomy of a SQL Statement, Try It/Solve It Exercises 2 and 3 | ||
| + | |||
| + | 2. Write a query that displays the last_name and email addresses for all the people in the DJ on Demand d_client table. The column headings should appear as “Client” and “Email Address.” | ||
| + | |||
| + | 3. The manager of Global Fast Foods decided to give all employees at 5%/hour raise + a $.50 bonus/hour. However, when he looked at the results, he couldn't figure out why the new raises were not as he predicted. Ms. Doe should have a new salary of $7.59, Mr. Miller's salary should be $11.00, and Monique Tuttle should be $63.50. He used the following query. What should he have done? | ||
| + | |||
| + | <hr> | ||
| + | |||
| + | Database Design - Section 15, Relational Database Technology , Try It/Solve It Exercises 1, 2 and 7 | ||
| + | |||
| + | 1. The Global Fast Foods database consists of how many tables? ____ tables | ||
| + | |||
| + | 2. How is the F_SHIFTS table related to the F_STAFFS table? | ||
| + | |||
| + | 7. Which table(s) contains null values? | ||
Revision as of 13:49, 23 November 2010
Complete the homework assignments listed below. Note all Practice Guides are located in Section 0 - Database Design Course Resources.
Database Design - Section 15, Practice Guide Anatomy of a SQL Statement, Try It/Solve It Exercises 2 and 3
2. Write a query that displays the last_name and email addresses for all the people in the DJ on Demand d_client table. The column headings should appear as “Client” and “Email Address.”
3. The manager of Global Fast Foods decided to give all employees at 5%/hour raise + a $.50 bonus/hour. However, when he looked at the results, he couldn't figure out why the new raises were not as he predicted. Ms. Doe should have a new salary of $7.59, Mr. Miller's salary should be $11.00, and Monique Tuttle should be $63.50. He used the following query. What should he have done?
Database Design - Section 15, Relational Database Technology , Try It/Solve It Exercises 1, 2 and 7
1. The Global Fast Foods database consists of how many tables? ____ tables
2. How is the F_SHIFTS table related to the F_STAFFS table?
7. Which table(s) contains null values?
Zpět na stránku Oracle Academy
