With programs such as Excel, the data can be searched, filtered and manipulated. The flat file is an easy and quick way to store information. A Microsoft Excel spreadsheet makes an excellent flat file. Each row would represent a record and each column would represent record fields. The flat file looks like a single table or a single spreasheet consisting of rows and columns. The most popular and widely used have fallen into the categories defined below: Flat Model In all cases, the model represents the rules by which the data will be stored, how the data will be used and how it is related. In terms of a recipe holder, the data might be categorized (entree, soup, main disk, dessert) and then alphatized. In terms of information stored in a filing cabinet, the model might be that it is stored alphabetically, or by account number, etc. In terms of a computer, it would be a collection of data on a computer or multiple computers or a single folder or a single disk, etc. A database is any collection of information such as a filing cabinet, a box of papers, a recipe folder, etc.
0 Comments
Leave a Reply. |