Glossary
[ Skip navigation ] Show: [ all keywords ] [ A–C ] [ D–H ] [ I–N ] [ O–R ] [ S–Z ]
| keyword | definition | page_link |
|---|---|---|
| data definition language (DDL) | (SQL) Statements to create and modify tables and other database objects. | ddldml.php |
| data dictionary | (SQL) System tables that hold information about the structure of the database. | ddldml.php |
| data integrity | (TM) In part, the value entered in each field of a table is consistent with its attribute domain. | domains.php |
| data manipulation language (DML) | (SQL) Statements to work with data in a table. | ddldml.php |
| data types | (SQL) As in programming languages, the data type that an attribute can hold in a table. This is not the same as the attribute's domain. | ddldml.php |
| DELETE | (SQL) Statement to remove some or all rows from a table. | ddldml.php |
| denormalization | (RM) Intentionally "breaking the rules" of normal forms. | normalize.php |
| derived attribute | (UML) An attribute that can be computed from data stored elsewhere in the database. | manymany.php |
| descriptive attribute | (UML) An attribute that provides real-world information, relevant to the enterprise, about the class that we are modeling. | class.php |
| design pattern | (UML) Modeling situations that you will encounter frequently in database design. | manymany.php |
| discriminator attribute | (RM,TM) An attribute that allows us to discriminate between multiple pairings of the same two individuals from each side of a many-to-many association. | loan.php |
| disjoint specialization | (UML) Each member of a superclass may be a member of no more than one subclass | subclass.php |
| DISTINCT | (SQL) Optional clause of the SELECT statement. Use when the SELECT attributes do not form a super key of the FROM clause. | multijoin.php |
| domain | (RM) The set of legal values that may be assigned to an attribute. | class.php |
| domain, enumerated | See enumerated domain. | enum.php |
| DROP CONSTRAINT | (SQL) Optional clause of the ALTER TABLE statement. | ddldml.php |
| DROP TABLE | (SQL) Statement to delete a table and all of its contents. | ddldml.php |
| entity | (ER) See class. | class.php |
| entity-relationship (ER) model | An enterprise modeling tool used in database design. | models.html |
| enumerated domain | (RM) A domain that may be specified by a well-defined, reasonably-sized set of constant values. | enum.php |
| exclusive specialization | (UML) See disjoint specialization. | subclass.php |
| external key | (UML,RM) A surrogate or substitute key that has been defined by an external organization. May be treated as a descriptive attribute in your model. | keys.php |
| FD, partial | See partial FD. | subkeys.php |
| FD, transitive | See transitive FD. | subkeys.php |
| foreign key (FK) | (RM,TM) A set of attributes that is copied from the PK of a parent table into the scheme of a child table. | association.php |
| functional dependency (FD) | (RM) Formal definition of the super key property. | subkeys.php |
| generalization | (UML) (noun) A superclass. (verb) The process of designing superclasses from "bottom up." | subclass.php |
| grant | (SQL) Statement to assign privileges to a user. | ddldml.php |
| HAVING | (SQL) Optional clause that selects aggregated group information in a SELECT statement. | functions.php |
[ Skip navigation ] Show: [ all keywords ] [ A–C ] [ D–H ] [ I–N ] [ O–R ] [ S–Z ]
Copyright © 2002–2006, by Tom Jewett. Links to this site are welcome and encouraged. Individual copies may be printed for non-commercial classroom or personal use; however, this material may not be reposted to other web sites or newsgroups, or included in any printed or electronic publication, whether modified or not, without specific permission from the author.