Digital Technology 1.1: Relational Databases

?
  • Created by: _dickson7
  • Created on: 03-10-17 09:43
View mindmap
  • 1.1 Relational Databases
    • Flat File:
      • "A databse held in a single file/table with a simple structuring of data which is not linked to another table."
      • Problems
        • Data Redundancy
          • "This occurs when non-key data is held more than once in the database."
        • Data Inconsistency
          • "An attribute/field stored more than once does not have the same value throughout."
    • Relation Database:
      • Advantages
        • Data Independence
          • "Data structure is separate entity from the software."
        • Data Consistency
          • "A particular attribute has only one value at a particular time throughout."
        • No Redundant Data
          • "The data is not stored several times in separate files."
        • Data Integrity
          • "The accuracy/reliability or completeness of data held."
      • "A databse that holds its data over a number of tables instead of one. Records are linked to records in other tables."
    • DBMS:
      • Program- Data Dependence
      • Security easier to enforce

Comments

No comments have yet been made

Similar ICT resources:

INFO3/4
See all ICT resources »See all Databases resources »