Database Vocab (Through Lesson 2.2)

A design for an object (a car, a house, a database, etc.)

which includes implementation details (such as size, volume,

weight, etc.)

• Physical model

• Conceptual model

• Data

• Data modeling

A data model, usually represented by an entity relationship

diagram

• Physical model

• Data modeling

• Logical model

• Data

The planning stage of data modeling where entities are identified and industry laws and regulations are considered.

• Physical Model

• Logical Model

• Data Modeling

• Conceptual model

A collection of facts from which conclusions may be drawn

• Data

• Conceptual Model

• Physical Model

• Logical Model

A collection of facts from which conclusions may be drawn

• Data

• Database

• Data modeling

• Data retreiving

Required

• Attribute

• Nonvolatile

• Mandatory

• Volatile

Incapable of being perceived by the senses; especially by the sense of touch.

• Nontangible/ Intangible

• Volatile

• Nonvolatile

• Tangible

Any combination of attributes and/or relationships that

serves, in all cases, to uniquely identify an instance of an entity

• Datatype

• Attribute

• Unique Identifier (UID)

• Datatype

An occurrence or example of an entity

• Entity

• Datatype

• Attribute

• Instance

A characteristic; something that describes, quantifies, or

specifies an entity

• Datatype

• Attribute

• Entity

• Instance