1/8
Looks like no tags are added yet.
Primary key
Unique identifier for each record in a table
Composite primary key
Combination of fields that is unique for each record
Foreign key
Field in a table that refers to a primary key in another table
Secondary key
Indexed for faster searching
Flat file database
Stores all data in a single table
Relational database
Organises data imto multiple tables with links between them
1NF
Unique field labels, same data type, atomic values, no identical records, primary key
2NF
1NF without partial dependencies - where a non-key field only relies on part of a composite key
3NF
2NF without transitive dependencies - where a non-key field relies on another non-key field