Term
|
Definition
| a structure that contains different catergories of information and the replationships between these categories. |
|
|
Term
|
Definition
| The process of determining the particular tables and columns that wll comprise a database |
|
|
Term
|
Definition
| is a collection of tables |
|
|
Term
|
Definition
| it is a person, place or thing or event |
|
|
Term
|
Definition
|
|
Term
|
Definition
| is an association between entities |
|
|
Term
|
Definition
| a two dimensional table in which entries in the table are single-valued., each column has a distinct name, all values in the column match the name. |
|
|
Term
|
Definition
when you reference columns.
Examples
REP.REP_NUM |
|
|
Term
|
Definition
when one value is determined by another.
A is functionally dependent of B.
you can also say:
A functionally determines B. |
|
|
Term
|
Definition
the unique identifier for a table
ALSO
a minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows. |
|
|
Term
|
Definition
| identifying potential problems within the database |
|
|
Term
|
Definition
| tables that satisfy the definition of a relation except that they might contain repeating groups. |
|
|
Term
|
Definition
| a table that possesses a certain desirable collection of properties. |
|
|
Term
|
Definition
| tabe that does not contain a repeating group in which multiple entries exist in a single row. |
|
|
Term
|
Definition
| the repetition of data on a table |
|
|
Term
|
Definition
| no nonkey column is dependent on only a portion of the primary key |
|
|
Term
|
Definition
| the only determinates it contains are candidate keys |
|
|
Term
| Entity-Relationship (E-R) Diagram |
|
Definition
| a database diagram where a rectangle represents an entity and an arrow represents a one to many relationship |
|
|
Term
|
Definition
|
|
Term
|
Definition
| is a special value that is used when the actual value for a column is unknown, or not applicable |
|
|
Term
|
Definition
has a form column name, comparison operator (=, >, <) and either another column name or a value
F |
|
|
Term
|
Definition
| Two or more simple conditions connected by an AND, OR, and NOT operators |
|
|
Term
|
Definition
condition that basically says 'not equal'
for example:
SELECT [Description]
FROM [Part]
WHERE NOT ([Warehouse]='3')
; |
|
|
Term
|
Definition
query select values in the range of both values entered. Here's an example:
SELECT [CustomerNum], [CustomerName]
FROM [Customer]
WHERE [Balance]
BETWEEN 2000
AND 5000; |
|
|
Term
|
Definition
a column that does not exist in the database but can be computed usng data in the existing columns.
EXAMPLE:
SELECT [CustomerNum], ([CreditLimit)-[Balance]) AS [AvailableCredit]
FROM [Customer]
; |
|
|
Term
|
Definition
the IN operator is followed by a collection of values.
Example:
SELECT [CustomerNum], [CustomerName]
FROM [Customer]
WHERE [CreditLimit]
IN (5000, 10000, 15000); |
|
|
Term
|
Definition
operator that uses one or more characters to search for a pattern match.
EXAMPLE:
SELECT [CustomerNum], [Street]
FROM [Customer]
WHERE [Street]
LIKE '*Central*'
; |
|
|
Term
|
Definition
clause to list data in specific order
Example
SELECT [CustomerNum], [Balance]
FROM [Customer]
ORDER BY [Balance]; |
|
|
Term
|
Definition
| a function to calculate the number of entries, the sum or average of all entries in a given column or the largest or smallest of the entries in a given column |
|
|
Term
|
Definition
The formal name of a row in a table
(also known as records) |
|
|
Term
|
Definition
Query by Example
A data manipulation language for relational databases in which users indicate the action to be take by completing on-screen forms. |
|
|
Term
|
Definition
The formal name of a column in a table
(also known as attributes) |
|
|
Term
|
Definition
| The Table obtained by concatenating every row in the first table with every row in the second table. |
|
|
Term
|
Definition
| a question, the answer to which is found in a database, also used to refer to a command in a nonprocedural language such as SQL that is used to obtain the answer to such a question. |
|
|
Term
|
Definition
The EXISTS condition is considered "to be met" if the subquery returns at least one row.
Example:
SELECT *
FROM suppliers
WHERE EXISTS
(SELECT *
FROM orders
WHERE suppliers.supplier_id = orders.supplier_id); |
|
|
