Flashcards
Database
Cards in this deck (17)
- 1Flat fileAll data is stored in ONE table.
- 20 Normal FileUnnormalized data base aka.Flat File
- 3NormalisationA process used to create relational database with no duplicates
- 4First Normal FormContains no repeating attributes or group attributes
- 5Second Normal FormIn first normal form and contains no partial dependencies
- 6Third Normal FormIn second normal form and contains no-key dependencies
- 7Importance of normalisation-Easier to maintain and change
-No unnecessary duplication
-Faster searches and savings in storage
-Data integrity is maintained - 8Primary KeysIdentity that uniquely define a particular record
- 9Foreign KeysAttribute that joins two relations
- 10Composite primary keyA table that consists 2 primary keys to link two tables
- 11Advantages of Client-server systemConsistency maintained
Resources of powerful computer are available to many people
Access and security centrally
Backup and managed centrally - 12Record lockingRecord locking locks dataabse prevents simultaneous access to objects
- 13Serialisation and time stampRead and write time to prevent data transaction to overlap
- 14Commitement orderingTransactions are ordered according to dependencies and initiation
- 15Agile approachA modern and more flexible approach where constant feedback is given to develop the system
- 16Advantages of agile approachEasier to make changes
- 17—
Information
- Description
- Flashcards on Database, created by Wei Cheng Chang on 15/02/2019.
- Created by
- Wei Cheng Chang
- Views
- 0
- Rating