• vrek
    link
    fedilink
    English
    arrow-up
    10
    ·
    11 months ago

    Actually I think there should be a intermediary table as a history of activities of each child. Like child table is I’d, name, age, address, and naughty/nice value, activities would be Id, description, and good/bad value. Then a history table of ID, child_id, activity_id. So santa can recalculate a child’s naughty/nice value to “check it twice”

    • AdamEatsAss@lemmy.world
      link
      fedilink
      arrow-up
      9
      ·
      11 months ago

      Redundancy is key. There should always be two methods for calculating a child’s ANNS (Aggregate Naughty Nice Score). I propose a conventional method where activities are graded from -5 to +5 where a child’s ANNS is the sum of all their previous activities, this would be a child’s historical ANNS. And I propose a second system where only the activities performed within the last 365 days of calculation are considered, to account for children who have drastically changed behavior year to year, this would be a child’s current year ANNS. I think the current year ANNS would hold more weight in Santa’s judgement but looking at the historical ANNS in conjunction with the current year could help provide a better picture of a child’s character.

      • Dr. Bluefall@toast.ooo
        link
        fedilink
        English
        arrow-up
        9
        ·
        11 months ago

        North Pole Incorporated

        bringing all the fun of HR and spreadsheet drudgery to the little boys and girls of the world

        • vrek
          link
          fedilink
          English
          arrow-up
          2
          ·
          11 months ago

          I mean in a certain light, christmas presents are a yearly bonus for children and Santa checking his list is a management review of the child’s performance…