What is data

What is data?

Preparation:

Data Literacy Fundamentals, Ben Jones, Ch: 1,2

WKID Pyramid:

image-20220812111411508

Exercise 1:

• Hvor er vi på pyramiden?

• Hvordan kommer vi til toppen?

• Hvem / hvordan kan data bruges?

Exercise 2

Data fra museumsbesøgende

image-20250826105139644

A) Kom med eksempler på spørgsmål eller databehandlinger, der kan omdanne rå data til overskuelig information.

• Fokus: tællinger, opdelinger, gennemsnit – rene fakta.

• Eksempel: Hvor mange besøgende fik vi totalt?

B) Kom med eksempler på spørgsmål, der kan opdage mønstre eller sammenhænge i informationen.

• Fokus: mønstre, tendenser, sammenligninger.

• Eksempel: Hvem har en tendens til at besøge museet alene? Pensionister, studerende, børn?

C) Kom med eksempler på spørgsmål eller handlinger, der kan understøtte beslutninger, som museet kan bruge i praksis.

• Fokus: handling, strategi, prioritering.

• Eksempel: kan der udvikles nye billettyper (fx familiepakker eller rabatter til studerende)?

Installing MySQL server + MySQL Workbench

Windows

• https://dev.mysql.com/downloads/windows/installer/8.0.html

  

  image-20230808105344870
• Developer Default

  

  image-20230808105452032

Mac

Installer server

• https://dev.mysql.com/downloads/mysql/

  • Husk at vælge version 8.0.39

• DMG Archive

  • Hvis du har m1: ARM

  • Hvis du har intel: x86

  • About this mac: Denne har M1, derfor ARM download

image-20230808105242133

Installer Workbench

https://dev.mysql.com/downloads/workbench/

How to load data into a database

Choose a connection

image-20220816103831195

Copy the script (below) into the Query window

image-20220816104142995

Press the left lightning button

image-20220816104228789

Refresh All

image-20220816104435630

DROP DATABASE IF EXISTS pokemon;

CREATE DATABASE pokemon;
USE pokemon;

DROP TABLE IF EXISTS pokemon;

CREATE TABLE pokemon (
    pokedex_number INT,
    name VARCHAR(45),
    speed INT,
    special_defence INT,
    special_attack INT,
    defence INT,
    attack INT,
    hp INT, 
    primary_type VARCHAR(45),
    secondary_type VARCHAR(45)
);

