Database Schema

Description

Understanding SQL
Barbara Gerwien
Mind Map by Barbara Gerwien, updated more than 1 year ago
Barbara Gerwien
Created by Barbara Gerwien about 9 years ago
100
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

          Similar

          Understanding SQL
          Barbara Gerwien
          1.1 Systems Architecture
          Adam Davies
          Architecture Introduction
          Laurence Richardson
          Systems Architecture 101
          Chris Lee
          1.1 Systems Architecture
          Archie Fisher
          Korean Grammar Syllabus
          Dxoxo
          GERMAN V&OCAB - FAMILY, OPINIONS & TIME PHRASES
          plummerzoe123
          Summary of AS Psychology Unit 1 Memory
          Asterisked
          Perimeter Check-up
          whitbyd
          GCSE AQA Biology 2 Genetics
          Lilac Potato
          DNA Basics
          Sarah Juliette B