Chapter 5

Description

ICT Mind Map on Chapter 5, created by green.george on 10/04/2013.
green.george
Mind Map by green.george, updated more than 1 year ago
green.george
Created by green.george over 12 years ago
91
0
1 2 3 4 5 (0)

Resource summary

Chapter 5
  1. Database components
    1. Table - data structured into rows and columns requires a primary key
      1. Records - a single row within a table made up of individual fields
        1. Field - An individual data item within a record
          1. Key - a field used for identification
            1. Primary - allows a record to be uniquely identified. Can be combined to make a composite key
              1. Secondary - a field which can be used to index data
                1. Foreign key - a field which is linked to the primary key in another table or entity
                2. Entity - A Thing which can be identified, a logical or physical storage unit
                3. Relationships
                  1. One-to-one
                    1. One instance of X to one instance of Y
                      1. Uncommon
                      2. One-to-many
                        1. Common
                          1. One instance of X relates to many instances of Y
                          2. Many-to-many
                            1. Foreign key on many side and primary on the one
                              1. Many instances of X relate to many instances of Y
                            2. Normalisation
                              1. 1NF
                                1. Primary key
                                  1. Unique field names
                                    1. no repeating fields
                                      1. Atomic fields
                                      2. 3NF
                                        1. All 2NF conditions met
                                          1. All non-key fields are dependent on the primary key
                                          2. 2NF
                                            1. All 1NF conditions met
                                              1. All of the non-key attributes can be found using the primary key
                                            2. Data dictionary
                                              1. Defines aspects of a database
                                                1. e.g. Table name Keys Relationships
                                                2. Queries
                                                  1. Static - Predefined parameters
                                                    1. Dynamic - Parameter input on each run
                                                      1. Simple - Only one parameter
                                                        1. Complex - multiple parameters
                                                          1. AND
                                                            1. OR
                                                              1. NOT
                                                                1. *xyx*
                                                                  1. x* (starts)
                                                                    1. *x (ends)
                                                                      1. Standard mathematical operators
                                                                    Show full summary Hide full summary

                                                                    0 comments

                                                                    There are no comments, be the first and leave one below:

                                                                    Similar

                                                                    Input Devices
                                                                    Jess Peason
                                                                    Output Devices
                                                                    Jess Peason
                                                                    Networks
                                                                    Will8324
                                                                    General ICT Quiz
                                                                    leahshaw
                                                                    ICT Revison Flash Cards
                                                                    Arun Johal
                                                                    FLAT FILE VS RELATIONAL DATABASE
                                                                    rosiejones
                                                                    Online World - Learning Aim A
                                                                    andysedge
                                                                    Business Aims and ICT Strategies
                                                                    scrt
                                                                    User Interfaces
                                                                    Skeletor
                                                                    General ICT Quiz
                                                                    Jade Fantom