![]() In the Flat file database, each line of the plain text file holds only one record. Flat file databases were developed by IBM in the early 1970s. It is the most important type of database used to store data in a plain text file (MS Excel). Same item to store two different values, hence the data will always be consistent.A Flat file database is also known as the text database. Data Consistency : Because each data item is stored only once it is not possible for the.Control Over Redundant Data : Wherever possible data is only stored once, so storage space is not wasted.Relational databases have two important advantages over flat file databases : Stored in two files in a relational database : If a relational database is used instead then data can be stored in multiple files which are linked by common fields. Data Inconsistency : Because some items of data are stored more than once, it is possible that in error two different values for the same item could be stored.This means that storage space is wasted and inconsistency can occur. Redundant Data : Some data is stored more than once.There are two serious problems that have been caused by trying to store this data in a flat file database : What form they are in and who their form teacher is : Here is an example of a flat file database that stores information about students in a school including In a flat file database data can only be stored in one file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |