Skip to content

Ch 7 · Understanding Data

Activities, Practicals and Case Work

Exercise 2 of 2
Question 1NCERT PDF page 4
all?
Table 7.1 Structured data about kitchen items in a shop
ModelNo ProductName Unit Price Discount(%) Items_in_Inventory
ABC1 Water bottle 126 8 13
ABC2 Melamine Plates 320 5 45
ABC3 Dinner Set 4200 10 8
GH67 Jug 80 0 10
GH78 Table Spoon 120 5 14
GH81 Bucket 190 12 6
NK2 Kitchen Towel 25 0 32
Given this data, using a spreadsheet or other such
software, the shop owner can find out how many total
items are there by summing the column Items_in_
Inventory of Table 7.1 The owner of the shop can also
calculate the total value of all items in the inventory
by multiplying each entry of column 3 (Unit Price) with
corresponding entry of column 5 (Items_in_Inventory)
and finding their sum.
Table 7.2 shows more examples of structured data
recorded for different attributes.
Table 7.2 Attributes maintained for different activities
Entity/Activities Data Fields/Parameters/Attributes
Books at a shop BookTitle, Author, Price, YearofPublication
Depositing fees in a school StudentName, Class, RollNo, FeesAmount, DepositDate
Amount withdrawal from ATM AccHolderName, AccountNo, TypeofAcc, DateofWithdrawal,
AmountWithdrawn, ATMid, TimeOfWithdrawal
Answer

State the algorithm or concept, trace the logic step by step, and provide syntactically correct code, SQL or output where requested.

Check: Verify the result for the stated input and mention the relevant constraint or complexity.

Question 2NCERT PDF page 4
(B) Unstructured Data
A newspaper contains various types of news items
which are also called data. But there is no fixed pattern
that a newspaper follows in placing news articles. One
day there might be three images of different sizes on
a page along with five news items and one or more
advertisements. While on another day there, might be
one big image with three textual news items. So there is
100 Computer Science - Class XII
Answer

State the algorithm or concept, trace the logic step by step, and provide syntactically correct code, SQL or output where requested.

Check: Verify the result for the stated input and mention the relevant constraint or complexity.