Database Schema

Barbara Gerwien
Mind Map by Barbara Gerwien, updated more than 1 year ago
Barbara Gerwien
Created by Barbara Gerwien about 6 years ago
85
0

Description

Understanding SQL

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
          Economics definitions: F582
          busybee112
          Mind Map 1
          matt_daniells
          A Christmas Carol Quotes
          0serenityrose0
          Physics Circuits
          Jaimie Clayton
          Matematica para concursos
          Luiz Ricardo Oliveira
          Salesforce Admin 201 Exam Chunk 5 (126-155)
          Brianne Wright
          GCSE Revision Product Design and Resistant Materials Signage
          T Andrews