KnowledgeBoat Logo
|

Computer Science

Differentiate between structured and unstructured data giving one example.

The principal of a school wants to do following analysis on the basis of food items procured and sold in the canteen:

  1. Compare the purchase and sale price of fruit juice and biscuits.
  2. Compare sales of fruit juice, biscuits and samosa.
  3. Variation in sale price of fruit juices of different companies for same quantity (in ml).

Create an appropriate dataset for these items (fruit juice, biscuits, samosa) by listing their purchase price and sale price. Apply basic statistical techniques to make the comparisons.

Relational Database

1 Like

Answer

Structured DataUnstructured Data
Data which is organized and can be recorded in a well defined format is called structured data.Data that is not organized and does not have a defined format is called unstructured data.
An example of structured data is a spreadsheet containing columns for item names, purchase prices, and sale prices.An example of unstructured data include web pages consisting of text as well as multimedia contents (image, graphics, audio/video).

Sample Dataset for Fruit Juice, Biscuits and Samosa

ProductCompanySales price per unitPurchase price per unitUnits Sold
Fruit Juice (250 ml)Real403510
Fruit Juice (250 ml)Tropicana453015
SamosaSamosa Party302720
SamosaChaayos363025
SamosaChai Point332915
BiscuitParle10630
BiscuitBritannia151220
BiscuitSunfeast201715
  1. For Fruit Juice:
    Mean Purchase Price = (35 + 30) / 2 = 32.5
    Mean Sale Price = (40 + 45) / 2 = 42.5
    Difference = Mean Sale Price - Mean Purchase Price = 42.5 - 32.5 = 10
    The mean purchase price of fruit juice is 10 rupees less than the mean sales price of fruit juice.
    For Biscuits:
    Mean Purchase Price = (6 + 12 + 17) / 3 = 11.67
    Mean Sale Price = (10 + 15 + 20) / 3 = 15
    Difference = Mean Sale Price - Mean Purchase Price = 15 - 11.67 = 3.33
    The mean purchase price of biscuits is 3.33 rupees less than the mean sales price of biscuits.

  2. For Fruit Juice:
    Total units sold = 10 (Real) + 15 (Tropicana) = 25 units
    For Biscuits:
    Total units sold = 30 (Parle) + 20 (Britannia) + 15 (Sunfeast) = 65 units
    For Samosas:
    Total units sold = 20 (Samosa Party) + 25 (Chaayos) + 15 (Chai Point) = 60 units
    Comparing the total units sold:
    Biscuits had the highest sales with 65 units sold.
    Samosas had the second-highest sales with 60 units sold.
    Fruit juice had the lowest sales with 25 units sold.

  3. Sale price of Real Fruit Juice (250 ml): 40
    Sale price of Tropicana Fruit Juice (250 ml): 45
    Difference = Sale price of Tropicana - Sale price of Real
    Difference = 45 - 40 = 5
    The sale price of Tropicana fruit juice is 5 rupees higher than the sale price of Real fruit juice for the same quantity (250 ml).

Answered By

1 Like


Related Questions