// 四年级核心
MERGE (kp_401:KnowledgePoint {id: "KP_7r8s9t"})
SET kp_401.name = "三位数乘两位数",
    kp_401.grade = 4,
    kp_401.tags = ["运算", "算法"];

MERGE (kp_402:KnowledgePoint {id: "KP_0u1v2w"})
SET kp_402.name = "平行四边形和梯形",
    kp_402.grade = 4,
    kp_402.tags = ["几何", "特征"];

// 五年级核心
MERGE (kp_501:KnowledgePoint {id: "KP_3x4y5z"})
SET kp_501.name = "小数乘除法",
    kp_501.grade = 5,
    kp_501.tags = ["运算", "精确计算"];

MERGE (kp_502:KnowledgePoint {id: "KP_6a7b8c"})
SET kp_502.name = "简易方程",
    kp_502.grade = 5,
    kp_502.tags = ["代数", "等式"];

// 六年级核心
MERGE (kp_601:KnowledgePoint {id: "KP_9d0e1f"})
SET kp_601.name = "分数四则运算",
    kp_601.grade = 6,
    kp_601.tags = ["综合运算"];

MERGE (kp_602:KnowledgePoint {id: "KP_2g3h4i"})
SET kp_602.name = "圆柱表面积计算",
    kp_602.grade = 6,
    kp_602.tags = ["立体几何"];

// 分析能力
MERGE (ab_401:AbilityPoint {id: "AB_m4n5o6"})
SET ab_401.name = "复杂问题分解",
    ab_401.category = "策略",
    ab_401.coreLevel = 4;

MERGE (ab_501:AbilityPoint {id: "AB_p7q8r9"})
SET ab_501.name = "方程思维",
    ab_501.category = "代数",
    ab_501.coreLevel = 5;

// 空间能力
MERGE (ab_601:AbilityPoint {id: "AB_s0t1u2"})
SET ab_601.name = "立体空间想象",
    ab_601.category = "几何",
    ab_601.coreLevel = 4;
// 四年级关联
MATCH (kp:KnowledgePoint {id: "KP_0u1v2w"}), (ab:AbilityPoint {id: "AB_s0t1u2"})
MERGE (kp)-[r:REQUIRES_ABILITY]->(ab)
SET r.weight = 0.82;

// 五年级关联
MATCH (kp:KnowledgePoint {id: "KP_6a7b8c"}), (ab:AbilityPoint {id: "AB_p7q8r9"})
MERGE (kp)-[r:DEVELOPS_ABILITY]->(ab)
SET r.weight = 0.91;

// 六年级关联
MATCH (kp:KnowledgePoint {id: "KP_2g3h4i"}), (ab:AbilityPoint {id: "AB_s0t1u2"})
MERGE (kp)-[r:REQUIRES_ABILITY]->(ab)
SET r.weight = 0.88;

// 查看方程相关能力
MATCH (kp:KnowledgePoint)-[r]->(ab:AbilityPoint)
WHERE kp.name CONTAINS '方程'
RETURN kp.grade AS 年级, kp.name AS 知识点,
       ab.name AS 培养能力, r.weight AS 关联强度;