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
102
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
          FCE Practice Quiz - B2
          miminoma
          How Parliament Makes Laws
          harryloftus505
          Mind Maps with GoConqr
          Manikandan Achan
          AQA GCSE Physics Unit 2
          Gabi Germain
          PSBD TEST # 3
          yog thapa
          Functionalist Theory of Crime
          A M