Term
|
Definition
| a self describing collection of integrated records |
|
|
Term
|
Definition
| also called rows…groups of columns in a database table |
|
|
Term
|
Definition
| characteristics of an entity…for example: attributes of an order would be order number, order date, sub total, taxes, total, etc. |
|
|
Term
|
Definition
| the more formal name for a database table |
|
|
Term
| Entity-relationship Diagram |
|
Definition
| a type of diagram used by database designers to document entities and their relationships to each other. |
|
|
Term
| Entity-relationship Data model |
|
Definition
| the most popular technique for creating a data model. Developers describe the content of a database by defining the entities that will be stored and the relationships among those entities |
|
|
Term
| Database Management System (DBMS) |
|
Definition
| a program used to create, process, and administer a database |
|
|
Term
| Knowledge Management System (KMS) |
|
Definition
| an information system for storing and retrieving informational knowledge, whether that knowledge is in the form of data, documents, or employee know-how. |
|
|
Term
|
Definition
| a popular open-source DBMS product that is license free for most applications |
|
|
Term
|
Definition
| a popular enterprise-class DBMS product from microsoft |
|
|
Term
|
Definition
| a popular enterprise-class DBMS product form Oracle Corp. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Maximum cardinalities. 1:N- one to many. 1:1- one to one. N:M- many to many. |
|
|
Term
|
Definition
| Key- a column or group of columns that identifies a unique row in a table. |
|
|
Term
|
Definition
| the process of converting poorly structured tables into two or more well-structured tables |
|
|
