Flat file database
Relational database
Data redundancy
Data inconsistency
Advantages of flat file databases
Advantages of relational databases
Disadvantages of relational databases
- Requires a good DBMS to control efficient views of data
Entity
Relationship
Normalisation
First Normal Form (1NF)
Second Normal Form (2NF)
- Non-key attributes are dependent on all of the primary key
Third Normal Form (3NF)
- No non-key attributes can be dependent on another non-key attribute
Primary key
- Referred to as a composite key when comprised of multiple fields
Composite key
Foreign key
Where foreign keys are always found
Secondary key
- They are indexed which allows for fast searching of data
Database Management System (DBMS)
Tasks performed by the DBMS
Access rights
- Controls what each user is able to do with data (view, update etc)
Data dictionary
Data contained within the data dictionary
Data Definition Language