Flashcards
A451: Relational Databases
Flashcards do conjunto (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
Informações
- Descrição
- FlashCards sobre A451: Relational Databases, criado por Blgr64 em 20-03-2015.
- Criado por
- Blgr64
- Visualizações
- 0
- Avaliação