• 
• 
• 

Terms Summary

ENTITY ROLE MODELLING

Entity:-

A uniquely identifiable object of important from a top level perspective of an organisation or business model.

Entity Occurrence:-

A single instance of an entity.

Attribute:-

An identified element within an entity

NORMALISATION

Relation:-

A bottom up view of a design concept of a realisation of a potential database table taken from the movement of information within an organisation or business model

Tuple:-

An ordered finite set of values of a relation.

Domain:-

Defines the constraint and type of a single value element of a relation.

RDBMS

Table:-

A table is the conceptual view of the database’s internal structure in the context of the 3 layer model.

Record/Row:-

A row/record is a set of related data values of a common item.

Column:-

A column is a data value of a particular item type.