Upgrade to Pro — share decks privately, control downloads, hide ads and more …

G'sデータベース設計の講義

 G'sデータベース設計の講義

G's Academy Tokyo で行なっている、データベース設計の講義資料です。論理設計を中心に、エンティティの定義、リレーションシップの定義、データ項目定義など行います。初心者向けです。

Presented by http://www.yoheim.net/
Lecturing at https://gsacademy.tokyo/

Yohei Munesada

February 21, 2018
Tweet

More Decks by Yohei Munesada

Other Decks in Technology

Transcript

  1. ָ͍͠σʔλϕʔεઃܭͷߨٛ
    :PIFJ.VOFTBEB

    View full-size slide

  2. 2
    फఆ༸ฏ ΉͶͩ͞Α͏΁͍

    http://www.yoheim.net
    1ZUIPO /PEF+4 +BWB (P 4XJGU 1)1
    'SPOUFOE FUD

    View full-size slide

  3. 3
    ͜ͷߨٛͷΰʔϧ
    ଔۀ੍࡞ͷσʔλϕʔεઃܭ͕Ͱ͖ΔΑ͏ʹͳΔ͜ͱ

    View full-size slide

  4. 4
    σʔλϕʔεઃܭͷશମ૾ͱࠓճͷൣғ
    ࿦ཧઃܭ ෺ཧઃܭ
    σʔλͷ࿦ཧతͳߏ଄Λ
    ໌Β͔ʹ͢Δ
    σʔλϕʔεͷੑೳΛ
    ࠷େԽ͢Δ

    View full-size slide

  5. 5
    ࿦ཧઃܭ ෺ཧઃܭ
    σʔλͷཧղ
    ΤϯςΟςΟͷఆٛ
    ϦϨʔγϣϯγοϓͷఆٛ
    σʔλ߲໨ͷఆٛ
    ྻͷఆٛ
    σʔλϕʔεઃܭͷશମ૾ͱࠓճͷൣғ
    σʔλ༰ྔͷݟੵ΋Γ
    ύϑΥʔϚϯεͷઃܭ
    ো֐ରԠͷઃܭ
    ؂ࢹͷઃܭ

    View full-size slide

  6. 6
    ࿦ཧઃܭ ෺ཧઃܭ
    σʔλͷཧղ
    ΤϯςΟςΟͷఆٛ
    ϦϨʔγϣϯγοϓͷఆٛ
    σʔλ߲໨ͷఆٛ
    ྻͷఆٛ
    σʔλϕʔεઃܭͷશମ૾ͱࠓճͷൣғ
    σʔλ༰ྔͷݟੵ΋Γ
    ύϑΥʔϚϯεͷઃܭ
    ো֐ରԠͷઃܭ
    ؂ࢹͷઃܭ

    View full-size slide

  7. 7
    ໨࣍
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  8. 8
    νʔϜ෼͚
    ςʔϒϧͰ̍νʔϜʹͳ͍ͬͯͩ͘͞

    View full-size slide

  9. Database Design

    View full-size slide

  10. 10
    ໨࣍
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ
    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  11. 11
    ϞοΫΞϓϦΛΈͯΈΑ͏

    View full-size slide

  12. 12
    ϞοΫΞϓϦΛΈͯΈΑ͏

    View full-size slide

  13. 13
    ໨࣍
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ
    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  14. 14
    σʔλͷཧղ
    ΞϓϦͷதʹͲͷΑ͏ͳσʔλ͕ଘࡏ͢Δͷ͔ʁ
    ֤σʔλͷϥΠϑαΠΫϧ͸Կ͔ʁ
    ԋश

    View full-size slide

  15. 15
    σʔλϕʔεઃܭʹ͍ͭͯߟ͑Α͏
    ྑ͍σʔλϕʔεઃܭͱ͸Կ͔ʁ
    ԋश

    View full-size slide

  16. 16
    ྑ͍σʔλϕʔεઃܭͱ͸Կ͔ʁ
    㾎 ࢀরͱߋ৽͕ߦ͍΍͍͢͜ͱ
    㾎 ը໘Λදࣔ͢Δࡍʹɺ4FMFDUจΛ༰қʹॻ͚Δ͔
    㾎 ը໘Λදࣔ͢Δࡍʹɺ4FMFDUจͷύϑΥʔϚϯε͸ྑ͍͔
    㾎 σʔλΛߋ৽͢Δࡍʹɺໃ६ͳ͘௥Ճߋ৽࡟আ͕Ͱ͖Δ͔
    㾎 কདྷͷมߋʹڧ͍͜ͱ
    㾎 ػೳΛ௥Ճ͢Δࡍʹɺ؆୯ʹ௥Ճ͢Δ͜ͱ͸Ͱ͖Δ͔

    View full-size slide

  17. 17
    ໨࣍
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ
    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  18. 18
    ΤϯςΟςΟͷఆٛ
    ΤϯςΟςΟͱ͸෺ࣄΛ֓೦Խͯ͠Ϟσϧͱͯ͠දݱͨ͠΋ͷͰ͢ɻ
    ঎඼
    ঎඼ίʔυ
    ঎඼໊
    ୯Ձ
    ΤϯςΟςΟ໊
    ଐੑ໊

    View full-size slide

  19. 19
    ΤϯςΟςΟΛ۩৅Խͨ͠΋ͷΛΠϯελϯεͱݴ͍·͢ɻ
    ঎඼
    ঎඼ίʔυ
    ঎඼໊
    ୯Ձ
    ςϨϏ =
    1$ =
    ΤϯςΟςΟ Πϯελϯε
    ΤϯςΟςΟͷఆٛ

    View full-size slide

  20. 20
    جຊΩʔ
    ΤϯςΟςΟΛҰҙʹࣝผ͢ΔͨΊͷΩʔΛجຊΩʔ 1,
    ͱݴ͍·͢ɻ
    ঎඼
    ঎඼ίʔυ
    ঎඼໊
    ୯Ձ
    ςϨϏ =
    1$ =
    ΤϯςΟςΟ Πϯελϯε

    View full-size slide

  21. 21
    ΤϯςΟςΟͷఆٛ
    ϞοΫΞϓϦͷΤϯςΟςΟΛચ͍ग़ͦ͏ɻ
    ԋश

    View full-size slide

  22. 22
    ΤϯςΟςΟͷఆٛ
    ϞοΫΞϓϦͷΤϯςΟςΟΛચ͍ग़ͦ͏ɻ
    ԋश
    Ϣʔβʔ
    ౤ߘ
    ίϝϯτ
    ͍͍Ͷ

    View full-size slide

  23. 23
    ໨࣍
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ
    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  24. 24
    ϦϨʔγϣϯγοϓͷఆٛ
    ϦϨʔγϣϯγοϓͱ͸ΤϯςΟςΟؒͷؔ܎Λදݱ΋ͷͰ͢ɻ
    ঎඼
    ঎඼ίʔυ
    ঎඼໊
    ୯Ձ
    ஫จৄࡉ
    ஫จίʔυ
    ঎඼ίʔυ
    ਺ྔ
    ஫จ
    ஫จίʔυ
    ஫จ೔

    View full-size slide

  25. 25
    ଟॏ౓
    ΤϯςΟςΟؒͷؔ܎ʹ͸ɺଟॏ౓ ΧʔσΟφϦςΟ
    ͕ଘࡏ͠·͢ɻ
    ΤϯςΟςΟ
    ର ΤϯςΟςΟ
    ΤϯςΟςΟ
    ରଟ ΤϯςΟςΟ
    ΤϯςΟςΟ
    ଟରଟ ΤϯςΟςΟ

    View full-size slide

  26. 26
    ΦϓγϣφϦςΟ
    ଟॏ౓Ͱ͸ɺθϩΛؚΉ͔൱͔ ΦϓγϣφϦςΟ
    ΋ߟྀ͠·͢ɻ
    ΤϯςΟςΟ
    ඞਢͰ͋Δ ΤϯςΟςΟ
    ΤϯςΟςΟ ΤϯςΟςΟ
    ΤϯςΟςΟ
    ඞਢͰͳ͍ ΤϯςΟςΟ
    ΤϯςΟςΟ ΤϯςΟςΟ

    View full-size slide

  27. 27
    ΤϯςΟςΟ
    ඞਢͰ͋Δ ΤϯςΟςΟ
    ΤϯςΟςΟ ΤϯςΟςΟ
    ΤϯςΟςΟ
    ඞਢͰͳ͍ ΤϯςΟςΟ
    ΤϯςΟςΟ ΤϯςΟςΟ
    1
    1..n
    0..1
    0..n
    ΦϓγϣφϦςΟ͸ɺʮOʯͷΑ͏ʹදݱ͢Δ৔߹΋͋Γ·͢ɻ
    ΦϓγϣφϦςΟ

    View full-size slide

  28. 28
    ରͷྫ
    ݟੵ΋ΓΛ࡞͔ͬͯΒߪೖΛߦ͏৔߹ɺݟੵ΋Γͱߪೖ͸ରͷؔ܎ͱͳΔɻ
    ݟੵ΋Γ ߪೖ
    ݟੵ΋Γ
    ݟੵ΋Γ
    ݟੵ΋Γ
    ߪೖ
    ߪೖ

    View full-size slide

  29. 29
    ରଟͷྫ
    ෦ॺʹ͸ෳ਺ਓͷࣾһ͕ଐ͢ΔͨΊɺରଟͷؔ܎ͱͳΓ·͢ɻ
    ෦ॺ ࣾһ
    ։ൃ෦
    ࣾ௕ࣨ
    #͞Μ
    $͞Μ
    ʢ˞͜͜Ͱ͸݉຿͸ߟྀ͠·ͤΜʣ
    "͞Μ
    چ؂ࠪࣨ

    View full-size slide

  30. 30
    ଟରଟͷྫ
    ঎඼ͱ஫จ͸ଟରଟͷؔ܎ͱͳΓ·͢ɻ
    ঎඼ ஫จ
    ྫྷଂݿ
    εϚϗ
    ஫จ
    ஫จ
    ஫จ
    ઔ෩ػ
    ύιίϯ ஫จ

    View full-size slide

  31. 31
    ଟରଟͷؔ܎͸ආ͚Δ΂͠
    ଟରଟͷؔ܎͸.Z42-ͳͲͰදݱͰ͖ͳ͍ͨΊɺରଟʹม׵͠·͢ɻ
    ঎඼ ஫จ
    ྫྷଂݿ
    εϚϗ
    ஫จ
    ஫จ
    ஫จ
    ઔ෩ػ
    ύιίϯ ஫จ
    ஫จ໌ࡉ
    ஫จͷ໌ࡉ
    ஫จͷ໌ࡉ
    ஫จͷ໌ࡉ
    ஫จͷ໌ࡉ
    ஫จͷ໌ࡉ

    View full-size slide

  32. 32
    ϞοΫΞϓϦͷΤϯςΟςΟؒͷϦϨʔγϣϯγοϓΛఆٛ͠Α͏ɻ
    ԋश
    ϦϨʔγϣϯγοϓͷఆٛ
    େ෼ྨ
    ࡞੒Πϝʔδ

    த෼ྨ
    ฑ σβΠϯ ૉࡐ
    ঎඼
    4,6
    αΠζ
    Χϥʔ

    View full-size slide

  33. 33
    ϞοΫΞϓϦͷΤϯςΟςΟؒͷϦϨʔγϣϯγοϓΛఆٛ͠Α͏ɻ
    ԋश
    ϦϨʔγϣϯγοϓͷఆٛ
    Ϣʔβʔ ౤ߘ
    ίϝϯτ
    ͍͍Ͷ

    View full-size slide

  34. 34
    ໨࣍
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ
    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  35. 35
    σʔλ߲໨ͷఆٛ
    ঎඼
    ঎඼ίʔυ
    ঎඼໊
    ୯Ձ
    㾎 ΞϓϦʹؚ·ΕΔσʔλΛ࿙Εͳ͘੝ΓࠐΈ·͢
    ֤ΤϯςΟςΟͷ࣋ͭσʔλ߲໨ʢଐੑʣΛఆٛ͠·͢ɻ
    ˠ࿙ΕΛݟ͚ͭͨΒͦͷ࣌఺ͰσʔλઃܭΛݟ௚͠·͢
    ˠਖ਼نԽΛֶͼ·͠ΐ͏
    㾎 ԿΛͲͷΤϯςΟςΟʹೖΕΔ΂͖ͳͷ͔ʁ

    View full-size slide

  36. 36
    σʔλͷਖ਼نԽͷΠϝʔδ
    #FGPSF
    "GUFS

    View full-size slide

  37. 37
    σʔλͷਖ਼نԽͱ͸
    σʔλͷ௥Ճߋ৽࣌ʹյΕͳ͍Α͏ʹ͢Δʢ੔߹ੑͷ୲อʣ
    㾎 ਖ਼نԽͷ໨త
    ʮୈਖ਼نԽʯʮୈਖ਼نԽʯʮୈਖ਼نԽʯͷछྨ
    㾎 ਖ਼نԽͷछྨ

    View full-size slide

  38. 38
    ඇਖ਼نԽͷঢ়ଶ
    ਖ਼نԽલͷঢ়ଶͰ͸ɺσʔλͷதʹ܁Γฦ߲͠໨͕ଘࡏ͠·͢ɻ
    ͱ͋Δ͓ళͷ஫จσʔλ

    View full-size slide

  39. 39
    ͜ͷσʔλߏ଄Ͱӡ༻͢Δͱ৭ʑͱ໰୊͕͋Γ·͢ɻ
    ԿͰ͠ΐ͏͔ʁ
    ඇਖ਼نԽͷঢ়ଶͰ͸ɺσʔλͷதʹ܁Γฦ߲͠໨͕ଘࡏ͠·͢ɻ
    ԋश
    ਖ਼نԽલͷঢ়ଶ
    ͱ͋Δ͓ళͷ஫จσʔλ

    View full-size slide

  40. 40
    ୈਖ਼نԽ
    ඇਖ਼نԽͷঢ়ଶ͔Β܁Γฦ߲͠໨Λͳ͘͢ͱɺୈਖ਼نԽͱͳΓ·͢ɻ

    View full-size slide

  41. 41
    جຊΩʔͷఆٛ
    ඇਖ਼نԽͷঢ়ଶ͔Β܁Γฦ߲͠໨Λͳ͘͢ͱɺୈਖ਼نԽͱͳΓ·͢ɻ
    ͜ͷσʔλͷجຊΩʔ͸ԿͰ͠ΐ͏͔ʁ
    ԋश

    View full-size slide

  42. 42
    جຊΩʔ جຊΩʔ
    جຊΩʔʢओΩʔʣΛϕʔεʹɺୈਖ਼نԽҎ߱Λߦ͍·͢ɻ
    جຊΩʔͷఆٛ

    View full-size slide

  43. 43
    ͋Δσʔλ͕جຊΩʔͷҰ෦ʹैଐ͍ͯ͠Δঢ়ଶͰ͢ɻ
    ෦෼తؔ਺ैଐ
    ୈਖ਼نԽ
    ୈਖ਼نԽͰ͸ɺ෦෼ؔ਺ैଐΛഉআ͠·͢ɻ
    ෦෼ؔ਺ैଐͱ͸ʁ
    ςʔϒϧΛ෼ׂ͠·͢

    View full-size slide

  44. 44
    ୈਖ਼نԽ
    ୈਖ਼نԽͰ͸ɺ෦෼ؔ਺ैଐΛഉআ͠·͢ɻ
    શͯͷ෦෼తؔ਺ैଐΛݟ͚ͭ·͠ΐ͏ɻ
    ԋश

    View full-size slide

  45. 45
    ୈਖ਼نԽ
    ఻ථ൪߸ͷΈʹैଐ͢Δσʔλͱɺ঎඼ίʔυʹͷΈैଐ͢Δσʔλ͕ଘࡏ͠·͢ɻ

    View full-size slide

  46. 46
    ஫จ໌ࡉ ঎඼
    ஫จ
    ୈਖ਼نԽ
    ෦෼తؔ਺ैଐͷσʔλ͸ɺΤϯςΟςΟΛผʹ࡞੒͠·͢ɻ

    View full-size slide

  47. 47
    ஫จ
    ਪҠతؔ਺ैଐ
    ୈਖ਼نԽ
    ୈਖ਼نԽͰ͸ɺਪҠతؔ਺ैଐΛഉআ͠·͢ɻ
    جຊΩʔҎ֎ͷσʔλಉ࢜Ͱैଐؔ܎͕͋Δঢ়ଶͰ͢ɻ
    ਪҠతؔ਺ैଐͱ͸ʁ
    ςʔϒϧΛ෼ׂ͠·͢

    View full-size slide

  48. 48
    ஫จ
    ୈਖ਼نԽ
    ୈਖ਼نԽͰ͸ɺਪҠతؔ਺ैଐΛഉআ͠·͢ɻ
    શͯͷਪҠతؔ਺ैଐΛݟ͚ͭ·͠ΐ͏ɻ
    ԋश

    View full-size slide

  49. 49
    ୈਖ਼نԽ
    ళฮ*%ͱ୲౰ऀ*%ʹͦΕͧΕਪҠతؔ਺ैଐͷσʔλ͕ଘࡏ͠·͢ɻ

    View full-size slide

  50. 50
    ஫จ
    ళฮ ୲౰ऀ
    ୈਖ਼نԽ
    ਪҠతؔ਺ैଐͷσʔλ͸ɺผΤϯςΟςΟͱͯ͠ఆٛ͠·͢ɻ

    View full-size slide

  51. 51
    ਖ਼نԽ·ͱΊ
    ΤϯςΟςΟͷ෼ׂ݁Ռͷ#FGPSF"GUFSͰ͢ɻ
    #FGPSF

    View full-size slide

  52. 52
    ച্
    ళฮ
    ୲౰ऀ
    ച্໌ࡉ ঎඼
    ਖ਼نԽ·ͱΊ
    ΤϯςΟςΟͷ෼ׂ݁Ռͷ#FGPSF"GUFSͰ͢ɻ
    "GUFS

    View full-size slide

  53. 53
    ച্
    ళฮ
    ୲౰ऀ
    ച্໌ࡉ ঎඼
    ࢀߟ
    ಋग़߲໨ͷ࡟আ
    ࢉग़Ͱ͖Δ਺஋͸ɺΤϯςΟςΟͷଐੑʹఆٛ͠ͳ͍͜ͱ͕جຊͰ͢ɻ
    × × ×
    ×

    View full-size slide

  54. 54
    㾎 0SEFS#Z΍(SPVQ#ZͰ࢖͍͍ͨ৔߹
    㾎 ྫɿച্ॱʹιʔτ
    ͔͠͠ɺ׶͑ͯಋग़߲໨Λ࢒͢࡞੒͢Δ৔߹΋͋Γ·͢ɻ
    㾎 සൟʹಋग़߲໨ʹΞΫηε͍ͨ͠৔߹
    㾎 ྫɿϢʔβʔͷ-JLF૯਺Λදࣔ
    㾎 ച্ֹۚ΍UBYͳͲ࢒͓ͯ͘͠ඞཁ͕͋Δ৔߹
    㾎 ྫɿͦͷ࣌ʹׂҾͯ͠ൢചͨ͠
    㾎 ྫɿUBY཰͸೥݄ʹΑͬͯҟͳΔ
    ࢀߟ
    ಋग़߲໨ͷ࡟আ

    View full-size slide

  55. 55
    ୈਖ਼نԽ͕جຊͰ͕͢ɺ׶͑ͯਖ਼نԽͳͲ่͢৔߹͕͋Γ·͢ɻ
    ࢀߟ
    ਖ਼نԽΛ่͢৔߹
    ͲͷΑ͏ͳ৔߹ʹୈਖ਼نԽΛ่͢Ͱ͠ΐ͏͔ʁ
    ԋश

    View full-size slide

  56. 56
    ୈਖ਼نԽ͕جຊͰ͕͢ɺ׶͑ͯୈਖ਼نԽͳͲ่͢৔߹͕͋Γ·͢ɻ
    ࢀߟ
    ਖ਼نԽΛ่͢৔߹
    ύϑΥʔϚϯε޲্Λ໨తͱ͢Δͱ͖
    ൢചͳͲͦͷ࣌఺ͷσʔλΛ࢒͢ඞཁ͕͋Δͱ͖
    ౴͑

    View full-size slide

  57. 57
    σʔλ߲໨ͷఆٛ
    ΤϯςΟςΟͷσʔλ߲໨Λఆٛ͠ɺ
    ୈਖ਼نԽΛຬ͔ͨ͢ΛνΣοΫͯ͠ΈΑ͏ɻ
    ԋश

    View full-size slide

  58. 58
    σʔλ߲໨ͷఆٛ
    ΤϯςΟςΟͷσʔλ߲໨Λఆٛ͠ɺ
    ୈਖ਼نԽΛຬ͔ͨ͢ΛνΣοΫͯ͠ΈΑ͏ɻ
    ԋश
    ౤ߘ
    *%
    λΠτϧ
    આ໌จ
    Ϣʔβʔ*%
    ஋ஈ
    ը૾63-
    Ϣʔβʔ
    *%
    ϩάΠϯ*%
    Ϣʔβʔ໊
    ύεϫʔυ
    ஀ੜ೔
    ͍͍Ͷ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ

    View full-size slide

  59. 59
    ໨࣍
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ
    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  60. 60
    ྻͷఆٛ
    㾎 ྻ໊ͷఆٛʢ࿦ཧ໊෺ཧ໊ʣ
    㾎 ϓϥΠϚϦʔΩʔɺϢχʔΫΩʔɺ֎෦Ωʔͷఆٛ
    㾎 ྻͷσʔλܕͷఆٛ
    ྻͷఆٛͰ͸ɺͭͷ͜ͱΛߦ͍·͢ɻ

    View full-size slide

  61. 61
    㾎 ྻ໊ͷఆٛʢ࿦ཧ໊෺ཧ໊ʣ
    㾎 ϓϥΠϚϦʔΩʔɺϢχʔΫΩʔɺ֎෦Ωʔͷఆٛ
    㾎 ྻͷσʔλܕͷఆٛ
    ྻͷఆٛͰ͸ɺͭͷ͜ͱΛߦ͍·͢ɻ
    ྻͷఆٛ

    View full-size slide

  62. 62
    ྻ໊ͷఆٛ ࿦ཧ໊෺ཧ໊

    ঎඼
    1SPEVDUT
    JE
    OBNF
    QSJDF
    ୲౰ऀ
    4UBGGT
    JE
    OBNF
    ΤϯςΟςΟͱଐੑͷ࿦ཧ໊ͱ෺ཧ໊ΛܾΊ͍͖ͯ·͢ɻ

    View full-size slide

  63. 63
    ച্
    4BMFT
    JE
    TIPQ@JE
    TBMF@EBUF
    UPUBM
    UBY
    UPUBM@BOE@UBY
    TUBGG@JE
    ച্໌ࡉ
    4BMF@EFUBJMT
    TBMF@JE
    QSPEVDU@JE
    BNPVOU
    UPUBM
    ྻ໊ͷఆٛ ࿦ཧ໊෺ཧ໊

    ΤϯςΟςΟͱଐੑͷ࿦ཧ໊ͱ෺ཧ໊ΛܾΊ͍͖ͯ·͢ɻ

    View full-size slide

  64. 64
    㾎 ςʔϒϧ໊͸୯਺ܗ͔ʁෳ਺ܗ͔ʁ
    㾎 ͲͬͪͰ΋ྑ͍ɻͨͩ͠ϥΠϒϥϦʹΑͬͯΦεεϝ͕͋Δɻ
    ྻ໊ͷఆٛ ࿦ཧ໊෺ཧ໊

    ෺ཧ໊Λ͚ͭΔͱ͖ͷ5JQTͰ͢ɻ
    㾎 ྻͷ෺ཧ໊Λ͚ͭΔͷ͕೉͍͠Μ͚ͩͲʁ
    㾎 ࣙॻΛҾ͖ͳ͕ΒؤுΔɻ
    㾎 ͨͩ͠ɺۀ຿ಛ༗໊শ͸ϩʔϚࣈͰ͚ͭΔ͜ͱ΋͋Δɻ
    㾎 ଞͷςʔϒϧΛࢀর͢Δྻ໊ͷ෇͚ํ͸ʁ
    㾎 ʮʢࢀরઌͷʣςʔϒϧ໊@ྻ໊ʯ͕جຊɻ
    㾎 ๻ͷ৔߹ʹ͸ʮGL@ςʔϒϧ໊@ྻ໊ʯʹ͢Δ͜ͱ΋͋Δɻ

    View full-size slide

  65. 65
    㾎 ྻ໊ͷఆٛʢ࿦ཧ໊෺ཧ໊ʣ
    㾎 ϓϥΠϚϦʔΩʔɺϢχʔΫΩʔɺ֎෦Ωʔͷఆٛ
    㾎 ྻͷσʔλܕͷఆٛ
    ྻͷఆٛͰ͸ɺͭͷ͜ͱΛߦ͍·͢ɻ
    ྻͷఆٛ

    View full-size slide

  66. 66
    ϓϥΠϚϦʔΩʔɺϢχʔΫΩʔɺ֎෦Ωʔͷఆٛ
    ֤ΤϯςΟςΟʹ͍ͭͯɺ1,ɺϢχʔΫΩʔɺ֎෦ΩʔΛఆٛ͠·͢ɻ
    㾎 ϓϥΠϚϦʔΩʔͱ͸
    㾎 ϨίʔυΛҰҙʹಛఆ͢ΔͨΊͷΩʔ
    㾎 ఆٛ͸ʮϢχʔΫΩʔ/05/6--ʯ
    㾎 ύϑΥʔϚϯε؍఺͔Β֤ςʔϒϧʹϓϥΠϚϦΩʔΛ͚ͭΔ
    㾎 ϢχʔΫΩʔͱ͸
    㾎 ͭͷΤϯςΟςΟͷશϨίʔυͷதͰɺҰҙʹͳΔ஋
    㾎 /6--΋ೖΕΔ͜ͱ΋Մೳ
    㾎 ࣌ʑ࢖͏৔໘͕͋Δ
    㾎 ֎෦Ωʔͱ͸
    㾎 ΤϯςΟςΟؒͷϦϨʔγϣϯΛදݱ͢ΔΩʔ੍໿
    㾎 ࢖Θͳ͍ͷͰׂѪ͠·͢ʢϓϩδΣΫτํ਑ʹΑΔʣ
    㾎 ΤϯςΟςΟؒͷ੔߹ੑ͸ϓϩάϥϜͰอূ͢Δ

    View full-size slide

  67. 67
    㾎 ྻ໊ͷఆٛʢ࿦ཧ໊෺ཧ໊ʣ
    㾎 ϓϥΠϚϦʔΩʔɺϢχʔΫΩʔɺ֎෦Ωʔͷఆٛ
    㾎 ྻͷσʔλܕͷఆٛ
    ྻͷఆٛͰ͸ɺͭͷ͜ͱΛߦ͍·͢ɻ
    ྻͷఆٛ

    View full-size slide

  68. 68
    σʔλܕͷఆٛ
    ֤σʔλ߲໨ʹ͍ͭͯɺ֨ೲ͢Δσʔλʹ߹ΘͤͨܕΛఆٛ͠·͢ɻ
    ·ͨɺ֨ೲ͢Δσʔλྔʹ߹Θܻͤͨ਺ਫ਼౓΋ఆٛ͠·͢ɻ
    㾎 ਺஋ܕ
    㾎 */5%&$*."-%06#-&
    㾎 খ਺఺ΛؚΉֹۚ υϧ΍ϏοτίΠϯ
    ͷ৔߹ʹ͸ɺ%FDJNBMΛ࢖͏
    IUUQTEFWNZTRMDPNEPDSFGNBOKBEBUBUZQFPWFSWJFXIUNM
    㾎 ೔෇ܕ
    㾎 %"5&%"5&5*.&
    㾎 จࣈྻܕ
    㾎 $)"37"3$)"35&95#-0#

    View full-size slide

  69. 69
    ࿦ཧઃܭͷৼΓฦΓ
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ
    ✓ σʔλͷཧղ
    ✓ ྑ͍σʔλϕʔεઃܭͱ͸
    ✓ ΤϯςΟςΟͷఆٛ
    ✓ ϦϨʔγϣϯγοϓͷఆٛ
    ✓ σʔλ߲໨ͷఆٛ
    ✓ ྻͷఆٛ
    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  70. 70
    ࣮ݧ
    มߋʹڧ͍ʁ
    ౤ߘ
    *%
    λΠτϧ
    આ໌จ
    Ϣʔβʔ*%
    ஋ஈ
    ը૾63-
    Ϣʔβʔ
    *%
    ϩάΠϯ*%
    Ϣʔβʔ໊
    ύεϫʔυ
    ஀ੜ೔
    ͍͍Ͷ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    ϢʔβʔϑΥϩʔͷ࢓૊ΈΛೖΕΔͱͨ͠Βʁ

    View full-size slide

  71. 71
    ࣮ݧ
    มߋʹڧ͍ʁ
    ౤ߘ
    *%
    λΠτϧ
    આ໌จ
    Ϣʔβʔ*%
    ஋ஈ
    ը૾63-
    Ϣʔβʔ
    *%
    ϩάΠϯ*%
    Ϣʔβʔ໊
    ύεϫʔυ
    ஀ੜ೔
    ͍͍Ͷ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    ϑΥϩʔ
    Ϣʔβʔ*%
    ϑΥϩʔ*%
    ϢʔβʔϑΥϩʔͷ࢓૊ΈΛೖΕΔͱͨ͠Βʁ

    View full-size slide

  72. 72
    ࣮ݧ
    มߋʹڧ͍ʁ
    ౤ߘ
    *%
    λΠτϧ
    આ໌จ
    Ϣʔβʔ*%
    ஋ஈ
    ը૾63-
    Ϣʔβʔ
    *%
    ϩάΠϯ*%
    Ϣʔβʔ໊
    ύεϫʔυ
    ஀ੜ೔
    ͍͍Ͷ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    ౤ߘͷԼॻ͖ͷ࢓૊ΈΛೖΕΔͱͨ͠Βʁ

    View full-size slide

  73. 73
    ࣮ݧ
    มߋʹڧ͍ʁ
    ౤ߘ
    *%
    λΠτϧ
    આ໌จ
    Ϣʔβʔ*%
    ஋ஈ
    ը૾63-
    εςʔλε
    Ϣʔβʔ
    *%
    ϩάΠϯ*%
    Ϣʔβʔ໊
    ύεϫʔυ
    ஀ੜ೔
    ͍͍Ͷ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    ౤ߘͷԼॻ͖ͷ࢓૊ΈΛೖΕΔͱͨ͠Βʁ

    View full-size slide

  74. 74
    ࣮ݧ
    มߋʹڧ͍ʁ
    ౤ߘ
    *%
    λΠτϧ
    આ໌จ
    Ϣʔβʔ*%
    ஋ஈ
    ը૾63-
    Ϣʔβʔ
    *%
    ϩάΠϯ*%
    Ϣʔβʔ໊
    ύεϫʔυ
    ஀ੜ೔
    ͍͍Ͷ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    ౤ߘͷฤूཤྺͷ࢓૊ΈΛೖΕΔͱͨ͠Βʁ

    View full-size slide

  75. 75
    ࣮ݧ
    มߋʹڧ͍ʁ
    ౤ߘ
    *%
    λΠτϧ
    આ໌จ
    Ϣʔβʔ*%
    ஋ஈ
    ը૾63-
    Ϣʔβʔ
    *%
    ϩάΠϯ*%
    Ϣʔβʔ໊
    ύεϫʔυ
    ஀ੜ೔
    ͍͍Ͷ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    Ϣʔβʔ*%
    ౤ߘ*%
    ίϝϯτ
    ౤ߘཤྺ
    ౤ߘ*%
    SFW*%
    λΠτϧ
    આ໌จ
    ஋ஈ
    ը૾63-
    ౤ߘͷฤूཤྺͷ࢓૊ΈΛೖΕΔͱͨ͠Βʁ

    View full-size slide

  76. Physical design

    View full-size slide

  77. 77
    ෺ཧઃܭ
    㾎 ٻΊΒΕΔύϑΥʔϚϯεΛఏڙ͢Δ͜ͱ
    㾎 ҆ఆͨ͠ӡ༻͕Ͱ͖Δ͜ͱ
    ෺ཧઃܭͷ໨త͸ͭ͋Γ·͢ɻ

    View full-size slide

  78. 78
    ໨తʹରͯ͠खஈ͸ҎԼͷ௨ΓͰ͢ɻ
    ੑೳઃܭ
    σΟεΫ༰ྔͷݟੵ΋Γ
    ඇਖ਼نԽ΍ಋग़߲໨ͷ௥Ճ
    ΠϯσοΫεͷ࡞੒
    42-ͷνϡʔχϯά
    τϥϯβΫγϣϯͷ෼཭Ϩϕϧͷఆٛ
    ύʔςΟγϣϯԽ΍σΟεΫ෼ࢄ
    ҆ఆӡ༻
    ো֐ରԠઃܭ
    ؂ࢹઃܭ
    ϝϯςφϯεઃܭ
    ෺ཧઃܭ

    View full-size slide

  79. 79
    σΟεΫ༰ྔͷݟੵ΋Γ
    ໿όΠτߦ
    ᶃߦ͋ͨΓͷόΠτ਺
    ᶄ૿Ճྔ
    ໿ ݅೔
    ᶅඞཁόΠτ਺
    .#೔
    .#ϲ݄
    (#೥
    ˞૿Ճ͕ݟࠐ·ΕΔશςʔϒϧͰߦ͍·͢ɻ
    ˞IUUQTEFWNZTRMDPNEPDSFGNBOKBTUPSBHFSFRVJSFNFOUTIUNM
    σΟεΫ࢖༻ྔ͸ʮߦ͋ͨΓͷόΠτ਺ʷྻ਺ʯͰܭࢉ͠·͢ɻ
    ౤ߘςʔϒϧ

    View full-size slide

  80. 80
    ޕલதͷ෮श
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  81. 82
    ԋश
    ଔۀ੍࡞ʹ͍ͭͯσʔλϕʔεઃܭΛߦͬͯΈ·͠ΐ͏ɻ
    ˞ੵۃతʹॿ͚߹͍ͬͯͩ͘͞
    ✓ ݸਓϫʔΫɹ20෼

    ✓ σʔλͷཧղ

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ άϧʔϓϫʔΫɹ20෼

    ✓ νʔϜ಺ͰൃදˍϑΟʔυόοΫ

    ✓ શମൃදʢ1ʙ2໊ʣɹ20෼

    ✓ ൃද+࣭ٙԠ౴

    View full-size slide

  82. 84
    ·ͱΊ
    ✓ σʔλϕʔεઃܭͷશମ૾

    ✓ αϯϓϧΞϓϦͷ঺հ

    ✓ ࿦ཧઃܭ

    ✓ σʔλͷཧղ

    ✓ ྑ͍σʔλϕʔεઃܭͱ͸

    ✓ ΤϯςΟςΟͷఆٛ

    ✓ ϦϨʔγϣϯγοϓͷఆٛ

    ✓ σʔλ߲໨ͷఆٛ

    ✓ ྻͷఆٛ

    ✓ (ࢀߟ) ෺ཧઃܭ
    a.m. p.m.
    ✓ ݸਓԋशͱνʔϜԋश

    View full-size slide

  83. 85
    ͞Βʹֶͼ͍ͨਓ͸
    https://www.jitec.ipa.go.jp/1_11seido/db.html

    View full-size slide

  84. Thank you
    @yoheiMune

    View full-size slide