Database Schema

Descrição

Understanding SQL
Barbara Gerwien
Mapa Mental por Barbara Gerwien, atualizado more than 1 year ago
Barbara Gerwien
Criado por Barbara Gerwien quase 11 anos atrás
114
0

Resumo de Recurso

Database Schema

Anotações:

  •   šThis is a complete logical view of the database.   
  1. All tables

    Anotações:

    • Relations - All relations are tables but not all tables are relations.
    1. Columns in each table
      1. Primary Key of Each table

        Anotações:

        • Primary Key values must be unique in every row. Also known as the Entity Integrity Constraint
        1. Foreign Keys that link the tables together

          Anotações:

          • Foreign Key - šA column or composite of columns that is the primary key of a table other than the one in which it appears.   

          Semelhante

          Understanding SQL
          Barbara Gerwien
          1.1 Systems Architecture
          Adam Davies
          Architecture Introduction
          Laurence Richardson