Flashcards
A451: Relational Databases
Cards in this deck (5)
- 1Advantages of a Flat File Database?All records are in one place
Easy to understand
Simple sorting and filtering is easy
Can use a standard Spreadsheet to store it - 2Limitations of Flat File?Potential Duplication
Non-Unique Records
Harder to Update
Inefficient
Almost No Security - 3Advantages of Relational Database?Data's only stored once.
Better Security
Complex Commands can be carried out.
It can cater for future changes - 4What;s the primary key?The field which is unique
- 5What is Data Integrity?The ability to force records to be Consistent
Information
- Description
- Flashcards on A451: Relational Databases, created by Blgr64 on 20/03/2015.
- Created by
- Blgr64
- Views
- 0
- Rating