INSERT INTO pokemon (pokedex_number, name, speed, special_defence, special_attack, defence, attack, hp, primary_type, secondary_type) 
VALUES
(1, 'Bulbasaur', 45, 65, 65, 49, 49, 45, 'Grass', 'Poison'),
(2, 'Ivysaur', 60, 80, 80, 63, 62, 60, 'Grass', 'Poison'),
(3, 'Venusaur', 80, 100, 100, 83, 82, 80, 'Grass', 'Poison'),
(4, 'Charmander', 65, 50, 60, 43, 52, 39, 'Fire', NULL),
(5, 'Charmeleon', 80, 65, 80, 58, 64, 58, 'Fire', NULL),
(6, 'Charizard', 100, 85, 109, 78, 84, 78, 'Fire', 'Flying'),
(7, 'Squirtle', 43, 64, 50, 65, 48, 44, 'Water', NULL),
(8, 'Wartortle', 58, 80, 65, 80, 63, 59, 'Water', NULL),
(9, 'Blastoise', 78, 105, 85, 100, 83, 79, 'Water', NULL),
(10, 'Caterpie', 45, 20, 20, 35, 30, 45, 'Bug', NULL),
(11, 'Metapod', 30, 25, 25, 55, 20, 50, 'Bug', NULL),
(12, 'Butterfree', 70, 80, 90, 50, 45, 60, 'Bug', 'Flying'),
(13, 'Weedle', 50, 20, 20, 30, 35, 40, 'Bug', 'Poison'),
(14, 'Kakuna', 35, 25, 25, 50, 25, 45, 'Bug', 'Poison'),
(15, 'Beedrill', 75, 80, 45, 40, 90, 65, 'Bug', 'Poison'),
(16, 'Pidgey', 56, 35, 35, 40, 45, 40, 'Normal', 'Flying'),
(17, 'Pidgeotto', 71, 50, 50, 55, 60, 63, 'Normal', 'Flying'),
(18, 'Pidgeot', 101, 70, 70, 75, 80, 83, 'Normal', 'Flying'),
(19, 'Rattata', 72, 35, 25, 35, 56, 30, 'Normal', NULL),
(20, 'Raticate', 97, 70, 50, 60, 81, 55, 'Normal', NULL),
(21, 'Spearow', 70, 31, 31, 30, 60, 40, 'Normal', 'Flying'),
(22, 'Fearow', 100, 61, 61, 65, 90, 65, 'Normal', 'Flying'),
(23, 'Ekans', 55, 54, 40, 44, 60, 35, 'Poison', NULL),
(24, 'Arbok', 80, 79, 65, 69, 85, 60, 'Poison', NULL),
(25, 'Pikachu', 90, 50, 50, 40, 55, 35, 'Electric', NULL),
(26, 'Raichu', 110, 80, 90, 55, 90, 60, 'Electric', NULL),
(27, 'Sandshrew', 40, 30, 20, 85, 75, 50, 'Ground', NULL),
(28, 'Sandslash', 65, 55, 45, 110, 100, 75, 'Ground', NULL),
(29, 'Nidoran-f', 41, 40, 40, 52, 47, 55, 'Poison', NULL),
(30, 'Nidorina', 56, 55, 55, 67, 62, 70, 'Poison', NULL),
(31, 'Nidoqueen', 76, 85, 75, 87, 92, 90, 'Poison', 'Ground'),
(32, 'Nidoran-m', 50, 40, 40, 40, 57, 46, 'Poison', NULL),
(33, 'Nidorino', 65, 55, 55, 57, 72, 61, 'Poison', NULL),
(34, 'Nidoking', 85, 75, 85, 77, 102, 81, 'Poison', 'Ground'),
(35, 'Clefairy', 35, 65, 60, 48, 45, 70, 'Fairy', NULL),
(36, 'Clefable', 60, 90, 95, 73, 70, 95, 'Fairy', NULL),
(37, 'Vulpix', 65, 65, 50, 40, 41, 38, 'Fire', NULL),
(38, 'Ninetales', 100, 100, 81, 75, 76, 73, 'Fire', NULL),
(39, 'Jigglypuff', 20, 25, 45, 20, 45, 115, 'Normal', 'Fairy'),
(40, 'Wigglytuff', 45, 50, 85, 45, 70, 140, 'Normal', 'Fairy'),
(41, 'Zubat', 55, 40, 30, 35, 45, 40, 'Poison', 'Flying'),
(42, 'Golbat', 90, 75, 65, 70, 80, 75, 'Poison', 'Flying'),
(43, 'Oddish', 30, 65, 75, 55, 50, 45, 'Grass', 'Poison'),
(44, 'Gloom', 40, 75, 85, 70, 65, 60, 'Grass', 'Poison'),
(45, 'Vileplume', 50, 90, 110, 85, 80, 75, 'Grass', 'Poison'),
(46, 'Paras', 25, 55, 45, 55, 70, 35, 'Bug', 'Grass'),
(47, 'Parasect', 30, 80, 60, 80, 95, 60, 'Bug', 'Grass'),
(48, 'Venonat', 45, 55, 40, 50, 55, 60, 'Bug', 'Poison'),
(49, 'Venomoth', 90, 75, 90, 60, 65, 70, 'Bug', 'Poison'),
(50, 'Diglett', 95, 45, 35, 25, 55, 10, 'Ground', NULL),
(51, 'Dugtrio', 120, 70, 50, 50, 80, 35, 'Ground', NULL),
(52, 'Meowth', 90, 40, 40, 35, 45, 40, 'Normal', NULL),
(53, 'Persian', 115, 65, 65, 60, 70, 65, 'Normal', NULL),
(54, 'Psyduck', 55, 50, 65, 48, 52, 50, 'Water', NULL),
(55, 'Golduck', 85, 80, 95, 78, 82, 80, 'Water', NULL),
(56, 'Mankey', 70, 45, 35, 35, 80, 40, 'Fighting', NULL),
(57, 'Primeape', 95, 70, 60, 60, 105, 65, 'Fighting', NULL),
(58, 'Growlithe', 60, 50, 70, 45, 70, 55, 'Fire', NULL),
(59, 'Arcanine', 95, 80, 100, 80, 110, 90, 'Fire', NULL),
(60, 'Poliwag', 90, 40, 40, 40, 50, 40, 'Water', NULL),
(61, 'Poliwhirl', 90, 50, 50, 65, 65, 65, 'Water', NULL),
(62, 'Poliwrath', 70, 90, 70, 95, 95, 90, 'Water', 'Fighting'),
(63, 'Abra', 90, 55, 105, 15, 20, 25, 'Psychic', NULL),
(64, 'Kadabra', 105, 70, 120, 30, 35, 40, 'Psychic', NULL),
(65, 'Alakazam', 120, 95, 135, 45, 50, 55, 'Psychic', NULL),
(66, 'Machop', 35, 35, 35, 50, 80, 70, 'Fighting', NULL),
(67, 'Machoke', 45, 60, 50, 70, 100, 80, 'Fighting', NULL),
(68, 'Machamp', 55, 85, 65, 80, 130, 90, 'Fighting', NULL),
(69, 'Bellsprout', 40, 30, 70, 35, 75, 50, 'Grass', 'Poison'),
(70, 'Weepinbell', 55, 45, 85, 50, 90, 65, 'Grass', 'Poison'),
(71, 'Victreebel', 70, 70, 100, 65, 105, 80, 'Grass', 'Poison'),
(72, 'Tentacool', 70, 100, 50, 35, 40, 40, 'Water', 'Poison'),
(73, 'Tentacruel', 100, 120, 80, 65, 70, 80, 'Water', 'Poison'),
(74, 'Geodude', 20, 30, 30, 100, 80, 40, 'Rock', 'Ground'),
(75, 'Graveler', 35, 45, 45, 115, 95, 55, 'Rock', 'Ground'),
(76, 'Golem', 45, 65, 55, 130, 120, 80, 'Rock', 'Ground'),
(77, 'Ponyta', 90, 65, 65, 55, 85, 50, 'Fire', NULL),
(78, 'Rapidash', 105, 80, 80, 70, 100, 65, 'Fire', NULL),
(79, 'Slowpoke', 15, 40, 40, 65, 65, 90, 'Water', 'Psychic'),
(80, 'Slowbro', 30, 80, 100, 110, 75, 95, 'Water', 'Psychic'),
(81, 'Magnemite', 45, 55, 95, 70, 35, 25, 'Electric', 'Steel'),
(82, 'Magneton', 70, 70, 120, 95, 60, 50, 'Electric', 'Steel'),
(83, 'Farfetchd', 60, 62, 58, 55, 65, 52, 'Normal', 'Flying'),
(84, 'Doduo', 75, 35, 35, 45, 85, 35, 'Normal', 'Flying'),
(85, 'Dodrio', 100, 60, 60, 70, 110, 60, 'Normal', 'Flying'),
(86, 'Seel', 45, 70, 45, 55, 45, 65, 'Water', NULL),
(87, 'Dewgong', 70, 95, 70, 80, 70, 90, 'Water', 'Ice'),
(88, 'Grimer', 25, 50, 40, 50, 80, 80, 'Poison', NULL),
(89, 'Muk', 50, 100, 65, 75, 105, 105, 'Poison', NULL),
(90, 'Shellder', 40, 25, 45, 100, 65, 30, 'Water', NULL),
(91, 'Cloyster', 70, 45, 85, 180, 95, 50, 'Water', 'Ice'),
(92, 'Gastly', 80, 35, 100, 30, 35, 30, 'Ghost', 'Poison'),
(93, 'Haunter', 95, 55, 115, 45, 50, 45, 'Ghost', 'Poison'),
(94, 'Gengar', 110, 75, 130, 60, 65, 60, 'Ghost', 'Poison'),
(95, 'Onix', 70, 45, 30, 160, 45, 35, 'Rock', 'Ground'),
(96, 'Drowzee', 42, 90, 43, 45, 48, 60, 'Psychic', NULL),
(97, 'Hypno', 67, 115, 73, 70, 73, 85, 'Psychic', NULL),
(98, 'Krabby', 50, 25, 25, 90, 105, 30, 'Water', NULL),
(99, 'Kingler', 75, 50, 50, 115, 130, 55, 'Water', NULL),
(100, 'Voltorb', 100, 55, 55, 50, 30, 40, 'Electric', NULL),
(101, 'Electrode', 140, 80, 80, 70, 50, 60, 'Electric', NULL),
(102, 'Exeggcute', 40, 45, 60, 80, 40, 60, 'Grass', 'Psychic'),
(103, 'Exeggutor', 55, 65, 125, 85, 95, 95, 'Grass', 'Psychic'),
(104, 'Cubone', 35, 50, 40, 95, 50, 50, 'Ground', NULL),
(105, 'Marowak', 45, 80, 50, 110, 80, 60, 'Ground', NULL),
(106, 'Hitmonlee', 87, 110, 35, 53, 120, 50, 'Fighting', NULL),
(107, 'Hitmonchan', 76, 110, 35, 79, 105, 50, 'Fighting', NULL),
(108, 'Lickitung', 30, 75, 60, 75, 55, 90, 'Normal', NULL),
(109, 'Koffing', 35, 45, 60, 95, 65, 40, 'Poison', NULL),
(110, 'Weezing', 60, 70, 85, 120, 90, 65, 'Poison', NULL),
(111, 'Rhyhorn', 25, 30, 30, 95, 85, 80, 'Ground', 'Rock'),
(112, 'Rhydon', 40, 45, 45, 120, 130, 105, 'Ground', 'Rock'),
(113, 'Chansey', 50, 105, 35, 5, 5, 250, 'Normal', NULL),
(114, 'Tangela', 60, 40, 100, 115, 55, 65, 'Grass', NULL),
(115, 'Kangaskhan', 90, 80, 40, 80, 95, 105, 'Normal', NULL),
(116, 'Horsea', 60, 25, 70, 70, 40, 30, 'Water', NULL),
(117, 'Seadra', 85, 45, 95, 95, 65, 55, 'Water', NULL),
(118, 'Goldeen', 63, 50, 35, 60, 67, 45, 'Water', NULL),
(119, 'Seaking', 68, 80, 65, 65, 92, 80, 'Water', NULL),
(120, 'Staryu', 85, 55, 70, 55, 45, 30, 'Water', NULL),
(121, 'Starmie', 115, 85, 100, 85, 75, 60, 'Water', 'Psychic'),
(122, 'Mr-mime', 90, 120, 100, 65, 45, 40, 'Psychic', 'Fairy'),
(123, 'Scyther', 105, 80, 55, 80, 110, 70, 'Bug', 'Flying'),
(124, 'Jynx', 95, 95, 115, 35, 50, 65, 'Ice', 'Psychic'),
(125, 'Electabuzz', 105, 85, 95, 57, 83, 65, 'Electric', NULL),
(126, 'Magmar', 93, 85, 100, 57, 95, 65, 'Fire', NULL),
(127, 'Pinsir', 85, 70, 55, 100, 125, 65, 'Bug', NULL),
(128, 'Tauros', 110, 70, 40, 95, 100, 75, 'Normal', NULL),
(129, 'Magikarp', 80, 20, 15, 55, 10, 20, 'Water', NULL),
(130, 'Gyarados', 81, 100, 60, 79, 125, 95, 'Water', 'Flying'),
(131, 'Lapras', 60, 95, 85, 80, 85, 130, 'Water', 'Ice'),
(132, 'Ditto', 48, 48, 48, 48, 48, 48, 'Normal', NULL),
(133, 'Eevee', 55, 65, 45, 50, 55, 55, 'Normal', NULL),
(134, 'Vaporeon', 65, 95, 110, 60, 65, 130, 'Water', NULL),
(135, 'Jolteon', 130, 95, 110, 60, 65, 65, 'Electric', NULL),
(136, 'Flareon', 65, 110, 95, 60, 130, 65, 'Fire', NULL),
(137, 'Porygon', 40, 75, 85, 70, 60, 65, 'Normal', NULL),
(138, 'Omanyte', 35, 55, 90, 100, 40, 35, 'Rock', 'Water'),
(139, 'Omastar', 55, 70, 115, 125, 60, 70, 'Rock', 'Water'),
(140, 'Kabuto', 55, 45, 55, 90, 80, 30, 'Rock', 'Water'),
(141, 'Kabutops', 80, 70, 65, 105, 115, 60, 'Rock', 'Water'),
(142, 'Aerodactyl', 130, 75, 60, 65, 105, 80, 'Rock', 'Flying'),
(143, 'Snorlax', 30, 110, 65, 65, 110, 160, 'Normal', NULL),
(144, 'Articuno', 85, 125, 95, 100, 85, 90, 'Ice', 'Flying'),
(145, 'Zapdos', 100, 90, 125, 85, 90, 90, 'Electric', 'Flying'),
(146, 'Moltres', 90, 85, 125, 90, 100, 90, 'Fire', 'Flying'),
(147, 'Dratini', 50, 50, 50, 45, 64, 41, 'Dragon', NULL),
(148, 'Dragonair', 70, 70, 70, 65, 84, 61, 'Dragon', NULL),
(149, 'Dragonite', 80, 100, 100, 95, 134, 91, 'Dragon', 'Flying'),
(150, 'Mewtwo', 130, 90, 154, 90, 110, 106, 'Psychic', NULL),
(151, 'Mew', 100, 100, 100, 100, 100, 100, 'Psychic', NULL);

Exercises

The Structured Query Language (SQL) is made to be read as natural language. Try to solve the following exercises without conducting research. If nothing works - look it up online.

A) Display all pokemon with the following query:

SELECT *
FROM pokemon

B) Correct the below query such that it fetches all pokemon with a speed higher than 80

• Insert the query in the query window to confirm your answer

SELECT *
FROM pokemon
WHERE speed = 80

C) Correct the below query such that it fetches all pokemon but only their name

SELECT `name`, speed, attack, hp
FROM pokemon
WHERE speed = 80

D) Write a query such that all fire-pokemon are fetched

E) Write a query such that all pokemon with a index number higher than 100 are fetched