Computer Science · Ch 7 — Understanding Data
Data comes from many sources, and its format depends entirely on where it originates. An image is a grid of pixels, a video is a sequence of frames, a fee slip mixes numbers and text, and a chat message can contain text, emojis, and media. Because of this variety, data is classified into two broad categories based on its format: structured and unstructured.
Data that is organised and can be recorded in a well-defined format is called structured data. It is typically stored in a computer in a tabular form — that is, in rows and columns.
For example, consider the inventory of kitchen items in a shop. The data can be arranged in a table where columns are Model Number, Product Name, Unit Price, Discount (%), and Items in Inventory. Each row gives the details for one product.
With structured data stored this way, a shop owner can perform calculations easily. For instance, to find the total number of items in stock, they simply sum the values in the "Items_in_Inventory" column. To find the total value of all inventory, they multiply each "Unit Price" by the corresponding "Items_in_Inventory" and then add those products.
The textbook provides several other examples of structured data, each with its own set of attributes:
| Entity / Activity | Data Fields / Parameters / Attributes |
|---|---|
| Books at a shop | BookTitle, Author, Price, YearofPublication |
| Depositing fees in a school | StudentName, Class, RollNo, FeesAmount, DepositDate |
| ModelNo | ProductName | Unit Price | Discount(%) | Items_in_Inventory |
|---|---|---|---|---|
| ABC1 | Water bottle | 126 | 8 | 13 |
| Entity/Activities | Data Fields/Parameters/Attributes |
|---|---|
| Books at a shop | BookTitle, Author, Price, YearofPublication |