Data modelling

Property an attribute that identifies what type data can stored in that attribute

• Entity

• Data type

• Entity occurrence

• Domain

Candidate key used to uniquely identify a single instance

• Alternate key

• Concatenated key

• Candidate key

• Primary key

The number of entities that participate in a relationship is referred to:

• Degree

• Cardinality

• Domain

• Sub setting criteria

Primary key of an entity that is used in another entity to identify instances of a relationship

• Candidate key

• Foreign key

• Concatenated key

• Alternate key

An entity that inherits its primary key from more than one other entity

• Parent entity

• ⦁ Entity occurrence

• Child entity

• Associative entity

Data analysis technique that organises data into groups to form non-redundant, stable, flexible, and adaptive entities

• ⦁ Data analysis

• ⦁ Generalization

• ⦁ Normalization

• ⦁ Data modelling

⦁ Apply 1NF, 2NF,3NF definitions

• ⦁ Normalized data model

• ⦁ Normalized data model

• ⦁ Fully attributed data model

• ⦁ Context data model

⦁ A data model utilizing several notations to depict data in terms of the entities and relationships described by that data

• ⦁ Context diagram

• ⦁ ERD

• ⦁ CRUD matrix

• ⦁ Key based data model

⦁ An entity whose non-primary key attributes are dependent on the full primary key

• ⦁ First normal form

• ⦁ Third normal form

• ⦁ Second normal form

• ⦁ Weak entity

An entity whose attributes have no more than one value for a single instance of that entity

• ⦁ Second normal form

• ⦁ Strong entity

• ⦁ First normal form

• ⦁ Third normal form