Learning Objectives

By the end of this chapter, you will be able to:

  • Define the different levels of the data hierarchy (character, field, record, file, database).
  • Explain primary keys and data types of fields.
  • Differentiate between data, information, and knowledge.
  • Describe the characteristics of good-quality data.

The Data Hierarchy

Data in a computer system is organized in a logical hierarchy, from the smallest element to the largest.

  1. Character: The most basic logical element. It consists of a single letter, number, or symbol.

  2. Field: A group of related characters that represents a single attribute or characteristic of an entity.
    • Example: A customer’s name or a product’s price.
  3. Record: A collection of related fields that describe a single entity.
    • Example: A customer record would contain fields for their name, address, and phone number.
  4. File (or Table): A collection of related records.
    • Example: A customer file would contain the records for all of the company’s customers.
  5. Database: A collection of related files (or tables) that are integrated and managed together.
flowchart BT
  C[Character] --> F[Field]
  F --> R[Record]
  R --> FI[File or Table]
  FI --> D[Database]

Figure 1: Data Hierarchy from Character to Database

Below the character level, the computer stores each character as bits (0s and 1s) grouped into bytes; for example, the letter A is stored as one byte in ASCII.

Worked example: a college student database

Level Example
Character S
Field Sita Sharma (Name)
Record 1023, Sita Sharma, BBM, 2nd semester, 9841XXXXXX
File/Table The Students table holding records of all 1,200 students
Database The college database with Students, Courses, Fees, and Results tables

A table view makes the terms clear: each row is a record and each column is a field.

Roll No (key) Name Program Semester
1023 Sita Sharma BBM 2
1024 Ram Thapa BBA 4

Key fields and data types

  • A primary key is a field whose value uniquely identifies each record, such as roll number, customer ID, or citizenship number. Names cannot be keys because two people can share a name.
  • Each field has a data type: text (name), number (fees), date (date of birth), Boolean yes/no (fee paid), and so on. Correct data types prevent errors such as letters in a phone-number field.

Data, Information, and Knowledge

It is important to understand the distinction between these three terms:

  • Data: Raw, unorganized facts and figures. By itself, data is relatively meaningless.
    • Example: The number 120.
  • Information: Data that has been processed, organized, and structured within a context to make it meaningful and useful.
    • Example: "120 units sold today".
  • Knowledge: Information that has been further refined and analyzed to identify patterns, trends, and insights, which can then be used for decision-making.
    • Example: "Sales of 120 units today is a 20% increase over the daily average, likely due to our new marketing campaign."
flowchart LR
  D[Data: raw facts] --> I[Information: in context]
  I --> K[Knowledge: actionable insight]

Figure 2: Data to Information to Knowledge

Aspect Data Information Knowledge
Nature Raw facts Processed, organized data Understanding from information
Meaning Little on its own Meaningful in context Guides decisions and action
Example 85, 72, 91 Average class mark is 82.7 Students who attend tutorials score higher, so tutorials should continue

Characteristics of Good-Quality Data

Information is only as good as the data behind it (“garbage in, garbage out”). Good data is:

  • Accurate — free of errors.
  • Complete — no missing values that matter.
  • Consistent — the same in every table (a customer’s address is not different in two places).
  • Timely — up to date when needed.
  • Relevant — useful for the decision at hand.
  • Valid — in the correct format and range (a date of birth is not in the future).

Summary

Data is organized in a hierarchy, from bits and individual characters up to fields, records, files, and finally, a complete database. Each record is identified by a primary key, and each field has a data type. The ultimate goal of a database is to manage accurate, complete, consistent, and timely raw data so that it can be processed into useful information and, eventually, into actionable knowledge that can guide business decisions.

Key Takeaways

  • The data hierarchy is: Character -> Field -> Record -> File -> Database.
  • A primary key uniquely identifies each record.
  • Data is raw facts, information is processed data, and knowledge is actionable insight from information.
  • Good-quality data is accurate, complete, consistent, timely, relevant, and valid.

Discussion Questions

  1. Using the data hierarchy, describe the structure of your contacts list on your phone.
  2. Provide your own example of the difference between data, information, and knowledge.
  3. Why is raw data not very useful to a business manager?

Exam-Style Questions

Short answer

  1. Define field, record, and file with examples.
  2. What is a primary key? Why can a name not be a primary key?
  3. Differentiate between data and information.

Long answer

  1. Explain the data hierarchy with an example of a bank or college database.
  2. Explain data, information, and knowledge. What are the characteristics of good-quality data?