Database Schema

Description

Understanding SQL
Barbara Gerwien
Mind Map by Barbara Gerwien, updated more than 1 year ago
Barbara Gerwien
Created by Barbara Gerwien almost 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
          German- Beginner
          PatrickNoonan
          Pythagorean Theorem Quiz
          Selam H
          Developmental Psychology - Freud, Little Hans (1909)
          Robyn Chamberlain
          The Norman Conquest 1066-1087
          adam.melling
          8 Motivational Quotes for Students
          Andrea Leyden
          SFDC App Builder 1 (176-200ish)
          Connie Woolard