Database Schema

Description

Understanding SQL
Barbara Gerwien
Mind Map by Barbara Gerwien, updated more than 1 year ago
Barbara Gerwien
Created by Barbara Gerwien over 9 years ago
103
0
1 2 3 4 5 (0)

Resource summary

Database Schema

Annotations:

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

    Annotations:

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

        Annotations:

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

          Annotations:

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

          0 comments

          There are no comments, be the first and leave one below:

          Similar

          1.1 Systems Architecture
          Adam Davies
          Architecture Introduction
          Laurence Richardson
          Systems Architecture 101
          Chris Lee
          1.1 Systems Architecture
          Archie Fisher
          Physics Revision
          Tom Mitchell
          IGCSE Physics formulas
          Imani :D
          Mapa Conceptual de Liderazgo
          gabbi.mendoza
          Edexcel Additional Science Chemistry Topics 1+2
          hchen8nrd
          Teaching Methods Every Educator Should Know
          Micheal Heffernan
          Basic Korean Verbs
          ASHISH AWALGAONKAR