This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: component is used for identifying the table(s) involved if >1 table, helps accomplish relational algebra’s join (together with WHERE component that specifies equal fields). SQL’s WHERE component isolates rows (i.e., relational algebra’s select). It also helps accomplish relational algebra’s join and may be left blank for single-table queries that retrieve all rows D2. Query by Example (QBE): The user starts with a sample of the table(s) columns and marks the fields he or she wants to include in the answer. Defaults are available for summarizing and manipulating the data....
View Full Document
This note was uploaded on 12/17/2011 for the course ACCOUNTING 425 taught by Professor Stebbins during the Fall '11 term at Franklin.
- Fall '11