Fields record and files ,types of files from usage point of you

133 views 9 slides Jun 30, 2024
Slide 1
Slide 1 of 9
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9

About This Presentation

Field
Smallest unit of data that can be processed and manipulated
record
Collection of related fields
File
Named collection of data record
Types of files
1. Master file
2. Transaction file
3. Backup file


Slide Content

FIELDS, RECORDS AND FILES TYPES OF FILES

Fields: Data's Building Blocks - Smallest unit of data that can be accessed or manipulated. - Contain specific pieces of information. Examples: Employee ID, Name, Department in a database.

Records: Putting Fields Together Collection of related fields treated as a single unit. Represent a complete entity or event. Example: A customer record in a sales database might include Name, Address, Phone Number, and Purchase History (all separate fields).

What is a File? A named collection of data records. Used to store information on a computer. Examples: Documents, images, videos.

Types of files Master file Transaction file Backup file

Master File Stores information that remains constant over time. Examples: Student records, customer lists. Always up-to-date. Never empty.

Transaction File Stores temporary data used for processing. Can be temporary or permanent. Examples: Sales transactions, banking deposits. Updated regularly.

Backup File - Used to create a copy of important data. - Protects against data loss or corruption. - Created using specific software. - Examples: System backups, file archives.