Copy and Edit

Database

Description

Key Words used in Databse theory
James Louden
Mind Map by James Louden, updated more than 1 year ago
James Louden
Created by James Louden almost 11 years ago
22
0
0

Resource summary

Database
  1. File
    1. Organise Records
    2. Record
      1. Group of Fields
      2. Fields
        1. Text
          1. Numbers
            1. Calculated
              1. Date/Time
                1. Graphic
                2. Flat
                  1. 1 table
                  2. Relational
                    1. Linked tables
                      1. Keys
                        1. Primary
                          1. Unique
                            1. Must have
                            2. Foreign
                              1. links tables relationships
                            3. Avoid Data Duplication
                            4. Search
                              1. Complex
                                1. >1 field
                                2. Simple
                                3. Sort
                                  1. Complex
                                    1. >1 field
                                  2. Validation
                                    1. Presence Check
                                      1. field not blank
                                      2. Restricted Check
                                        1. dropdown box
                                        2. Field length
                                          1. size of field
                                          2. Field Range
                                            1. range of numbers
                                          Show full summary Hide full summary

                                          Want to create your own Mind Maps for free with GoConqr? Learn more.

                                          Similar

                                          FLAT FILE VS RELATIONAL DATABASE
                                          rosiejones
                                          OCR gcse computer science
                                          Jodie Awthinre
                                          GCSE AQA Computer Science - Definitions
                                          James Jolliffe
                                          Managing Digital Data Review
                                          Shannon Anderson-Rush
                                          Midterm 2 (Chapter 5 - 13)
                                          Yorria Raine
                                          SQL Quiz
                                          Chris Cronin
                                          GCSE AQA Computer Science - Definitions
                                          moffat00
                                          Database Final Exam
                                          dbm
                                          Data, Information and Databases
                                          maryamxjay
                                          AS Levels ICT -Form Controls
                                          lukejones
                                          C170 - Practice Test
                                          Craig Willey
                                          Browse Library