Term
|
Definition
| A depiction of a real world object |
|
|
Term
|
Definition
A depiction of a data structure
Often graphical |
|
|
Term
|
Definition
Anything that you can abstract and store data about
Noun |
|
|
Term
|
Definition
| A characteristic of an entity |
|
|
Term
|
Definition
Describes an association among entities
Verb in business rules |
|
|
Term
|
Definition
One to many
Many to many
One to one |
|
|
Term
|
Definition
| A restriction placed on the data |
|
|
Term
|
Definition
| Describe characteristics of data as viewed by the company |
|
|
Term
| The Evolution of Data Models |
|
Definition
Hierarchical
Network
Relational
Entity Relational
Semantic
Object Oriented |
|
|
Term
|
Definition
The first data model
Upside down tree structure
Sequential access not direct access |
|
|
Term
|
Definition
| Records may have more then one parent |
|
|
Term
|
Definition
Table
Consists of row and column intersections |
|
|
Term
|
Definition
Relational Database Management System
Hides the complexities of the relational model from the user
User sees collection of tables
Query language is SQL |
|
|
Term
|
Definition
Relational Diagram
Graphical representation of entities attributes and relationships |
|
|
Term
|
Definition
Entity relationship diagram
Uses graphical representations to model database components |
|
|
Term
|
Definition
Entity occurrence
Row in table |
|
|
Term
|
Definition
| Collection of like entities |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Represent the real world more closely |
|
|
Term
|
Definition
Object Oriented DBMS
Data and relationships are contained in a single structure known as an object
Semantic Modeling |
|
|
Term
|
Definition
| An abstraction of a real world entity |
|
|
Term
|
Definition
Unified Modeling Language
Depict OO data models |
|
|
Term
|
Definition
| The standard protocol for data exchange among systems and internet services |
|
|
Term
| Degrees of Data abstraction |
|
Definition
External
Conceptual
Internal |
|
|
Term
|
Definition
| End users view of the data environment |
|
|
Term
|
Definition
Conceptual Schema
Global view of entire database
Fully labeled diagram
Software independent |
|
|
Term
|
Definition
Representation of the DB as seen by the DBMS
Software dependent
Varies slightly between different systems |
|
|
Term
|
Definition
Describes the way data is stored on disks or tapes
Lowest level of abstraction
Does not require physical level details |
|
|
