Difference between revisions of "Homework 6"
From Wikivyuka
m |
|||
| 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 | + | #Database Design - Section 15, Practice Guide Anatomy of a SQL Statement, Try It/Solve It Exercises 2 and 3 |
| + | #Database Design - Section 15, Relational Database Technology , Try It/Solve It Exercises 1, 2 and 7 | ||
| − | + | Use the dot notation. The solution will have the label 1.2, 1.3, 2.1, 2.2 and 2.7. | |
| − | |||
| − | 3 | ||
<hr> | <hr> | ||
| − | + | Specification 1.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.” | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | '''Check it with the learning materials!''' | |
Latest revision as of 20:57, 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
- Database Design - Section 15, Relational Database Technology , Try It/Solve It Exercises 1, 2 and 7
Use the dot notation. The solution will have the label 1.2, 1.3, 2.1, 2.2 and 2.7.
Specification 1.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.”
Check it with the learning materials!
Zpět na stránku Oracle Academy
