Relational Model vs. Transnational Model

Relational Models

  • Allows for easy querying and data manipulation in an easy, logical and intuitive way.

Transactioanl Model

  • Operational database

Data Model Building Blocks

Entity

  • Person, place, things or even that are distinguishable, unique and distinct.

Attributes

  • A characteristic of an entity

Relationship

  • Describes association among entities
    • One to Many
    • Many to Many
    • One to One

Primary key and Foreign Key

Primary Key

  • A column (or set of columns) whose values uniquely identify every row in a table.

Foreign Key

  • One or more columns that can be used together to identify a signle row in another table.