explain file,records,field ,characters (use diagram)
The columns in a file is called as field. The rows in a file is called as record. Records are joined together to form files.
What are the numbers? you can put them from largest to smallest or Visa-Versa. it is called NUMERICAL ORDER
Bit, Byte, Field, Record, File, Database.
A file record is a unique identifier, like your social security number, that will identify a particular person, object, data, etc. A field is a part of that person, object, data. For instance your SSAN is your file record, the fact that you have blue eyes is a field of you, or the charateristics of that person.
bit-byte-field-record-file-database
bit-byte-field-record-file-data base
Each group of info - called a record - in that file was separated by a special character;vertical bar '|' was a popular option
records, a record contains fields, and a field is made up of characters
File for Record was created in 1943.
Deleting a record from a file requires that the entire file be re-written to a temporary file, skipping over the deleted record. Once complete, delete the original file then rename the temporary file with the original file name. Whilst this is trivial for small files with relatively few records, it is unworkable for much larger files which could take many minutes to rewrite. So rather then delete a record, simply mark the record for deletion instead. This can be done by using a field within the record itself (or a single bit within a bit field). As well as improving efficiency, it also provides the option of restoring records at a later date (akin to a recycle bin). To permanently delete the marked records -- known as a purge -- simply rewrite the entire file, skipping over the marked records, just as you would for a single record.
A field in a relational database refers to a specific piece of information stored in a table, representing a single attribute about an entity. It is the smallest unit of data in a database table and each field typically corresponds to a column in the table.
Each group of info - called a record - in that file was separated by a special character;vertical bar '|' was a popular option