| A | B |
|---|
| Row | An entry in a table, consisting of values for each appropriate column. (an instance) |
| Join | Display data from two or more related tables. |
| Application software | Program that gives a computer instructions that provide the user with tools to accomplish a task. e.g. Word Processor, Page Layout, Spreadsheet, etc. |
| Primary key | The set of mandatory columns within a table that is used to enforce uniqueness of rows, and that is normally the most frequent means by which rows are accessed. |
| Operator precedence | Rules that determine the order expressions are evaluated and calculated. |
| Career portfolio | The materials representative of a person's work. |
| Arithmetic operator | A symbol used to perform an operation on some values. |
| Table | An arrangement of data in rows and columns. An entity is mapped to this. |
| Foreign key | A column or set of columns that refers to a primary key in the same table or another table. |
| Column | An implementation of an attribute or relationship in a table. |
| Grid computing | A global effort to develop an environment in which individual users can access computers, databases and experimental facilities simply and transparently, without having to consider where those facilities are located. |
| Projection | The capability in SQL to choose the columns in a table that you want returned from a query. |
| NULL | A value that is unavailable, unassigned, unknown, or inapplicable. |
| Column alias | Renames a column heading. |
| Relational database | Collections of objects or relations, set of operators to act on those relations, and data integrity for accuracy and consistency. |
| Arithmetic expression | A mathematical equation. |
| Selection | The capability in SQL to choose the rows in a table returned from a query. |
| Field | Intersection of a row and column. |
| Statement | A combination of two or more clauses. |
| Clause | A phrase in a SQL statement, a part. |
| Select statement | Complete SQL code that retrieves information from a database. and contains two or more clauses. |
| FROM clause | Phrase of SQL code that specifies the table containing the column(s) listed in the select clause |
| SELECT clause | Phrase of SQL code that specified the columns of data to be displayed (does that selection). |
| Data Manipulation language (DML) | Category of SQL language used to modify the table by entering, changing, or removing row(s). |
| Data definition language (DDL) | Category of SQL used to crate, change and remove data structures from the database. |
