1. A key field is a piece of data in a database that is unique to a particular record
2. An example of a key filed is a pupil number at a school
3. To make sure that it is unique and is only allocated to them
4. A flatfile database only contain one table and are only for simple databases
5. An advantage of a flatfile is they can store information such as, surname, date of birth etc
6. The disadvantages of a flatfile database are, data redundancy. There is often a lot of duplicate data in the table making the whole database larger. Also useful data will be deleted when you delete useless data.
7. A relational database is several tables
8. The advantages of relational databases are you can store the data in several tables with links between the tables. Another advantage is that the information will all link so it's better than a flatfile
9. A disadvantage of a relational database is that it will take up a lot of space
10. reg-number and make
2. An example of a key filed is a pupil number at a school
3. To make sure that it is unique and is only allocated to them
4. A flatfile database only contain one table and are only for simple databases
5. An advantage of a flatfile is they can store information such as, surname, date of birth etc
6. The disadvantages of a flatfile database are, data redundancy. There is often a lot of duplicate data in the table making the whole database larger. Also useful data will be deleted when you delete useless data.
7. A relational database is several tables
8. The advantages of relational databases are you can store the data in several tables with links between the tables. Another advantage is that the information will all link so it's better than a flatfile
9. A disadvantage of a relational database is that it will take up a lot of space
10. reg-number and make