ICT - Unit 11

?
  • Created by: BethScott
  • Created on: 13-04-15 16:39
View mindmap
  • Unit 11
    • Flat files
      • One or more unrelated tables
      • Record, field and file
        • Unit 11
          • Flat files
            • One or more unrelated tables
            • Record, field and file
              • Simple lists
              • Problems
                • Large amounts of duplicated data
                • Data entry slower
                • Uses disk space
                • Reduced data integrity
                  • Data input errors
                  • Inconsistent data entry
                • Difficult to update
                • Security
                • Program-data dependence
            • 5 main data types
              • Numeric
              • Date
              • Boolean
              • Text
              • Character
            • RDBMS
              • More complex database that stores data in multiple tables that are interrelated
              • Benefits
                • Reduced redundancy
                • Improved data consistency
                • Improved data integrity
                • Better security
                • Program-data independence
              • Primary and secondary key
        • Simple lists
        • Problems
          • Large amounts of duplicated data
          • Data entry slower
          • Uses disk space
          • Reduced data integrity
            • Data input errors
            • Inconsistent data entry
          • Difficult to update
          • Security
          • Program-data dependence
      • 5 main data types
        • Numeric
        • Date
        • Boolean
        • Text
        • Character
      • RDBMS
        • More complex database that stores data in multiple tables that are interrelated
        • Benefits
          • Reduced redundancy
          • Improved data consistency
          • Improved data integrity
          • Better security
          • Program-data independence
        • Primary and secondary key

    Comments

    No comments have yet been made

    Similar ICT resources:

    See all ICT resources »See all Databases resources »