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
|
|
|
Term
|
Definition
|
|
