Sample Graph Dataset for practicing DISTINCT

sample_snacks.cypher

// ============================================================
// Byte-Sized Cypher — RETURN DISTINCT Episode Dataset
// ============================================================
// Snacks used: Kinoko no Yama, Calbee Potato Chips,
//              Koala's March, Pocky, Hi-Chew
// ============================================================
// (Walkthrough this data before / after importing)
// --- Brands ---
CREATE (meiji:Brand {name: 'Meiji'})
CREATE (calbee:Brand {name: 'Calbee'})
CREATE (lotte:Brand {name: 'Lotte'})
CREATE (glico:Brand {name: 'Glico'})
CREATE (morinaga:Brand {name: 'Morinaga'})

// --- Categories ---
CREATE (chocolate:Category {name: 'Chocolate'})
CREATE (cookie:Category {name: 'Cookie'})
CREATE (candy:Category {name: 'Candy'})
CREATE (chip:Category {name: 'Chip'})

// --- Pocky (Glico) ---
CREATE (pocky_choc:Snack:Sweet {name: 'Pocky', flavor: 'Chocolate', texture: 'Crunchy', calories: 200})
CREATE (pocky_straw:Snack:Sweet {name: 'Pocky', flavor: 'Strawberry', texture: 'Crunchy', calories: 195})
CREATE (pocky_matcha:Snack:Sweet:LimitedEdition {name: 'Pocky', flavor: 'Matcha', texture: 'Crunchy', calories: 190})

// --- Hi-Chew (Morinaga) ---
CREATE (hichew_grape:Snack:Sweet {name: 'Hi-Chew', flavor: 'Grape', texture: 'Chewy', calories: 160})
CREATE (hichew_straw:Snack:Sweet {name: 'Hi-Chew', flavor: 'Strawberry', texture: 'Chewy', calories: 160})
CREATE (hichew_mango:Snack:Sweet:LimitedEdition {name: 'Hi-Chew', flavor: 'Mango', texture: 'Chewy'})
//  ^ calories intentionally omitted (null) for demonstration

// --- Kinoko no Yama (Meiji) ---
CREATE (kinoko_choc:Snack:Sweet {name: 'Kinoko no Yama', flavor: 'Chocolate', texture: 'Crunchy', calories: 250})
CREATE (kinoko_matcha:Snack:Sweet:LimitedEdition {name: 'Kinoko no Yama', flavor: 'Matcha', texture: 'Crunchy', calories: 245})

// --- Calbee Potato Chips (Calbee) ---
CREATE (calbee_classic:Snack:Savory {name: 'Calbee Potato Chips', flavor: 'Classic Salt', texture: 'Crispy', calories: 300})
CREATE (calbee_consomme:Snack:Savory {name: 'Calbee Potato Chips', flavor: 'Consomme', texture: 'Crispy', calories: 310})
CREATE (calbee_seaweed:Snack:Savory:LimitedEdition {name: 'Calbee Potato Chips', flavor: 'Seaweed', texture: 'Crispy'})
//  ^ calories intentionally omitted (null) for demonstration

// --- Koala's March (Lotte) ---
CREATE (koala_choc:Snack:Sweet {name: "Koala's March", flavor: 'Chocolate', texture: 'Crunchy', calories: 220})
CREATE (koala_straw:Snack:Sweet {name: "Koala's March", flavor: 'Strawberry', texture: 'Crunchy', calories: 215})
CREATE (koala_white:Snack:Sweet:LimitedEdition {name: "Koala's March", flavor: 'White Chocolate', texture: 'Crunchy'})
//  ^ calories intentionally omitted (null) for demonstration


// === BRAND RELATIONSHIPS ===

CREATE (pocky_choc)-[:MADE_BY]->(glico)
CREATE (pocky_straw)-[:MADE_BY]->(glico)
CREATE (pocky_matcha)-[:MADE_BY]->(glico)

CREATE (hichew_grape)-[:MADE_BY]->(morinaga)
CREATE (hichew_straw)-[:MADE_BY]->(morinaga)
CREATE (hichew_mango)-[:MADE_BY]->(morinaga)

