The relationship (within the relation) that describes how the value of one
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
attribute may be used to find the value of another attribute.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Functional Dependency |\
An attribute that can be used to find the value of another attribute in the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
relation.
Determinant
Value can be used to find the value of every other non-key attribute in the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
table. Unique and minimal.
|\ |\ |\
Candidate Key |\
Define & manage database structures
|\ |\ |\ |\
DDL
Adding, deleting, and modifying data - Manipulates data stored in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
database.
DML
Used to create user accounts, manage permissions and access.
|\ |\ |\ |\ |\ |\ |\ |\
DCL
,Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
|\ |\ |\ |\ |\
DDL
A view created and stored on the database. Underlying data is changed and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
also updated in this view. Uses memory space.
|\ |\ |\ |\ |\ |\ |\
Materialized View |\
Not stored in memory. Only computed when used or accessed.
|\ |\ |\ |\ |\ |\ |\ |\ |\
Virtual View |\
The data about the data. Describes elements such as columns, names, and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
data type. |\
Metadata
Ordered collection of elements in parentheses.
|\ |\ |\ |\ |\
Tuple
% of table rows selected by a query
|\ |\ |\ |\ |\ |\ |\
Hit Ration
|\
Reads blocks directly, without accessing an index.
|\ |\ |\ |\ |\ |\
Table Scan |\
, Reads index blocks sequentially in order to locate the needed table blocks.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Index Scan
|\
Database repeatedly splits the index in two until it finds a match.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Binary Search|\
Database object that maps one or more tables to a single file.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Tablespace
Specifies tables, columns, and keys. Implements database requirements in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
specific database system. Also called a schema.
|\ |\ |\ |\ |\ |\
Logical Design |\
Specifies indexes, table structures, and partitions. Specifies how tables are
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
organized on storage media. |\ |\ |\
Physical Design |\
Components of a computer system and the relationships between
|\ |\ |\ |\ |\ |\ |\ |\ |\
components.
Architecture
Interact directly with database users and administrators and send queries to
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the query processor. Includes Connectors & APIs, Workbench, and utility
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
programs.