EECS 1520 Chapter Notes - Chapter 12: Query Language, Pattern Matching, Database Engine

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: Roger Lew

Document Summary

Spreadsheet formulas: formulas in many spreadsheet programs begin within an equal sign (=, that"s how the spreadsheet knows which cells contain formulas that must be evaluated, spreadsheet function can be incorporated into formulas (e. g. the sum function) [type text: a spreadsheet program usually provides a large number functions that we can use in formulas, some perform math for statistical calculations, common financial calculations, or special operations on text or dates, circular reference other to compute their results. Queries: the select clause determines which attributes are returned, the form clause determines which tables are used in the query, the where clause was shirked the data that is returned, the where clause can be eliminated if no special restrictions are necessary, an asterisk (*) can be used in the select clause to denote that all attributes in the selected records should be returned, the like operator in sql performs some simple pattern matching on strings, the % symbol matches any string.