CREATE (kinoko_choc)-[:MADE_BY]->(meiji)
CREATE (kinoko_matcha)-[:MADE_BY]->(meiji)

CREATE (calbee_classic)-[:MADE_BY]->(calbee)
CREATE (calbee_consomme)-[:MADE_BY]->(calbee)
CREATE (calbee_seaweed)-[:MADE_BY]->(calbee)

CREATE (koala_choc)-[:MADE_BY]->(lotte)
CREATE (koala_straw)-[:MADE_BY]->(lotte)
CREATE (koala_white)-[:MADE_BY]->(lotte)


// === CATEGORY RELATIONSHIPS ===
// Snacks can belong to multiple categories, which creates
// multiple paths to the same Category node — useful for
// showing why DISTINCT matters after traversals.

CREATE (pocky_choc)-[:IN_CATEGORY]->(cookie)
CREATE (pocky_choc)-[:IN_CATEGORY]->(chocolate)
CREATE (pocky_straw)-[:IN_CATEGORY]->(cookie)
CREATE (pocky_matcha)-[:IN_CATEGORY]->(cookie)
CREATE (pocky_matcha)-[:IN_CATEGORY]->(chocolate)

CREATE (hichew_grape)-[:IN_CATEGORY]->(candy)
CREATE (hichew_straw)-[:IN_CATEGORY]->(candy)
CREATE (hichew_mango)-[:IN_CATEGORY]->(candy)

CREATE (kinoko_choc)-[:IN_CATEGORY]->(cookie)
CREATE (kinoko_choc)-[:IN_CATEGORY]->(chocolate)
CREATE (kinoko_matcha)-[:IN_CATEGORY]->(cookie)
CREATE (kinoko_matcha)-[:IN_CATEGORY]->(chocolate)

CREATE (calbee_classic)-[:IN_CATEGORY]->(chip)
CREATE (calbee_consomme)-[:IN_CATEGORY]->(chip)
CREATE (calbee_seaweed)-[:IN_CATEGORY]->(chip)

CREATE (koala_choc)-[:IN_CATEGORY]->(cookie)
CREATE (koala_choc)-[:IN_CATEGORY]->(chocolate)
CREATE (koala_straw)-[:IN_CATEGORY]->(cookie)
CREATE (koala_white)-[:IN_CATEGORY]->(cookie)
CREATE (koala_white)-[:IN_CATEGORY]->(chocolate)


// === PAIRS_WITH RELATIONSHIPS ===
// Snack pairing suggestions. These create multiple
// paths between nodes (via shared pairings and shared
// categories), which is key for demonstrating how
// graph traversals produce duplicates.

CREATE (pocky_choc)-[:PAIRS_WITH]->(kinoko_choc)
CREATE (pocky_choc)-[:PAIRS_WITH]->(koala_choc)
CREATE (kinoko_choc)-[:PAIRS_WITH]->(koala_choc)
CREATE (hichew_straw)-[:PAIRS_WITH]->(pocky_straw)
CREATE (hichew_straw)-[:PAIRS_WITH]->(koala_straw)
CREATE (hichew_grape)-[:PAIRS_WITH]->(hichew_mango)
CREATE (calbee_classic)-[:PAIRS_WITH]->(pocky_choc)
CREATE (calbee_consomme)-[:PAIRS_WITH]->(calbee_seaweed)
CREATE (koala_straw)-[:PAIRS_WITH]->(pocky_straw)


// === SIMILAR_TO RELATIONSHIPS ===
// A second relationship type between snacks. Combined
// with PAIRS_WITH, this means some snack pairs are
// connected by TWO relationships — perfect for showing
// how multiple paths to the same node produce duplicates.

CREATE (pocky_choc)-[:SIMILAR_TO]->(koala_choc)
CREATE (koala_choc)-[:SIMILAR_TO]->(kinoko_choc)
CREATE (pocky_straw)-[:SIMILAR_TO]->(koala_straw)
CREATE (hichew_grape)-[:SIMILAR_TO]->(hichew_straw)
CREATE (calbee_classic)-[:SIMILAR_TO]->(calbee_consomme)