IS582Week5OutOfClassAssignment[1]

- IS582 Week 5 Out-of-class Assignment As noted in class I stress the importance of using your own words Quotes are fine but also make sure to

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
IS582 Week 5 Out-of-class Assignment As noted in class, I stress the importance of using your own words. Quotes are fine, but also make sure to explain in your own words. On this assignment, please answer the first two questions and at least one of the remaining three – three questions in all. 1. Briefly describe what a subquery is and how it works. Then offer an example which we might use with one of the databases we use in class. Subqueries involve nesting one SELECT statement within another. The nested SELECT is used as part of a condition in the WHERE clause of the first SELECT statement. The nested SELECT statement can return a set of records from one table, which is then used in a logical operator within the parent SELECT query. SELECT Student_ID FROM Student WHERE Student_ID IN (SELECT Student_ID FROM ) 2. Briefly describe what a join is and how it works. Then offer an example which we might use with one of the databases we use in class .
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/07/2011 for the course KELLER IS517 taught by Professor Lewis during the Spring '11 term at DeVry Columbus North.

Page1 / 3

- IS582 Week 5 Out-of-class Assignment As noted in class I stress the importance of using your own words Quotes are fine but also make sure to

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online