DataBases
DataBase storage types
Flat File Database
Advantages
Disadvantages
Relational DataBase
Advantages
Disadvantages
Data Types
Unique Identifier
Text
Number
Boolean
Date/Time
Currency
Relationship types
One to one
One to Many
Many to Many
Flat File Database
This DataBase type makes use of a single file to store all data entered.
Advantages
> Fast to set up> all in one place
Disadvantages
> Data will be repeated> Information can be incorrectly entered> single use> Hard to understand
Relational DataBase
makes use of multipule files, and linked together using relationship Keys
Advantages
> easy to find Data> Data is hard to repeat>
Disadvantages
Unique Identifier
The unique number given to each Record in the File
Text
Can enter a number, or characters (this includes Special Characters)
Number
The user can only enter a number (if the number starts with a "0" the Zero is removed, if the number starts with a zero it is best to use Text instead.
Boolean
The only data that can be stored here is YES or NO
Date/Time
Only Date or time can be entered into this data type
Currency
Data is stored in a curtain format so is shown properly
One to one
One to Many
Many to Many