Please wait - loading…

Computing Topic 5 Databases


Mind Map on Computing Topic 5 Databases, created by Will Darby on 02/11/2016.
Will Darby
Mind Map by Will Darby, updated more than 1 year ago
Will Darby
Created by Will Darby over 6 years ago

Resource summary

Computing Topic 5 Databases
  1. A database is a persistent organised store of data on a computer system
    1. The importance of databases
      1. accurate
        1. up to date
          1. organised
            1. protected from those who should not have access
              1. available to those who need to use them
              2. database administrators need to protect their data against:
                1. errors
                  1. loss
                    1. unauthorised access
                      1. inconsistencies
                        1. insufficient data
                        2. errors in databases can result in:
                          1. financial loss
                            1. life or death situations such as incorrect navigational data for aircraft
                            2. Data security and integrity
                              1. security
                                1. data can be lost because of:
                                  1. an accident
                                    1. flood or fire
                                      1. by an intruder
                                      2. can be protected by:
                                        1. making regular backups
                                          1. restricting data
                                            1. having a mirror database
                                              1. keep audit trails
                                            2. integrity
                                              1. means the data reflects reality
                                                1. can be maximised by:
                                                  1. suitable validation
                                                    1. software preventing inconsistent states
                                                2. Validation and verification
                                                  1. validation - process of checking data when it is input
                                                    1. verification - checking that the data inputted is correct
                                                    2. operations on databases can be listed under CRUD
                                                      1. create
                                                        1. read
                                                          1. update
                                                            1. delete
                                                            2. data matching and mining
                                                              1. matching compares different databases to look for relationships
                                                                1. mining looks in unrelated databases for relationships that were missed
                                                                2. data models
                                                                  1. a model is a data structure that attempts to represent reality
                                                                    1. flat file database - rows and columns
                                                                      1. rows are called records
                                                                        1. columns are called fields
                                                                        2. data redundancy is repetition of data
                                                                          1. hierarchical database
                                                                            1. useful making an inventory
                                                                            2. relational database
                                                                              1. most useful
                                                                                1. most common
                                                                                  1. separate, linked tables
                                                                                    1. each table contains info on one entity
                                                                                      1. info only stored once
                                                                                  2. DBMS
                                                                                    1. database management system
                                                                                      1. software that looks after databases
                                                                                        1. allows administrators to:
                                                                                          1. create database applications
                                                                                            1. protect data
                                                                                              1. keep data consistent and accurate
                                                                                            2. transactions
                                                                                              1. when a change takes place in a database
                                                                                              2. multi-user databases
                                                                                                1. if two users try to modify data, one will fail
                                                                                                  1. record locking - data can only be viewed until other users have finished modifying it
                                                                                                  2. tools provided by DBMSs
                                                                                                    1. tables
                                                                                                      1. structures where data is stored
                                                                                                      2. linking tables
                                                                                                        1. avoids data redundancy
                                                                                                        2. data types (text, number)
                                                                                                          1. forms (UI)
                                                                                                            1. reports
                                                                                                              1. summarise data
                                                                                                              2. queries
                                                                                                                1. module
                                                                                                                Show full summary Hide full summary


                                                                                                                GCSE Biology B2 (OCR)
                                                                                                                Usman Rauf
                                                                                                                C1 Quiz
                                                                                                                Leah Firmstone
                                                                                                                OCR Physics P2 revision cards
                                                                                                                Alex Howard
                                                                                                                B7 Quiz - The Skeleton, Movement and Exercise
                                                                                                                Leah Firmstone
                                                                                                                P2 Quiz
                                                                                                                Leah Firmstone
                                                                                                                GCSE Physics P7 (OCR) - Light, Telescopes, and Images
                                                                                                                Josh Price
                                                                                                                Voices and vocal techniques
                                                                                                                Rosa Brookes
                                                                                                                GCSE Physics P7 (OCR) - Astronomy
                                                                                                                Josh Price
                                                                                                                GCSE Physics P7 (OCR) - Sun, and Stars
                                                                                                                Josh Price
                                                                                                                B7.1-3 - Peak Performance
                                                                                                                GCSE Physics P7 (OCR) - Mapping the Universe
                                                                                                                Josh Price