File Terminologies [DBMS]

• What is a field in file structures?

  A single category of information in a record
• What does a record represent in a database?

  A complete unit of information
• What will be learned later about data?

  How data is structured in files
• If you have a student database, what type of file would it be?

  A file containing multiple student records
• What type of data does a binary file store?

  Data in binary form
• What does data refer to?

  Information that can be stored or analyzed
• How is your age represented as data?

  As a number (e.g., 20)
• What types of information can data include?

  Numbers, text, images, sounds, or combinations
• What are the different file formats and their purposes?

  • Text: Stores plain text data (.txt)
  • CSV: Stores tabular data (.csv)
  • JSON: Stores structured data (.json)
  • Binary: Stores data in binary form (.dat)
• What does a field hold in a record?

  A specific type of data for each entry
• How is your country represented as data?

  As a text code (e.g., GH)
• Which file format would you use to store tabular data?

  CSV
• What is the summary of basic file terminologies?

  • Data: Basic information
  • Fields: Categories of information
  • Records: Collections of fields
  • Files: Organized collections of records
• What is data compared to in the study material?

  A toy box
• What are the various file formats and their purposes?

  • Text files (.txt): Store plain text data
  • CSV files (.csv): Store tabular data
  • JSON files (.json): Store structured data
  • Binary files (.dat): Store data in binary form
• How do fields help in data management?

  They organize data into manageable units
• Why are files important in data management?

  They allow systematic storage and management
• What is the significance of combining fields in a record?

  It provides a complete overview of an item
• How can you think of a record?

  As a single entry containing relevant data
• What could fields include in a student record?

  Name, Age, and Grade
• What is the difference between a field and data?

  Field is the category; data is the value
• What fields might be included in a student record?

  Name, Age, and Grade
• How can understanding file terminologies help individuals?

  It aids in data management navigation
• How do fields contribute to the formation of a record?

  Fields combine to show all relevant data
• What is a file?

  An organized collection of records
• How do different file formats serve specific purposes?

  Each format is designed for particular data types
• What types of data can be included in a database of employees?

  Employee ID, Name, and Department
• What is a record compared to in the study material?

  A special folder that keeps boxes together
• What is a field?

  A single category of information within a record
• What is a field compared to in the study material?

  A special box inside a toy box
• How can a record be visualized in terms of data fields?

  As a group of fields representing one item
• When does data become meaningful?

  When it is organized
• What types of things can data store?


  Numbers, words, pictures, and sounds
• Why is data organized?

  To become meaningful and usable
• What do files allow us to do?

  Store and manage information systematically
• What does JSON stand for?

  JavaScript Object Notation
• How do fields help manage data?

  They organize data into manageable units
• What is a file compared to in the study material?

  A big box that keeps folders together
• What is a file in data management?

  An organized collection of records
• What is data?

  Information that can be stored or analyzed