Homework 6
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
