A key field is a piece of data in a database that is unique to a particular record
and example of a key field is in a file for all children in a school a record would have all the data about one particular student like when they join the school if they have medical history
these are needed because if they had the same surname the pupil would have a different file
and example of a key field is in a file for all children in a school a record would have all the data about one particular student like when they join the school if they have medical history
these are needed because if they had the same surname the pupil would have a different file
A relational database it does not store all the data in a single file or table instead the data is stored in several tables with links between them to enable data when the data in the separated tables to be combined together if needed. An advantage is it can put two pieces of data from different tables. A disadvantages is that you have to look at several tables to get the data
A key field / primary key is a unique piece of data in a record also known as a primary key
A flat file database is a database that consists of only on e table
A relational database is a database which consists of more than one table
A flat file database is a database that consists of only on e table
A relational database is a database which consists of more than one table