Database

• What is the term used for the requirement of storing data in a database?

  Storage requirement
• What is the relationship type that connects one record in a database to one other record?

  One to one
• What is the relationship type that connects one record in a database to multiple records?

  One to many
• What is the relationship type that connects multiple records in a database to multiple records?

  Many to many
• How are relationships represented in a database?

  By lines connecting entities
• What is an example of a field criteria in a database query?

  country = "Japan"
• What does sorting data in a database involve?

  Arranging data in a specific order
• What is the term for arranging data from lowest to highest?

  Ascending
• What is the term for arranging data from highest to lowest?

  Descending
• What are the types of data validation checks?

  • Presence check: Ensures data is present
  • Length check: Validates correct number of characters
  • Type check: Confirms correct data type
  • Format check: Matches predetermined pattern
  • Range check: Ensures data is within limits
• What is the purpose of a presence check in data validation?


  To ensure data is present and not left blank
• What does a length check validate in data input?


  That the correct number of characters are entered
• What does a type check ensure in data entry?


  That all data entered is of the correct data type
• What is the purpose of a format check in data validation?


  To determine that data matches a predetermined pattern
• What does a range check validate in data input?


  That data is within a lower and upper limit
• What are the comparison operators used in range checks?

  • < : less than
  • > : more than
  • <= : less than or equal to
  • >= : more than or equal to
• What does the term "agental" refer to in the context of big data?

  It refers to large amounts of data that have been collected for analysis.
• What is the purpose of data mining?


  To search and analyze large batches of data to identify patterns.
• What does "volume" refer to in big data?


  It refers to the amount of data stored.
• What types of data can be stored in big data systems?

  Data can be stored in many formats, such as video and images.
• What are the three types of data structures mentioned?

  Structured, semi-structured, and unstructured data.
• What does "velocity" refer to in the context of big data?


  It refers to the speed at which data can be processed.
• Why do organizations use powerful computers in big data processing?

  To process large volumes of data more quickly.
• What is the role of data analysis in interpreting big data?

  • To produce useful information from large volumes of data
  • Beneficial for organizations in decision-making
  • Utilizes specialized software like data mining and statistical analyses
  • Processing is more difficult when data is in different formats
• What is the primary structure used to store data in a database?

  Tables
• How is data organized within a database?

  Data is organized in one or more tables
• What is the purpose of a key field in a database table?

  To identify each record
• What is a query used for in a database?

  To locate specific data using criteria
• What is the output format of data after using a report in a database?

  User-friendly format
• What is the function of a form in a database?

  To add data to a database
• How can tasks in a database be automated?

  Using a macro
• What are the main components of a database system?

  • Tables
  • Records
  • Queries
  • Reports
  • Forms
  • Macros