Search.setIndex({"docnames": ["01ModelingIntro/ModelingIntro", "01ModelingIntro/toctree", "02OneEntityShapes/OneEntityShapes", "02OneEntityShapes/toctree", "03TwoEntityShapes/AllInOne", "03TwoEntityShapes/TwoEntityShapes", "03TwoEntityShapes/be-be_Shapes", "03TwoEntityShapes/toctree", "04ThreeEntityShapes/IntersectionArbitraryId", "04ThreeEntityShapes/IntersectionShape", "04ThreeEntityShapes/toctree", "05IntroQuerying/00MasteringIntro", "05IntroQuerying/01Queying_Analysis", "05IntroQuerying/temp", "05IntroQuerying/toctree", "06Relations/00Definitions", "06Relations/01Connections", "06Relations/toctree", "07OperatorFramework/00Relations", "07OperatorFramework/01Operators_Charts", "07OperatorFramework/toctree", "08TinyDB/00creatureDBOverview", "08TinyDB/CreatureDB.sql", "08TinyDB/creatureDB_create_mysql.sql", "08TinyDB/creatureDB_mysql.sql", "08TinyDB/toctree", "09UnaryOps/00UnaryIntro", "09UnaryOps/01Filter", "09UnaryOps/02Project", "09UnaryOps/03Reduce", "09UnaryOps/04Group", "09UnaryOps/05UnaryFramework", "09UnaryOps/06UnaryExercises", "09UnaryOps/toctree", "10QueriesAfterUnary/00UnaryCombos", "10QueriesAfterUnary/toctree", "11SetOps/00SetIntro", "11SetOps/01UnionIntersectMinusSimple", "11SetOps/02UnionIntersectMinusAdvanced", "11SetOps/03Times", "11SetOps/04SetOpsFramework", "11SetOps/toctree", "12QueryAfterSet/00TimesFilterReduceEx", "12QueryAfterSet/toctree", "13MatchJoin/00MJIntro", "13MatchJoin/01Circumstances", "13MatchJoin/02TableOfCircumstances", "13MatchJoin/03DifferentBase_M_1_1", "13MatchJoin/04DifferentBase_M_1_2", "13MatchJoin/05DifferentBase_M_1_3", "13MatchJoin/06DifferentBase_M_M", "13MatchJoin/07SameBase_1_1_M_M", "13MatchJoin/08SameBase_1_1_E_E", "13MatchJoin/09SameBase_1_1", "13MatchJoin/10SameRelation_M_1", "13MatchJoin/11SameRelation_M_M", "13MatchJoin/12MatchJoinFramework", "13MatchJoin/toctree", "14OuterJoin/01OuterJoin", "14OuterJoin/02OJGeneric", "14OuterJoin/NotUsedOJTesting", "14OuterJoin/toctree", "15Divide/01Divide", "15Divide/NotUsedDivide_testing", "15Divide/toctree", "16CompareJoin/01CompareJoin", "16CompareJoin/toctree", "17CategoryRelations/01CategoryRelations", "17CategoryRelations/toctree", "WaysOfWork_under_construction/00WW_Intro", "WaysOfWork_under_construction/01Narratives", "index"], "filenames": ["01ModelingIntro/ModelingIntro.rst", "01ModelingIntro/toctree.rst", "02OneEntityShapes/OneEntityShapes.rst", "02OneEntityShapes/toctree.rst", "03TwoEntityShapes/AllInOne.rst", "03TwoEntityShapes/TwoEntityShapes.rst", "03TwoEntityShapes/be-be_Shapes.rst", "03TwoEntityShapes/toctree.rst", "04ThreeEntityShapes/IntersectionArbitraryId.rst", "04ThreeEntityShapes/IntersectionShape.rst", "04ThreeEntityShapes/toctree.rst", "05IntroQuerying/00MasteringIntro.rst", "05IntroQuerying/01Queying_Analysis.rst", "05IntroQuerying/temp.rst", "05IntroQuerying/toctree.rst", "06Relations/00Definitions.rst", "06Relations/01Connections.rst", "06Relations/toctree.rst", "07OperatorFramework/00Relations.rst", "07OperatorFramework/01Operators_Charts.rst", "07OperatorFramework/toctree.rst", "08TinyDB/00creatureDBOverview.rst", "08TinyDB/CreatureDB.sql", "08TinyDB/creatureDB_create_mysql.sql", "08TinyDB/creatureDB_mysql.sql", "08TinyDB/toctree.rst", "09UnaryOps/00UnaryIntro.rst", "09UnaryOps/01Filter.rst", "09UnaryOps/02Project.rst", "09UnaryOps/03Reduce.rst", "09UnaryOps/04Group.rst", "09UnaryOps/05UnaryFramework.rst", "09UnaryOps/06UnaryExercises.rst", "09UnaryOps/toctree.rst", "10QueriesAfterUnary/00UnaryCombos.rst", "10QueriesAfterUnary/toctree.rst", "11SetOps/00SetIntro.rst", "11SetOps/01UnionIntersectMinusSimple.rst", "11SetOps/02UnionIntersectMinusAdvanced.rst", "11SetOps/03Times.rst", "11SetOps/04SetOpsFramework.rst", "11SetOps/toctree.rst", "12QueryAfterSet/00TimesFilterReduceEx.rst", "12QueryAfterSet/toctree.rst", "13MatchJoin/00MJIntro.rst", "13MatchJoin/01Circumstances.rst", "13MatchJoin/02TableOfCircumstances.rst", "13MatchJoin/03DifferentBase_M_1_1.rst", "13MatchJoin/04DifferentBase_M_1_2.rst", "13MatchJoin/05DifferentBase_M_1_3.rst", "13MatchJoin/06DifferentBase_M_M.rst", "13MatchJoin/07SameBase_1_1_M_M.rst", "13MatchJoin/08SameBase_1_1_E_E.rst", "13MatchJoin/09SameBase_1_1.rst", "13MatchJoin/10SameRelation_M_1.rst", "13MatchJoin/11SameRelation_M_M.rst", "13MatchJoin/12MatchJoinFramework.rst", "13MatchJoin/toctree.rst", "14OuterJoin/01OuterJoin.rst", "14OuterJoin/02OJGeneric.rst", "14OuterJoin/NotUsedOJTesting.rst", "14OuterJoin/toctree.rst", "15Divide/01Divide.rst", "15Divide/NotUsedDivide_testing.rst", "15Divide/toctree.rst", "16CompareJoin/01CompareJoin.rst", "16CompareJoin/toctree.rst", "17CategoryRelations/01CategoryRelations.rst", "17CategoryRelations/toctree.rst", "WaysOfWork_under_construction/00WW_Intro.rst", "WaysOfWork_under_construction/01Narratives.rst", "index.rst"], "titles": ["<span class=\"section-number\">1.1. </span>Brief Background of Conceptual Data Modeling", "<span class=\"section-number\">1. </span>Beyond Conceptual Data Modeling", "<span class=\"section-number\">2.1. </span>One-entity shapes: begin to consider \u2018how\u2019", "<span class=\"section-number\">2. </span>From model to instances: One-entity shapes", "<span class=\"section-number\">3.7. </span>What we have seen so far", "<span class=\"section-number\">3.1. </span>Implementing Two-entity Shapes in relational databases", "<span class=\"section-number\">3.8. </span>One-One to-be relationship Shape", "<span class=\"section-number\">3. </span>Implementing relationships: Two-entity shapes", "<span class=\"section-number\">4.2. </span>The Chicken-feet-in Shape: an intersection with arbitrary identifier", "<span class=\"section-number\">4.1. </span>The Chicken-feet-in Shape: implementing an intersection", "<span class=\"section-number\">4. </span>Implementing relationships: Three-entity shapes", "<span class=\"section-number\">5.1. </span>Mastering relational data analysis", "<span class=\"section-number\">5.4. </span>What We Mean by Querying and Analysis", "&lt;no title&gt;", "<span class=\"section-number\">5. </span>Relational Databases, Querying, and Analysis", "<span class=\"section-number\">6.1. </span>The Essence of Relational Databases", "<span class=\"section-number\">6.2. </span>Connections between Relations", "<span class=\"section-number\">6. </span>Relational Data", "<span class=\"section-number\">7.1. </span>Relations as input and output", "<span class=\"section-number\">7.2. </span>Precedence Charts", "<span class=\"section-number\">7. </span>Relational Operations and Precedence Charts", "<span class=\"section-number\">8.1. </span>A small example database", "&lt;no title&gt;", "&lt;no title&gt;", "&lt;no title&gt;", "<span class=\"section-number\">8. </span>A Small Example Database", "<span class=\"section-number\">9.1. </span>Unary Operator Introduction", "<span class=\"section-number\">9.2. </span>Filter", "<span class=\"section-number\">9.3. </span>Project", "<span class=\"section-number\">9.4. </span>Reduce", "<span class=\"section-number\">9.5. </span>Group", "<span class=\"section-number\">9.6. </span>Summary of Unary Operators", "<span class=\"section-number\">9.7. </span>Exercises for Unary Operators", "<span class=\"section-number\">9. </span>The Unary Operators", "<span class=\"section-number\">10.1. </span>Combination Queries to Consider After Unary Operators", "<span class=\"section-number\">10. </span>Combining the Unary Operators", "<span class=\"section-number\">11.1. </span>Introduction to the Binary Set Operations", "<span class=\"section-number\">11.2. </span>Simplest Examples of Union, Intersect, and Minus", "<span class=\"section-number\">11.3. </span>Complex Examples of Union, Intersect, and Minus", "<span class=\"section-number\">11.4. </span>Times", "<span class=\"section-number\">11.5. </span>Summary of Binary Set Operators", "<span class=\"section-number\">11. </span>The Binary Set Operators", "<span class=\"section-number\">12.1. </span>An often-used Combination", "<span class=\"section-number\">12. </span>Putting pieces together", "<span class=\"section-number\">13.1. </span>Introduction to Match Join", "<span class=\"section-number\">13.2. </span>Circumstances For Match Joins", "<span class=\"section-number\">13.3. </span>The Common Circumstances", "<span class=\"section-number\">13.4. </span>Different Base A and B, M - 1 match over cols Aid(D), Bid(E)", "<span class=\"section-number\">13.5. </span>Different Base A and B, M - 1 match over cols Aid(D),Bid(M)", "<span class=\"section-number\">13.6. </span>Different Base A and B, M - 1 match over cols Aid(S),Bid(E)", "<span class=\"section-number\">13.7. </span>Different Base A and B, M - M match over cols Aid(D),Bid(D)", "<span class=\"section-number\">13.8. </span>Same Base A and B, 1 - 1 match over cols Aid(M),Bid(M)", "<span class=\"section-number\">13.9. </span>Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)", "<span class=\"section-number\">13.10. </span>Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)", "<span class=\"section-number\">13.11. </span>Same Relation A and B, M - 1 match over cols Aid(D),Bid(E)", "<span class=\"section-number\">13.12. </span>Same Relation A and B, M - M match over cols Aid(D),Bid(D)", "<span class=\"section-number\">13.13. </span>Match Join Framework", "<span class=\"section-number\">13. </span>The Match Join Operator", "<span class=\"section-number\">14.1. </span>Outer Join by Examples", "<span class=\"section-number\">14.2. </span>A Generic Version of OuterJoin", "Test of Outer Join", "<span class=\"section-number\">14. </span>The Outer Join Operator", "<span class=\"section-number\">15.1. </span>Divide Operator: two types", "Joe Celko\u2019s page examples", "<span class=\"section-number\">15. </span>The Divide Operator", "<span class=\"section-number\">16.1. </span>A Variation: Compare Join", "<span class=\"section-number\">16. </span>Compare Join", "<span class=\"section-number\">17.1. </span>Category Relations", "<span class=\"section-number\">17. </span>Category Relations", "Ways of Work", "Ways of Forming Query Narratives", "Mastering Relational Databases: from Models to Querying"], "terms": {"modelingintro": 0, "what": [0, 2, 5, 7, 8, 9, 11, 14, 15, 16, 19, 20, 21, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 53, 54, 56, 58, 62, 67, 69, 70], "Not": [0, 37], "how": [0, 3, 5, 6, 8, 9, 11, 12, 16, 18, 19, 21, 27, 28, 29, 30, 31, 32, 34, 36, 37, 38, 39, 40, 42, 44, 46, 49, 51, 52, 54, 55, 57, 58, 62, 65, 67, 69, 70, 71], "The": [0, 2, 10, 11, 14, 16, 18, 19, 21, 22, 24, 26, 28, 29, 30, 31, 32, 34, 36, 37, 38, 39, 40, 42, 45, 47, 48, 49, 50, 51, 52, 53, 56, 58, 59, 62, 65, 67, 69, 71], "most": [0, 5, 12, 15, 29, 34, 36, 38, 42, 44, 45, 48, 58, 62, 67, 71], "import": [0, 8, 9, 11, 15, 21, 27, 29, 30, 34, 37, 39, 41, 44, 45, 48, 52, 53, 58, 62, 67, 70], "aspect": [0, 2, 12, 36, 39, 44, 56, 57, 65, 70], "rememb": [0, 5, 6, 8, 9, 12, 15, 26, 28, 30, 32, 34, 45, 47], "about": [0, 2, 5, 7, 9, 11, 12, 15, 18, 21, 30, 32, 33, 34, 37, 38, 41, 44, 45, 46, 49, 51, 52, 62, 65, 67, 69, 71], "i": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 19, 20, 21, 26, 27, 28, 31, 32, 33, 34, 36, 37, 38, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58, 59, 62, 65, 67, 69, 70], "thei": [0, 9, 11, 12, 15, 16, 26, 27, 29, 32, 36, 38, 40, 42, 44, 45, 48, 49, 51, 52, 53, 58, 62, 65, 67, 69, 70], "ar": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 22, 24, 26, 27, 28, 30, 32, 33, 34, 36, 37, 38, 39, 40, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 56, 58, 59, 62, 65, 67, 69, 70, 71], "graphic": [0, 12, 71], "diagram": [0, 2, 14, 15, 21, 26, 27, 29, 34, 47, 59, 71], "depict": [0, 8, 9, 15, 19, 65], "someon": [0, 27], "want": [0, 2, 5, 6, 9, 12, 15, 27, 28, 29, 30, 34, 36, 44, 45, 51, 53, 58, 62, 65, 67, 69, 71], "store": [0, 8, 11, 12, 58, 71], "databas": [0, 2, 7, 8, 9, 11, 12, 16, 17, 18, 24, 27, 28, 29, 34, 36, 38, 39, 44, 45, 46, 47, 48, 49, 51, 52, 53, 58, 67, 69, 70], "later": [0, 2, 5, 6, 11, 12, 15, 16, 18, 19, 26, 27, 30, 39, 42, 44, 58, 62, 69, 71], "analysi": [0, 15, 21, 62, 67, 69, 71], "do": [0, 2, 5, 6, 11, 12, 15, 18, 19, 21, 22, 24, 26, 27, 28, 29, 32, 34, 36, 38, 40, 42, 45, 46, 47, 51, 52, 53, 54, 58, 62, 69, 71], "indic": [0, 5, 6, 9, 15, 18, 27, 32, 36, 37, 38, 40, 44, 45, 49], "therefor": [0, 18, 19, 34, 44, 47, 51, 53, 54, 71], "abstract": [0, 2, 57], "level": [0, 12, 16, 38, 67, 69, 70], "detail": [0, 2, 5, 11, 12, 15, 27, 42, 44, 46, 47, 56, 62, 71], "underli": [0, 39, 65, 67], "thi": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 22, 23, 24, 26, 27, 28, 30, 31, 32, 33, 34, 36, 37, 38, 39, 40, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 54, 55, 58, 59, 62, 65, 67, 69, 70], "book": [0, 11, 12, 15, 18, 19, 21, 27, 34, 39, 52, 58, 62, 65], "fragment": [0, 8, 9, 19, 21, 47, 48, 49, 50, 52, 54, 56, 58], "veri": [0, 19, 27, 36, 37, 39, 42, 44, 58, 62, 67, 69], "simpl": [0, 11, 12, 15, 19, 28, 29, 30, 34, 36, 37, 38, 39, 62, 71], "us": [0, 2, 5, 8, 9, 11, 12, 15, 16, 18, 19, 21, 24, 26, 27, 28, 29, 30, 31, 32, 35, 36, 37, 39, 40, 41, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55, 56, 58, 59, 62, 65, 67, 69, 70, 71], "logic": [0, 27, 39, 47, 48, 49, 71], "structur": [0, 11, 12, 15, 18, 27, 28, 29, 30, 36, 39, 71], "ld": [0, 5, 49, 50, 52, 58, 71], "notat": [0, 2, 12, 71], "present": [0, 2, 12, 27, 34, 36, 39, 46, 47, 56, 62, 69, 71], "master": [0, 2, 12, 14, 15, 21, 28, 30, 32, 47, 62, 65, 69], "A": [0, 9, 11, 12, 15, 16, 18, 19, 22, 24, 28, 29, 30, 32, 33, 34, 36, 37, 38, 39, 40, 42, 44, 45, 46, 57, 61, 62, 66, 67, 71], "user": [0, 2, 8, 11, 12, 15, 16, 28, 69, 70, 71], "driven": [0, 71], "approach": [0, 71], "john": [0, 71], "carli": [0, 2, 12, 21, 22, 24, 27, 28, 29, 30, 34, 45, 58, 71], "joseph": [0, 71], "maguir": [0, 2, 71], "addison": [0, 71], "weslei": [0, 71], "profession": [0, 2, 11, 71], "2000": [0, 71], "isbn": [0, 71], "9780134176536": [0, 71], "an": [0, 2, 5, 6, 10, 11, 12, 15, 16, 18, 19, 27, 29, 30, 32, 34, 36, 38, 39, 40, 41, 43, 45, 47, 48, 51, 52, 53, 55, 57, 58, 59, 62, 65, 67, 69, 70, 71], "excel": [0, 67], "tool": [0, 14, 26, 27, 37, 38, 39, 65], "end": [0, 5, 6, 14, 19, 22, 23, 24, 27, 34, 39, 45, 47, 48, 49, 58, 59, 62], "so": [0, 2, 5, 7, 8, 9, 11, 12, 15, 18, 19, 22, 24, 26, 27, 28, 29, 30, 32, 34, 36, 39, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 58, 62, 65, 67, 69], "you": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 26, 27, 28, 29, 30, 31, 32, 34, 36, 37, 38, 39, 40, 42, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 56, 58, 62, 65, 67, 69, 70, 71], "get": [0, 2, 5, 12, 16, 18, 27, 28, 29, 30, 34, 37, 38, 42, 45, 53, 55, 58, 62, 65, 67, 69, 71], "essenc": [0, 17, 65], "have": [0, 2, 5, 6, 7, 8, 9, 11, 12, 15, 16, 18, 19, 21, 22, 24, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 56, 58, 59, 62, 65, 67, 69, 71], "without": [0, 22, 23, 24, 34, 65], "worri": [0, 27], "when": [0, 2, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 42, 44, 45, 47, 48, 52, 53, 54, 56, 58, 59, 62, 65, 69, 70, 71], "we": [0, 2, 5, 6, 7, 8, 9, 11, 14, 15, 16, 18, 19, 21, 24, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 40, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58, 59, 62, 67, 69, 70, 71], "avoid": [0, 12, 29, 30, 35], "think": [0, 12, 15, 18, 19, 21, 28, 30, 33, 38, 40, 45, 46, 49, 51, 65, 67, 69, 71], "much": [0, 2, 11, 12, 15, 18, 27, 30, 34, 42, 44, 62, 65, 67], "possibl": [0, 2, 8, 28, 32, 34, 39, 42, 49, 59, 65, 67, 71], "howev": [0, 2, 6, 11, 12, 16, 30, 34, 36, 39, 47, 52, 53, 58, 62, 67, 69], "know": [0, 2, 5, 6, 12, 18, 28, 29, 32, 34, 42, 45, 47, 49, 51, 54, 62, 70], "bit": [0, 8, 32, 38, 47, 51, 65], "relat": [0, 2, 7, 19, 21, 26, 27, 28, 30, 32, 34, 36, 37, 38, 40, 41, 42, 45, 46, 47, 48, 49, 50, 51, 52, 53, 57, 58, 59, 62, 65, 69], "help": [0, 2, 11, 12, 18, 26, 27, 29, 34, 36, 37, 38, 42, 45, 47, 49, 51, 67, 71], "see": [0, 2, 6, 11, 12, 15, 16, 18, 19, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 42, 45, 47, 50, 51, 54, 58, 62, 65, 67, 69, 70, 71], "why": [0, 11, 15, 18, 28, 29, 30, 32, 34, 36, 39, 40, 44, 47, 49, 51, 54, 62], "mani": [0, 6, 8, 9, 11, 12, 16, 29, 30, 32, 34, 39, 42, 44, 45, 47, 49, 53, 54, 58, 59, 62, 65, 67, 69, 71], "guidelin": [0, 18], "suggest": [0, 19, 26, 28, 32, 34, 44, 50, 71], "abov": [0, 2, 5, 6, 8, 9, 12, 15, 18, 19, 21, 26, 27, 28, 30, 32, 34, 36, 37, 38, 39, 42, 44, 45, 47, 48, 49, 50, 53, 54, 58, 62, 65, 67], "becom": [0, 12, 15, 18, 29, 30, 39, 44, 45, 47, 49, 53, 58], "good": [0, 12, 18, 27, 32, 34, 45, 47, 62, 67, 71], "practic": [0, 2, 11, 14, 18, 21, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 40, 42, 44, 47, 49, 62, 65, 71], "creat": [0, 2, 6, 7, 8, 9, 11, 12, 16, 18, 21, 22, 23, 24, 27, 34, 36, 37, 38, 39, 42, 44, 46, 47, 48, 50, 51, 52, 53, 55, 58, 62, 65, 67, 71], "make": [0, 2, 5, 9, 11, 12, 19, 21, 26, 27, 28, 29, 32, 34, 37, 38, 42, 45, 47, 48, 49, 50, 51, 53, 54, 58, 62, 69, 71], "easi": [0, 15, 19, 27, 30, 36, 58], "directli": [0, 15], "its": [0, 5, 9, 11, 12, 15, 18, 27, 28, 29, 30, 32, 39, 44, 45, 46, 47, 48, 49, 52, 53, 54, 55, 56, 58, 62, 65, 67, 69, 71], "associ": [0, 8, 62], "sampl": [0, 5, 21], "instanc": [0, 6, 7, 8, 9, 11, 12, 15, 16, 18, 21, 24, 27, 36, 38, 53, 58, 71], "obtain": [0, 11, 36, 42, 44, 49, 50, 58], "work": [0, 2, 8, 11, 12, 15, 18, 19, 21, 26, 27, 29, 30, 31, 35, 36, 37, 39, 40, 46, 47, 48, 49, 50, 51, 52, 53, 58, 62, 67, 70, 71], "In": [0, 5, 6, 8, 9, 11, 15, 16, 21, 22, 24, 26, 27, 28, 29, 30, 32, 34, 37, 38, 39, 42, 44, 47, 48, 51, 52, 53, 54, 55, 58, 62, 65, 67, 69, 70, 71], "first": [0, 2, 9, 11, 15, 18, 19, 22, 24, 27, 28, 29, 30, 32, 35, 36, 37, 38, 39, 42, 44, 45, 46, 47, 48, 49, 53, 54, 55, 56, 59, 61, 62, 65, 67, 69, 70, 71], "part": [0, 8, 11, 12, 15, 18, 45, 48, 62], "start": [0, 2, 8, 18, 19, 21, 26, 27, 28, 34, 36, 37, 39, 44, 49, 51, 62, 65, 67, 69, 71], "practition": [0, 39], "learn": [0, 11, 12, 15, 18, 19, 21, 30, 39, 47, 62, 71], "task": [0, 12, 70, 71], "next": [0, 2, 6, 8, 9, 11, 15, 18, 19, 21, 27, 28, 32, 34, 36, 37, 39, 44, 45, 47, 49, 54, 58, 62, 70], "few": [0, 9, 11, 15, 30, 32, 34, 45, 49, 58, 62], "chapter": [0, 2, 4, 15, 16, 21, 26, 27, 31, 34, 36, 37, 38, 39, 40, 44, 51, 54, 55, 58, 65, 67, 69, 71], "intend": [0, 71], "companion": 0, "one": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 22, 24, 26, 27, 28, 29, 32, 33, 34, 36, 37, 38, 39, 40, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 54, 55, 58, 59, 62, 67], "like": [0, 2, 4, 5, 9, 12, 15, 18, 19, 26, 27, 28, 29, 32, 33, 34, 36, 37, 38, 39, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 58, 59, 62, 67, 70], "which": [0, 5, 6, 8, 11, 12, 15, 18, 21, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 42, 44, 45, 46, 47, 49, 50, 52, 53, 54, 56, 58, 59, 62, 65, 67, 69, 71], "likewis": [0, 15], "step": [0, 2, 28, 34, 39, 45, 49, 51, 53, 59, 62, 67], "stone": 0, "2": [0, 2, 6, 11, 15, 18, 21, 22, 24, 27, 28, 29, 32, 33, 34, 38, 40, 41, 42, 44, 45, 47, 48, 49, 58, 62, 65, 67, 70], "where": [0, 8, 11, 12, 19, 22, 24, 27, 29, 30, 34, 37, 38, 39, 40, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 55, 58, 59, 62, 65, 67, 69], "examin": [0, 2, 5, 9, 12, 21, 34, 37, 38, 44, 45, 50, 62, 67, 69, 70], "extract": [0, 11, 69], "inform": [0, 36, 45, 55, 58, 68], "been": [0, 5, 11, 12, 29, 34, 37, 44, 53, 58, 62, 65, 71], "abl": [0, 12, 34, 47, 48, 51, 56, 67, 69, 71], "toctre": [1, 3, 7, 10, 14, 17, 20, 25, 33, 35, 41, 43, 57, 61, 64, 66, 68], "brief": [1, 42, 44, 67], "background": [1, 11], "transit": 1, "from": [1, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 42, 44, 45, 47, 49, 50, 51, 52, 54, 55, 56, 58, 59, 62, 65, 67, 69, 70], "implement": [1, 2, 6, 18, 27, 50, 51, 52, 62, 69, 71], "oneentityshap": 2, "conceptu": [2, 5, 8, 9, 16, 18, 21, 44, 45, 46, 47, 48, 50, 52, 54, 56, 58], "model": [2, 5, 8, 9, 16, 18, 44, 50, 62], "design": [2, 11, 71], "can": [2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 22, 23, 24, 26, 27, 28, 29, 30, 31, 32, 34, 36, 37, 38, 39, 40, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 58, 59, 62, 67, 69, 70, 71], "awai": [2, 28, 44], "concentr": [2, 44, 54, 71], "need": [2, 6, 8, 11, 12, 15, 18, 19, 22, 23, 24, 26, 27, 29, 34, 36, 37, 38, 42, 44, 45, 47, 50, 54, 62, 65, 69, 70], "repres": [2, 6, 8, 9, 15, 21, 28, 29, 38, 39, 45, 48, 49, 51, 58, 62, 70], "As": [2, 6, 11, 12, 18, 21, 26, 27, 28, 30, 34, 39, 44, 45, 50, 58, 59, 62, 69, 71], "after": [2, 4, 8, 9, 11, 12, 27, 28, 29, 30, 32, 35, 42, 45, 48, 53, 58, 62, 70, 71], "your": [2, 11, 12, 15, 18, 19, 21, 26, 27, 28, 29, 31, 32, 34, 36, 38, 39, 40, 42, 44, 45, 49, 51, 62, 65, 69, 70, 71], "studi": [2, 12, 21, 28, 30, 37, 39, 42, 45, 49, 58, 62], "some": [2, 5, 7, 8, 9, 11, 12, 15, 16, 18, 21, 22, 24, 26, 27, 29, 30, 32, 33, 34, 36, 37, 39, 41, 42, 44, 45, 46, 47, 49, 51, 52, 56, 59, 62, 65, 67, 69, 71], "reason": [2, 12, 29, 32, 34, 36, 51, 58, 65, 69], "record": [2, 12, 15, 70], "match": [2, 18, 21, 22, 24, 27, 32, 36, 38, 39, 42, 58, 59, 65, 67, 71], "sql": [2, 4, 6, 9, 11, 14, 16, 21, 22, 23, 24, 27, 28, 29, 30, 32, 35, 36, 37, 38, 39, 42, 45, 47, 48, 49, 50, 51, 52, 53, 54, 58, 62, 65, 67], "here": [2, 4, 5, 8, 9, 11, 12, 13, 15, 16, 18, 21, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 42, 44, 45, 47, 50, 51, 52, 55, 58, 59, 62, 65, 67, 71], "normal": [2, 58, 59, 67], "share": [2, 11, 47, 62], "more": [2, 4, 5, 8, 11, 12, 13, 15, 16, 18, 19, 21, 26, 27, 28, 29, 32, 34, 36, 37, 38, 39, 44, 45, 47, 48, 49, 50, 51, 53, 56, 58, 64, 65, 67, 69, 71], "them": [2, 8, 9, 11, 12, 21, 26, 27, 29, 30, 32, 34, 36, 38, 40, 42, 44, 46, 47, 49, 51, 56, 65, 67, 69, 71], "becaus": [2, 6, 8, 11, 12, 18, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 40, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 58, 59, 62, 65, 67, 71], "hide": [2, 32], "reveal": [2, 32], "anoth": [2, 6, 8, 12, 16, 26, 29, 34, 37, 41, 42, 48, 49, 53, 58, 62, 65, 67, 71], "least": [2, 11, 15, 32, 34, 45, 59, 64], "both": [2, 9, 11, 12, 15, 16, 21, 27, 34, 36, 38, 44, 45, 52, 61, 62, 65, 69], "underneath": 2, "separ": [2, 6, 9, 16, 28, 29, 42, 58], "client": [2, 32, 34, 67, 70], "let": [2, 5, 6, 8, 9, 15, 18, 21, 22, 24, 26, 27, 28, 30, 32, 33, 34, 37, 38, 39, 44, 45, 48, 49, 51, 53, 54, 55, 58, 62, 65, 67], "": [2, 5, 6, 8, 9, 11, 12, 15, 18, 19, 21, 22, 24, 26, 27, 28, 30, 32, 33, 34, 37, 38, 39, 40, 42, 44, 45, 46, 47, 48, 50, 51, 53, 54, 55, 56, 57, 58, 62, 65, 67, 69], "singl": [2, 5, 11, 12, 16, 30, 34, 37, 38, 42, 44, 53, 54, 62], "If": [2, 12, 18, 21, 27, 29, 30, 32, 34, 37, 40, 44, 45, 47, 53, 58, 62, 65, 71], "read": [2, 9, 12, 15, 19, 21, 28, 30, 32, 36, 42, 45, 71], "should": [2, 5, 6, 9, 12, 15, 18, 21, 27, 28, 29, 30, 31, 32, 34, 37, 40, 45, 47, 49, 52, 58, 62, 69, 70, 71], "familiar": [2, 21, 34, 36, 49, 70], "yet": [2, 5, 11, 27, 29, 34, 38, 39, 40, 47, 50, 58, 62], "slightli": [2, 34, 39, 48, 49, 62, 65], "differ": [2, 6, 8, 11, 12, 15, 16, 18, 19, 21, 22, 24, 26, 27, 28, 29, 30, 32, 34, 36, 38, 40, 42, 44, 45, 46, 51, 57, 58, 62, 65, 67, 70, 71], "now": [2, 5, 9, 12, 18, 21, 22, 26, 27, 29, 30, 32, 37, 38, 39, 40, 45, 47, 48, 49, 50, 51, 53, 55, 58, 59, 62, 65, 67], "spot": [2, 34, 47], "doe": [2, 5, 8, 14, 15, 16, 18, 26, 27, 32, 36, 38, 39, 40, 42, 58, 62, 65, 69], "tell": [2, 50], "u": [2, 5, 6, 9, 18, 22, 24, 26, 28, 29, 30, 32, 34, 37, 39, 42, 44, 45, 47, 48, 49, 50, 58, 67], "type": [2, 8, 9, 11, 12, 15, 16, 18, 21, 27, 30, 36, 37, 38, 39, 44, 47, 51, 52, 58, 64, 67, 70], "each": [2, 5, 8, 9, 12, 15, 16, 18, 19, 21, 26, 27, 28, 29, 30, 31, 32, 34, 36, 37, 38, 39, 40, 42, 44, 45, 47, 48, 49, 50, 51, 52, 54, 55, 58, 62, 65, 67, 70], "attribut": [2, 5, 6, 8, 9, 15, 30, 32], "would": [2, 4, 5, 6, 9, 15, 19, 27, 29, 30, 32, 34, 44, 47, 48, 53, 58, 62, 65, 67, 70, 71], "look": [2, 5, 6, 8, 9, 12, 19, 26, 27, 28, 29, 30, 34, 38, 39, 44, 45, 47, 48, 49, 51, 52, 53, 54, 55, 56, 58, 62, 65, 70, 71], "explor": [2, 21, 44], "creatureid": [2, 9, 11, 12, 16, 18, 21, 22, 23, 24, 27, 28, 29, 30, 32, 34, 37, 38, 42, 45, 47, 48, 49, 50, 51, 53, 54, 58, 62, 65, 67], "creaturenam": [2, 16, 21, 22, 23, 24, 27, 28, 29, 30, 45], "creaturetyp": [2, 16, 21, 22, 23, 24, 27, 28, 29, 30, 45], "creatureresidetown": 2, "1": [2, 9, 11, 12, 15, 18, 21, 22, 24, 27, 28, 29, 32, 33, 34, 37, 38, 41, 42, 45, 46, 57, 59, 62, 65, 67], "bannon": [2, 5, 18, 21, 22, 24, 27, 28, 29, 30, 45], "person": [2, 6, 21, 22, 24, 27, 28, 29, 30, 32, 34, 45, 47, 48, 58, 62, 65, 67], "philli": [2, 22, 24, 29], "myer": [2, 21, 22, 24, 27, 28, 29, 30, 45], "anoka": [2, 22, 24, 29], "3": [2, 9, 11, 16, 18, 21, 22, 23, 24, 27, 28, 29, 32, 33, 34, 38, 42, 45, 47, 48, 49, 52, 56, 62, 67], "neff": [2, 21, 22, 24, 27, 28, 29, 30, 45], "blue": [2, 22, 24, 29], "earth": [2, 22, 24, 29], "4": [2, 6, 11, 15, 21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 53, 54, 62, 65, 67], "bemidji": [2, 5, 22, 24, 29, 51], "5": [2, 9, 15, 21, 22, 24, 27, 28, 29, 30, 32, 34, 37, 38, 42, 45, 47, 48, 49, 53, 62, 65, 67, 71], "mieska": [2, 21, 22, 24, 27, 28, 29, 30, 45], "duluth": [2, 22, 24, 29, 62], "6": [2, 21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 53, 56, 58, 62, 65, 67], "edina": 2, "7": [2, 15, 21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 65, 67], "kermit": [2, 21, 22, 24, 27, 28, 29, 30, 45, 62], "frog": [2, 21, 22, 24, 27, 28, 29, 30, 38, 45], "greenvil": [2, 22, 24, 29], "8": [2, 15, 16, 21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 52, 62, 65, 67], "godzilla": [2, 21, 22, 24, 27, 28, 29, 30, 45], "monster": [2, 21, 22, 24, 27, 28, 29, 30, 45], "tokyo": [2, 22, 24, 29], "9": [2, 21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 65, 67], "thor": [2, 21, 22, 24, 27, 28, 29, 30, 45, 62], "superhero": [2, 21, 22, 24, 27, 28, 29, 30, 45], "asgard": [2, 22, 24, 29], "whose": [2, 6, 9, 27, 28, 32, 34, 37, 38, 44, 45, 47, 48, 50, 53, 54, 58, 62, 67, 71], "text": [2, 8, 15, 22, 28, 42, 44], "string": [2, 8], "shown": [2, 5, 6, 8, 15, 18, 19, 28, 29, 30, 34, 37, 44, 45, 47, 48, 49, 50, 53, 56, 58, 59, 62, 65], "quot": [2, 22, 23, 24, 27, 36], "number": [2, 15, 18, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 48, 49, 58, 62], "hold": [2, 15, 37], "code": [2, 11, 21, 27, 29, 30, 34, 38, 42, 45, 52, 58, 62, 65], "carefulli": [2, 18, 21, 29, 37, 42, 47, 58, 62], "note": [2, 5, 7, 8, 9, 11, 12, 18, 19, 21, 22, 24, 27, 29, 30, 32, 33, 34, 38, 39, 42, 44, 47, 48, 49, 50, 51, 52, 54, 55, 58, 59, 62, 65, 67, 71], "run": [2, 5, 28, 30, 34, 38, 39, 58, 62, 65, 71], "noth": [2, 5, 29, 30, 32], "appear": [2, 5, 13, 15, 19, 27, 34, 37, 39, 47, 48, 58, 65], "happen": [2, 5, 29, 30, 32, 45, 67], "sinc": [2, 5, 11, 12, 16, 18, 24, 27, 28, 29, 30, 32, 39, 44, 48, 49, 51, 58, 67], "all": [2, 4, 5, 6, 8, 11, 12, 15, 19, 26, 27, 28, 29, 30, 31, 34, 39, 40, 41, 42, 44, 45, 47, 48, 49, 54, 56, 58, 59, 62, 65, 67, 69, 71], "place": [2, 4, 12, 18, 28, 30, 34, 58, 65, 70], "row": [2, 11, 12, 15, 16, 18, 21, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 44, 45, 48, 49, 51, 58, 62], "insert": [2, 5, 8, 9, 21, 22, 24, 28, 46, 58], "particular": [2, 6, 8, 9, 15, 16, 24, 27, 28, 29, 30, 38, 44, 45, 51, 62, 65, 67], "map": [2, 5, 16, 21, 38, 52, 71], "final": [2, 12], "someth": [2, 6, 15, 32, 58, 67, 69], "back": [2, 5, 28, 30, 34, 36, 49, 52, 53], "includ": [2, 6, 8, 11, 28, 30, 34, 38, 39, 42, 44, 47, 56, 58, 59, 65, 71], "everi": [2, 8, 12, 15, 18, 27, 28, 30, 37, 53, 58], "valu": [2, 5, 8, 9, 11, 12, 15, 16, 18, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 49, 53, 57, 58, 59, 62, 65, 67, 70], "often": [2, 8, 12, 15, 27, 28, 30, 36, 39, 43, 44, 45, 46, 47, 49, 58, 69], "refer": [2, 5, 8, 16, 18, 21, 22, 23, 24, 29, 31, 36, 40, 47, 51, 62, 65, 71], "column": [2, 5, 6, 8, 9, 11, 15, 16, 18, 19, 26, 27, 32, 33, 34, 36, 37, 39, 40, 41, 42, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 57, 59, 61, 62, 65, 67], "correspond": [2, 16, 27, 28, 29, 30, 34, 36, 38, 39, 44, 45, 46, 51, 52, 53, 56, 62], "wai": [2, 6, 8, 9, 11, 12, 15, 16, 21, 27, 28, 30, 32, 34, 36, 37, 38, 42, 47, 48, 53, 58, 62, 65, 67], "With": [2, 27, 29, 32, 38, 40, 49, 51, 70, 71], "follow": [2, 5, 6, 8, 9, 12, 15, 19, 21, 26, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 42, 44, 45, 46, 47, 49, 52, 54, 56, 58, 62, 65, 67, 69, 70, 71], "choos": [2, 6, 11, 12, 15, 28, 29, 32, 34, 45, 47, 52, 67], "subset": 2, "pitfal": 2, "syntax": [2, 8, 11, 12, 37, 47, 48, 49, 54, 55, 58, 62, 71], "For": [2, 5, 9, 12, 15, 16, 18, 21, 26, 27, 28, 29, 30, 32, 34, 38, 47, 49, 51, 53, 54, 57, 62, 69, 70], "best": [2, 22, 24, 29, 34, 42, 62], "stick": [2, 11], "asterisk": [2, 27, 30], "show": [2, 8, 16, 27, 29, 31, 32, 34, 36, 39, 40, 42, 44, 45, 47, 50, 52, 58, 62, 65, 67, 70], "displai": [2, 11, 12, 29, 32, 39, 49, 58], "result": [2, 11, 12, 15, 19, 20, 22, 24, 26, 27, 28, 30, 32, 33, 34, 36, 37, 38, 39, 40, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 54, 58, 62, 65, 67, 71], "go": [2, 15, 27, 37, 38, 39, 42, 44, 45, 47, 62, 67, 71], "previou": [2, 8, 27, 28, 30, 31, 32, 34, 36, 37, 40, 44, 45, 46, 48, 49, 50, 51, 52, 59, 62], "ad": [2, 5, 8, 11, 19, 30, 38, 48, 59], "command": [2, 5, 8, 11, 12, 21, 27], "begin": [3, 14, 18, 21, 27, 34, 37, 38, 40, 44, 45, 71], "consid": [3, 8, 9, 11, 15, 27, 28, 29, 30, 32, 35, 39, 40, 53, 57, 58, 70], "creatur": [3, 6, 7, 8, 9, 12, 16, 22, 23, 24, 32, 34, 36, 37, 38, 39, 42, 44, 46, 47, 48, 49, 50, 51, 53, 54, 55, 56, 58, 62, 65, 67, 70], "data": [3, 4, 7, 8, 9, 12, 14, 16, 18, 21, 27, 28, 29, 30, 31, 32, 34, 37, 38, 40, 44, 45, 46, 47, 48, 49, 52, 53, 54, 56, 58, 59, 62, 65, 70], "tabl": [3, 6, 7, 8, 9, 12, 14, 15, 16, 18, 21, 22, 23, 24, 29, 30, 31, 32, 38, 39, 40, 44, 45, 46, 47, 52, 56, 58, 67], "creation": [3, 4, 5, 6, 15, 16, 21, 22, 24, 42], "popul": [3, 7, 15, 21], "try": [3, 4, 6, 15, 21, 22, 24, 26, 27, 28, 29, 30, 32, 34, 37, 38, 39, 42, 45, 48, 51, 53, 57, 64, 66, 68, 71], "yourself": [3, 12, 21, 29, 34, 39, 64], "allinon": 4, "complet": [4, 19, 21, 30, 34, 39, 42, 45, 47, 62, 65, 67, 70, 71], "version": [4, 24, 27, 32, 39, 58, 61, 62], "statement": [4, 6, 9, 16, 21, 34, 65, 69], "download": [4, 21, 29, 31, 40, 42], "file": [4, 15, 21, 26, 27, 29, 42], "thing": [4, 12, 15, 27, 28, 34, 44, 45, 47, 58, 62, 69, 70], "And": [4, 18, 27, 34, 58, 62], "retriev": [4, 27], "experi": [4, 11, 12, 28, 34, 38], "twoentityshap": 5, "relationship": [5, 8, 9, 19, 21, 34, 44, 45, 47, 48, 49, 50, 52, 54, 58, 59, 71], "actual": [5, 46, 67, 69], "suppos": [5, 38, 45, 58, 62], "wa": [5, 6, 8, 9, 22, 24, 26, 27, 30, 36, 42, 44, 45, 46, 48, 49, 51, 58, 62, 65, 67, 71], "besid": [5, 59], "name": [5, 8, 11, 12, 15, 16, 18, 19, 21, 22, 24, 26, 27, 28, 30, 32, 33, 34, 36, 38, 39, 42, 44, 45, 47, 48, 49, 50, 56, 58, 59, 62, 69], "exampl": [5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 31, 32, 33, 34, 36, 40, 41, 44, 45, 46, 47, 48, 50, 51, 52, 53, 54, 55, 56, 59, 61, 62, 65, 67, 69, 70, 71], "mn": [5, 22, 24, 29, 71], "usa": [5, 71], "ha": [5, 9, 11, 12, 15, 16, 18, 19, 26, 27, 28, 29, 30, 34, 36, 37, 38, 39, 40, 44, 47, 49, 52, 54, 58, 62, 67, 70, 71], "nicknam": [5, 22, 24], "motto": [5, 22, 24], "seen": [5, 7, 19, 27, 30, 34, 39, 47, 51, 58], "wikipedia": [5, 62], "page": [5, 28, 45, 46, 47, 51, 71], "caus": [5, 12, 15], "evolut": [5, 8, 9], "our": [5, 12, 15, 18, 21, 29, 32, 34, 37, 39, 42, 44, 45, 47, 49, 51, 61, 62, 67], "extra": [5, 37, 44, 47, 61, 65], "also": [5, 9, 11, 12, 18, 21, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 40, 45, 47, 48, 49, 50, 51, 58, 62, 66, 70, 71], "chang": [5, 8, 9, 11, 12, 18, 26, 27, 28, 29, 32, 38, 42, 45, 48, 62, 65, 67, 71], "onc": [5, 8, 12, 28, 30, 34, 37, 38, 42, 47, 53, 54, 62, 67], "had": [5, 8, 11, 22, 24, 46, 52, 65, 71], "replac": [5, 36, 45, 62], "townid": [5, 16, 22, 23, 24, 27, 29, 32, 38, 45, 50, 62], "call": [5, 8, 9, 12, 15, 16, 19, 26, 27, 29, 32, 34, 37, 39, 40, 44, 45, 47, 49, 58, 59, 62, 67], "said": [5, 15, 62], "below": [5, 8, 16, 21, 30, 32, 34, 37, 38, 39, 40, 42, 45, 47, 48, 49, 54, 55, 56, 58, 62, 65, 67, 71], "notic": [5, 8, 12, 16, 19, 27, 30, 32, 34, 37, 39, 42, 44, 48, 58, 65, 67], "declar": [5, 8, 9, 11, 12, 15, 16, 19, 32], "p": [5, 21, 22, 24, 27, 28, 29, 30, 45], "philadelphia": [5, 22, 24, 29], "term": [5, 11, 15, 18, 30, 56, 69], "foreign": [5, 6, 9, 16, 21, 22, 23, 24, 27, 34, 44, 47, 49, 50, 52, 58, 59], "kei": [5, 6, 8, 9, 11, 12, 15, 16, 18, 21, 22, 23, 24, 27, 30, 32, 34, 44, 47, 49, 50, 51, 52, 58, 59, 62], "made": [5, 27, 32, 34, 42, 51, 62], "opposit": [5, 6, 34], "origin": [5, 12, 18, 22, 24, 27, 28, 29, 32, 34, 36, 37, 38, 45, 46, 48, 49, 50, 51, 55, 64, 65, 71], "did": [5, 22, 24, 29, 32, 39, 44, 59, 65], "add": [5, 9, 11, 15, 23, 24, 28, 42, 45, 48, 55, 58, 62, 65, 67], "exist": [5, 11, 16, 22, 24, 52, 62, 71], "z": [5, 9, 11, 22, 24, 27, 28, 30, 32, 34, 37, 38, 42, 45, 47, 48, 49, 59, 62, 67], "enter": [5, 8, 9], "explain": [5, 26, 28, 67], "queri": [5, 11, 15, 18, 19, 27, 28, 29, 30, 32, 35, 37, 39, 41, 42, 44, 45, 48, 51, 52, 53, 54, 57, 58, 62, 66, 68, 69], "simpli": [5, 28, 29, 30, 34, 36, 45, 53, 58, 62, 65, 67], "togeth": [5, 27, 29, 32, 34, 58, 69, 71], "again": [5, 8, 18, 28, 30, 32, 34, 36, 37, 39, 45, 48, 55, 65, 67], "whole": [5, 11], "purpos": [5, 12, 15, 27, 58, 71], "never": [5, 9, 15, 18, 19, 29, 30, 34, 47, 48, 58], "afraid": 5, "point": [5, 12, 18, 34, 37, 38, 41, 42, 44, 47, 49, 51, 52, 62, 69], "dure": 5, "process": [5, 12, 36, 47, 48, 49, 62, 69, 70, 71], "be_shap": 6, "take": [6, 11, 15, 18, 19, 26, 28, 34, 45, 48, 51, 53, 65, 67, 69], "two": [6, 8, 9, 12, 15, 16, 18, 19, 26, 28, 29, 30, 34, 36, 37, 38, 39, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 56, 58, 64, 65, 67, 71], "entiti": [6, 8, 9, 16, 21, 34, 38, 42, 44, 46, 50, 52, 53, 58, 62, 71], "describ": [6, 32, 34, 47, 49, 62, 67], "set": [6, 11, 12, 15, 16, 18, 27, 28, 30, 37, 38, 39, 44, 45, 52, 53, 54, 55, 58, 62, 65, 69, 71], "form": [6, 11, 12, 16, 22, 24, 26, 27, 28, 29, 30, 36, 37, 44, 53, 56, 62, 69, 71], "categor": 6, "subgroup": 6, "sometim": [6, 8, 15, 19, 28, 42, 62, 70], "those": [6, 11, 12, 15, 18, 26, 27, 28, 32, 34, 36, 37, 39, 44, 45, 46, 47, 48, 53, 62, 69], "meant": [6, 67], "contain": [6, 8, 9, 15, 18, 27, 28, 29, 30, 32, 34, 46, 47, 48, 49, 52, 53, 54, 62, 65, 67], "skill": [6, 8, 9, 11, 15, 18, 21, 22, 23, 24, 27, 29, 32, 37, 38, 39, 42, 44, 46, 49, 50, 51, 52, 53, 55, 56, 58, 62, 65, 70], "might": [6, 9, 12, 15, 27, 28, 29, 30, 32, 34, 36, 45, 48, 49, 53, 58, 62, 65, 67, 69, 70], "achiev": [6, 8, 9, 12, 18, 21, 22, 23, 24, 28, 29, 36, 37, 38, 39, 44, 45, 46, 49, 50, 51, 53, 55, 56, 58, 65, 70], "perform": [6, 11, 12, 27, 28, 36, 37, 38, 47, 53, 58, 59, 62, 65, 67], "individu": [6, 27], "team": [6, 21, 22, 24, 29, 52, 65, 70, 71], "case": [6, 8, 18, 27, 28, 32, 33, 34, 36, 37, 39, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 56, 58, 59, 62, 65, 67], "decid": [6, 18, 27, 28, 29, 45, 47, 49, 53, 67], "teamskil": [6, 22, 23, 24, 28, 32, 45, 46, 52, 56], "teamsiz": [6, 22, 23, 24, 32], "bobsled": [6, 22, 24, 28, 30, 34, 45, 47, 48, 67], "cours": [6, 12, 15, 34, 71], "requir": [6, 11, 15, 16, 28, 34, 42, 69], "peopl": [6, 11, 12, 22, 24, 39, 69, 71], "done": [6, 11, 24, 27, 34, 37, 42, 45, 62, 67], "link": [6, 71], "incorpor": [6, 11], "bar": 6, "must": [6, 9, 11, 12, 15, 16, 18, 24, 27, 28, 29, 32, 34, 36, 38, 39, 44, 45, 47, 53, 55, 58, 67, 69], "identifi": [6, 9, 10, 11, 12, 15, 16, 18, 19, 27, 28, 29, 30, 32, 34, 38, 39, 44, 45, 47, 48, 49, 50, 51, 52, 53, 55, 56, 58, 59, 62, 67, 70], "skillcod": [6, 9, 11, 18, 22, 23, 24, 27, 28, 29, 30, 32, 34, 37, 38, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 58, 62, 65, 67], "primari": [6, 8, 9, 11, 15, 16, 18, 22, 23, 24, 34, 56, 71], "ve": [6, 34, 45, 58, 71], "time": [6, 8, 12, 15, 18, 19, 21, 27, 28, 29, 30, 32, 41, 42, 45, 47, 51, 54, 55, 57, 58, 62], "individualskil": 6, "could": [6, 9, 12, 15, 16, 19, 28, 29, 30, 32, 34, 38, 42, 45, 48, 49, 58, 62, 65, 67, 69], "exercis": [6, 26, 33, 35, 41, 57, 58, 64, 71], "onli": [6, 8, 9, 11, 12, 15, 16, 19, 27, 28, 29, 30, 34, 37, 44, 45, 47, 49, 58, 62, 65, 67], "sub": 6, "group": [6, 26, 33, 35, 42, 58, 62, 65], "wish": [6, 8, 21, 28, 29, 32, 38, 62, 71], "anyth": [6, 15, 22, 24, 34, 48, 49], "els": [6, 15, 47], "mai": [6, 8, 11, 12, 15, 16, 18, 19, 21, 27, 28, 29, 32, 36, 38, 39, 51, 65, 69, 71], "delai": 6, "overlap": [6, 44, 45, 56], "either": [6, 16, 34, 45, 46, 48, 51, 52, 53, 56, 67], "determin": [6, 11, 28, 32, 34, 39, 45, 47, 48, 50, 62, 67], "other": [6, 8, 9, 11, 12, 15, 18, 22, 24, 27, 28, 29, 32, 34, 36, 37, 38, 39, 42, 46, 48, 51, 52, 56, 57, 58, 62, 66, 68, 69, 70, 71], "e": [6, 9, 11, 15, 18, 22, 24, 27, 28, 30, 32, 34, 36, 38, 42, 44, 45, 46, 48, 56, 57, 58, 62, 67], "interest": [6, 8, 32, 38, 39, 42, 58, 62], "come": [6, 11, 12, 15, 16, 27, 30, 34, 39, 51, 58, 62], "choic": [6, 26, 50], "new": [7, 8, 11, 12, 28, 29, 30, 32, 34, 37, 39, 40, 44, 47, 48, 50, 62, 68, 70], "town": [7, 16, 22, 23, 24, 27, 30, 32, 34, 37, 38, 39, 45, 47, 48, 49, 50, 51, 53, 55, 58, 62, 65], "re": [7, 27, 28, 37, 38, 51], "through": [7, 11, 12, 15, 34, 45, 46, 49, 51, 53, 56, 62, 69, 71], "peek": 7, "ahead": 7, "natur": [7, 9, 15, 29, 30, 33, 44, 45, 47, 48, 49, 50, 52, 58, 59, 65, 69], "join": [7, 27, 39, 47, 48, 49, 50, 51, 52, 53, 54, 59, 62, 67, 71], "far": [7, 32, 34, 39, 42, 44, 58, 62, 67], "One": [7, 28, 36, 38, 45, 47, 53, 62, 65, 71], "intersectionarbitraryid": 8, "occur": [8, 42, 45, 47], "care": [8, 11, 15, 19, 32, 53], "consider": [8, 40], "being": [8, 9, 32, 39, 45, 46, 54, 56, 57, 58, 62, 69, 70, 71], "automat": [8, 9, 29, 37, 47], "intermedi": [8, 9, 11, 12, 34, 37, 39, 42, 46, 51, 58, 59, 62], "still": [8, 9, 12, 15, 22, 24, 27, 29, 47, 48, 51, 58, 62], "pair": [8, 9, 16, 30, 38, 39, 45, 46, 48, 50, 51, 53, 55, 56, 65], "than": [8, 11, 12, 15, 18, 19, 22, 24, 26, 27, 29, 30, 32, 34, 36, 37, 38, 39, 44, 45, 47, 48, 50, 53, 56, 58, 62, 65, 67], "occurr": [8, 9, 67], "date": [8, 22, 24, 28, 30, 33, 62, 67], "achdat": [8, 22, 23, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "same": [8, 15, 16, 18, 22, 24, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 40, 41, 44, 45, 46, 47, 48, 49, 50, 57, 58, 59, 62, 65, 67], "cannot": [8, 15, 16, 28, 29, 30, 32, 34, 48], "tiebreak": 8, "instead": [8, 14, 15, 16, 18, 39, 58, 62, 65, 69], "line": [8, 9, 15, 22, 23, 24, 28, 44, 45], "20": [8, 16, 22, 23, 24, 27, 29, 30, 32, 34, 38, 42, 47, 48, 49, 62, 65, 67], "keyword": [8, 9, 27, 28, 29, 30, 34, 37, 38, 39, 47, 50, 58], "autoincr": [8, 22], "integ": [8, 15, 16, 22, 23, 24, 28, 30, 67], "system": [8, 11, 15, 21, 27, 30, 47, 58, 71], "increment": 8, "vari": [8, 15, 22, 24, 37], "sqlite": [8, 21, 27, 28, 30, 37, 39, 47, 58, 71], "similarli": [8, 44], "almost": [8, 12, 15, 65, 70], "encount": [8, 16], "defin": [8, 11, 12, 17, 62], "datatyp": [8, 33], "function": [8, 12, 18, 28, 30, 34, 39], "convert": [8, 11, 12, 42, 58], "datetim": [8, 22, 23, 24], "treat": [8, 15, 30, 36, 38], "11": [8, 21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 67], "taken": 8, "short": [8, 12, 15, 28, 32, 44, 45, 56, 70], "cut": 8, "were": [8, 21, 27, 29, 32, 36, 42, 44, 48, 50, 55, 56, 58, 65], "order": [8, 11, 15, 19, 22, 24, 36, 39, 40, 44, 49, 52, 55, 58, 65], "achid": [8, 22, 23, 24, 27, 28, 29, 30, 32, 34, 42, 45, 47, 48, 62, 65, 67], "featur": [8, 12, 15, 71], "found": [8, 12, 27, 44, 45, 58], "gener": [8, 12, 15, 29, 30, 36, 37, 38, 56, 61, 62, 67, 70, 71], "timestamp": 8, "special": [8, 11, 15, 47, 58, 65, 71], "illustr": [8, 9, 12, 16, 18, 21, 31, 36, 37, 40, 45, 47, 62, 71], "up": [8, 12, 27, 30, 32, 34, 37, 45, 51, 58, 62, 67, 70, 71], "intersectionshap": 9, "To": [9, 11, 18, 26, 27, 29, 34, 38, 39, 44, 53, 58, 62, 65, 71], "realiz": [9, 26, 30, 34, 38, 39, 51, 53, 58, 65], "skilldescript": [9, 22, 23, 24, 28, 30, 34, 45, 47, 48, 58, 67], "float": [9, 22, 24, 28, 30, 34, 38, 45, 47, 48, 62, 67, 70], "swim": [9, 22, 24, 28, 30, 34, 36, 45, 47, 48, 62, 67], "o": [9, 22, 24, 28, 30, 34, 38, 44, 45, 47, 48, 49, 56, 67], "sink": [9, 22, 24, 28, 30, 34, 45, 47, 48, 67], "walk": [9, 22, 24, 28, 30, 34, 45, 47, 48, 67], "water": [9, 22, 24, 28, 30, 34, 45, 47, 48, 51, 67], "gargl": [9, 18, 22, 24, 28, 30, 34, 36, 37, 38, 45, 47, 48, 62, 67], "wight": 9, "profici": [9, 11, 22, 23, 24, 27, 28, 29, 30, 32, 34, 38, 42, 47, 48, 58, 62, 67, 70], "combin": [9, 38, 39, 43, 50, 57, 58, 67, 71], "stop": [9, 36], "sure": [9, 27, 29, 32, 34, 58], "understand": [9, 11, 12, 18, 21, 27, 34, 36, 37, 39, 42, 44, 45, 48, 49, 51, 62, 67, 69], "last": [9, 12, 15, 18, 28, 38, 49, 62, 65, 67], "sentenc": [9, 12, 19, 32, 34], "answer": [9, 11, 15, 16, 32, 34, 53, 65], "question": [9, 15, 16, 28, 32, 53, 65], "q": [9, 12, 28, 32, 34, 53, 54, 62], "given": [9, 11, 12, 28, 29, 32, 34, 39, 44, 45, 55, 56, 62, 67, 69, 70, 71], "contribut": [9, 21, 22, 23, 24, 32, 34, 47, 49, 50, 62, 70], "situat": [9, 29, 44, 45, 47, 48, 49, 50, 51, 53, 54, 56], "repeat": [9, 12, 16, 18, 32, 62], "earlier": [9, 12, 16, 18, 27, 34, 44, 47, 52], "23": [9, 27, 30, 32, 34, 42, 47, 48, 62, 67], "further": [9, 12, 28, 45, 51, 58, 67, 71], "uniqu": [9, 11, 15, 18], "default": 9, "null": [9, 13, 15, 16, 21, 22, 23, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 49, 57, 58, 59, 62, 67], "remov": [9, 28, 29, 30, 37, 44, 45, 65], "NOT": [9, 16, 22, 23, 24, 34, 37, 38, 62], "non": [9, 12, 15, 16, 19, 27, 28, 29, 30, 35, 37, 39, 40, 41, 44, 45, 46, 47, 48, 49, 56, 65], "perhap": [9, 11, 15, 28, 29, 32, 62, 69], "alwai": [9, 11, 12, 15, 18, 19, 28, 29, 32, 40, 44, 45, 47, 50, 51, 62, 69, 71], "altern": [9, 19, 29, 34, 39, 47, 48], "respect": [9, 19, 39, 53, 65], "24": [9, 15, 22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "25": [9, 22, 24, 28, 30, 32, 34, 45, 47, 48, 67], "just": [9, 11, 12, 15, 16, 18, 21, 28, 29, 30, 32, 36, 37, 38, 42, 44, 45, 46, 47, 58, 62, 65, 67, 69, 71], "befor": [9, 19, 24, 27, 28, 30, 35, 37, 39, 42, 44, 45, 50, 62, 71], "section": [9, 11, 15, 26, 28, 34, 37, 38, 39, 44, 45, 46, 47, 49, 50, 51, 52, 59, 70], "chicken": [10, 34, 45, 50, 51, 53, 57, 58], "feet": [10, 45, 50, 51, 53, 57, 58], "intersect": [10, 41, 45, 52, 53, 58, 62], "arbitrari": [10, 22, 24, 45], "summari": [10, 14, 17, 33, 36, 37, 38, 41], "concept": [10, 15, 18, 32, 51, 62, 67, 71], "introduc": [10, 12, 18, 27, 38, 40, 67], "00masteringintro": 11, "aim": 11, "rel": [11, 53], "newcom": 11, "intent": [11, 18, 69], "enabl": [11, 15, 28, 34, 49, 62, 71], "develop": [11, 12, 49, 51, 67, 71], "masteri": [11, 12, 15, 18, 29, 32, 34, 38, 39, 44, 49, 51], "correct": [11, 18, 27, 29, 32, 34, 42, 52, 71], "desir": [11, 28, 38, 44, 49, 50], "seek": [11, 12], "save": [11, 12, 15, 34, 39], "cost": [11, 12], "analyz": [11, 12, 15], "improv": [11, 12, 18, 70], "decis": [11, 12, 45, 47, 48, 49, 50], "advanc": [11, 27, 71], "claim": 11, "flaw": [11, 12, 39], "better": [11, 28], "oper": [11, 12, 15, 16, 18, 19, 21, 27, 30, 37, 38, 39, 42, 45, 47, 49, 50, 52, 54, 55, 58, 65, 67, 69, 71], "produc": [11, 12, 18, 19, 28, 29, 32, 36, 38, 39, 42, 52], "importantli": 11, "languag": [11, 12, 19, 29, 47, 69], "precis": [11, 12, 27, 29, 32, 58, 65, 69, 70], "disciplin": [11, 14, 18], "formul": [11, 12, 47, 48, 49, 69], "narr": [11, 12, 28, 34, 62, 69], "technic": 11, "happili": 11, "none": [11, 27, 28, 45], "focu": [11, 12, 27, 28, 47, 53, 54, 69, 71], "technologi": [11, 71], "commun": [11, 47, 62, 69, 70], "among": [11, 28, 40, 62], "problem": [11, 34], "solv": 11, "Be": [11, 34, 58], "alreadi": [11, 12, 19, 37, 46, 47, 62], "experienc": [11, 71], "slower": 11, "starter": [11, 21], "novic": [11, 16, 29, 30, 34], "unlearn": 11, "manag": [11, 12, 15, 44, 71], "dbm": [11, 12, 15, 16, 28, 32, 33, 37, 69], "human": [11, 15, 69], "role": [11, 14, 15, 22, 23, 24, 34, 47], "analyst": [11, 12, 47, 69, 70], "analys": [11, 12, 39, 44, 47, 62, 67], "devis": [11, 27, 44, 49, 51, 62, 65], "plan": [11, 14, 15, 18, 19, 27], "accomplish": [11, 58, 62], "execut": [11, 12, 15, 28, 71], "rest": [11, 21, 26, 39, 44, 46], "comfort": [11, 49, 62, 65], "certain": [11, 12, 18, 29, 42, 49, 53, 58], "involv": [11, 12, 53, 58, 62], "administr": 11, "dba": 11, "who": [11, 12, 27, 29, 34, 37, 38, 42, 51, 58, 62, 65, 67, 70, 71], "respons": 11, "larg": [11, 12, 16, 28, 62, 67], "purview": 11, "give": [11, 32, 45, 48, 58, 62, 69], "privileg": 11, "g": [11, 15, 18, 21, 22, 24, 27, 28, 29, 30, 32, 34, 36, 38, 45, 47, 48, 49, 67, 71], "index": [11, 71], "build": 11, "backup": 11, "recoveri": 11, "etc": [11, 15, 67], "applic": [11, 12, 15], "programm": 11, "write": [11, 12, 18, 27, 29, 32, 34, 44, 45, 47, 69], "app": 11, "limit": [11, 15], "view": [11, 15, 42], "insul": [11, 12], "messi": 11, "access": [11, 12, 15, 26, 27, 29, 47], "comput": [11, 15, 30, 33, 42, 62, 70, 71], "via": 11, "unfortun": 11, "realm": [11, 12, 15], "overload": 11, "paragraph": 11, "briefli": [11, 12, 15], "sever": [11, 12, 19, 30, 32, 44, 51, 53, 62, 69, 70], "despit": 11, "usag": 11, "input": [11, 12, 19, 20, 26, 27, 28, 29, 30, 32, 34, 36, 37, 38, 40, 41, 42, 45, 46, 47, 48, 49, 50, 51, 53, 54, 56, 57, 58, 62, 65], "output": [11, 12, 19, 20, 26, 30], "simplest": [11, 12, 28, 41], "within": [11, 12, 15, 18, 30], "truli": [11, 12, 65], "consist": [11, 12, 15, 28, 30, 39], "cell": [11, 15, 16, 18, 30], "singleton": [11, 15, 29], "organ": [11, 51], "rectangl": [11, 15, 29], "It": [11, 12, 15, 18, 21, 27, 28, 29, 30, 31, 34, 39, 40, 42, 45, 47, 48, 51, 53, 58, 67], "serv": [11, 15, 18, 27, 29, 37, 67], "distinguish": [11, 12, 15, 29], "duplic": [11, 12, 15, 29, 30, 37, 45, 58, 65], "burden": 11, "enforc": [11, 15, 16, 24], "restrict": [11, 12, 15, 36, 38, 45], "shift": 11, "onto": 11, "By": [11, 15, 50, 69], "contrast": 11, "ii": 11, "consequ": [11, 12, 15, 16, 18, 27, 28, 58], "allow": [11, 12, 15, 30], "mathemat": [11, 15, 39], "while": [11, 12, 15, 16, 18, 19, 21, 29, 30, 34, 36, 39, 69], "bag": 11, "multi": 11, "miss": [11, 54, 58, 68, 70], "bewar": [11, 15, 29], "mistakenli": 11, "synonym": 11, "foster": 11, "sai": [11, 12, 16, 27, 28, 39, 62, 69], "sadli": [11, 18], "effect": [11, 32, 38], "materi": [11, 12, 15, 71], "distinct": [11, 15, 18, 29, 30, 34, 58, 62, 69, 70], "between": [11, 15, 17, 19, 26, 28, 29, 30, 42, 45, 47, 49, 50, 51, 52, 53, 57, 58, 67, 70], "prime": 11, "misus": [11, 34], "express": [11, 12, 19, 28, 70], "written": [11, 27, 28, 29, 47, 71], "comprehens": 11, "eventu": [11, 12, 15], "transform": [11, 12], "variant": 11, "preced": [11, 12, 18, 21, 26, 27, 29, 30, 32, 34, 37, 38, 39, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58, 59, 62, 65, 67, 71], "chart": [11, 12, 18, 21, 27, 28, 29, 30, 32, 33, 34, 36, 37, 38, 39, 42, 44, 45, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58, 59, 62, 65, 67, 71], "These": [11, 12, 15, 36, 37, 45, 47, 49], "proper": 11, "itself": [11, 12, 39, 57, 65], "error": [11, 29, 30, 36, 42], "prone": 11, "mechan": [11, 71], "sens": [11, 12, 15, 27, 62], "leav": [11, 27, 45, 69], "unchang": 11, "broader": 11, "expect": [11, 12, 28, 48, 69, 71], "softwar": [11, 12, 15, 47, 71], "permiss": [11, 71], "dynam": 11, "element": [11, 15, 19, 36, 37, 59], "schema": [11, 21, 29, 34, 38, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 56, 58], "reli": 11, "assum": [11, 67, 70, 71], "There": [11, 15, 21, 30, 34, 36, 44, 45, 48, 49, 51, 52, 56, 58, 65, 69, 70], "01queying_analysi": 12, "complex": [12, 34, 36, 41, 42, 46, 62, 71], "focus": [12, 27], "anchor": [12, 22, 24, 29, 65], "german": 12, "bring": [12, 18, 71], "light": 12, "fuzzi": 12, "effici": 12, "cycl": 12, "until": [12, 15, 27, 44, 67], "satisfi": [12, 27, 62, 65], "evolv": 12, "along": [12, 28, 29, 36, 47, 48, 62, 67], "richer": 12, "Such": [12, 16, 19, 29], "notion": [12, 15, 16, 19, 28, 29, 30, 40, 44, 45, 51], "definit": [12, 15, 22, 23, 24, 62], "fortun": [12, 69], "respond": 12, "extern": 12, "trigger": 12, "surpris": [12, 69, 70], "shortfal": 12, "avail": [12, 28, 58], "raw": [12, 15, 19, 29], "period": 12, "quarterli": 12, "report": [12, 67], "thought": [12, 34, 39, 44, 62], "endeavor": 12, "proactiv": 12, "inventori": 12, "prelud": 12, "revis": 12, "purchas": 12, "polici": 12, "anomali": 12, "trend": 12, "lead": [12, 28, 39, 51], "delv": [12, 15, 21], "increas": [12, 71], "knowledg": [12, 67, 70], "valuabl": 12, "acquir": 12, "depth": 12, "nuanc": 12, "organiz": 12, "context": [12, 70], "ask": [12, 16, 29, 30, 38, 47, 48, 53, 58, 62, 67], "kind": [12, 15, 19, 30, 70], "thin": 12, "connot": 12, "littl": [12, 18, 47], "ow": 12, "small": [12, 24, 28, 29, 39, 44, 46, 49, 51, 62, 71], "No": [12, 32, 39], "loan": 12, "monei": 12, "fat": 12, "extens": 12, "compar": [12, 27, 32, 33, 36, 38, 39, 42, 62, 67, 71], "debt": 12, "load": [12, 28], "custom": 12, "employ": 12, "statu": 12, "credit": 12, "histori": 12, "support": [12, 58], "larger": [12, 19, 53, 71], "schedul": 12, "incom": 12, "threshold": 12, "pronounc": [12, 28], "l": 12, "quell": 12, "standard": [12, 30, 71], "interfac": 12, "r": 12, "vendor": 12, "compli": 12, "specifi": [12, 15, 28, 29, 30], "accept": [12, 15, 19, 39], "textbook": [12, 62], "unnam": [12, 69], "object": 12, "four": [12, 30, 36, 38, 65, 71], "italic": [12, 15, 27], "word": [12, 15, 18, 28, 29, 33, 37, 38, 42, 48, 51, 58, 62, 70], "oppos": [12, 58], "outcom": 12, "amort": 12, "reus": [12, 67], "multipl": [12, 32, 33, 44, 67], "gotten": [12, 46], "remain": [12, 26, 30, 51], "blissfulli": 12, "ignor": [12, 30], "sad": 12, "fact": [12, 15, 18, 27, 28, 49], "complain": 12, "got": 12, "b": [12, 21, 22, 24, 27, 28, 29, 30, 32, 34, 36, 37, 38, 39, 40, 42, 44, 45, 46, 57, 59, 62, 67], "c": [12, 32, 58, 62], "therebi": 12, "gain": 12, "benefit": 12, "harder": [12, 51], "aid": [12, 44, 45, 46, 56, 57, 58, 59], "reflect": [12, 30], "terribli": 12, "difficult": [12, 39, 45], "even": [12, 15, 28, 30, 32, 34, 36, 49, 58, 62, 65], "expert": 12, "find": [12, 18, 21, 27, 28, 29, 30, 34, 37, 38, 39, 45, 47, 48, 49, 50, 51, 52, 54, 55, 58, 62, 65, 67, 69, 70], "hard": [12, 32, 42, 62], "struggl": [12, 69], "own": [12, 15, 18, 21, 26, 27, 29, 31, 32, 34, 40, 44, 49, 62, 67, 71], "imposs": [12, 58], "ani": [12, 15, 19, 29, 30, 34, 36, 37, 38, 39, 42, 44, 48, 50, 51, 58, 62, 65], "mention": [12, 28, 37, 39, 49], "although": [12, 15, 29, 70], "sound": [12, 28], "english": [12, 27, 28, 29, 30, 34, 37, 38, 39, 42, 45, 47, 48, 49, 50, 51, 52, 53, 54, 55, 58, 62, 65, 69], "Of": [12, 34], "state": [12, 16, 19, 22, 23, 24, 29, 32, 47, 48, 49, 53, 69, 70], "too": [12, 15, 19, 29], "wors": 12, "tend": 12, "convolut": 12, "forc": [12, 69], "That": [12, 15, 28, 34], "mental": 12, "juggl": 12, "inde": [12, 16, 30, 39, 48, 58], "furthermor": 12, "script": 12, "off": [12, 19], "fail": [12, 15, 29, 70], "reap": 12, "less": [12, 27, 64, 67], "expens": [12, 39], "overcom": 12, "my": [12, 18, 34, 71], "advic": [12, 15], "bare": 12, "collect": [12, 15], "minim": 12, "yield": [12, 27, 29, 30, 34], "composit": [12, 15], "succeed": 12, "compil": 12, "reread": 12, "mutual": 12, "exclus": 12, "program": [12, 15, 30], "higher": [12, 42, 47], "lower": [12, 36, 45, 47, 48, 49, 58, 65], "machin": [12, 71], "worth": [12, 15, 62], "competitor": 12, "filter": [12, 18, 26, 33, 35, 37, 39, 45, 47, 48, 55, 57, 62, 65, 67], "appli": [12, 21, 26, 27, 28, 39, 49, 50, 56, 66], "usual": [12, 18, 26, 37, 47, 58, 62], "compris": [12, 15, 48], "well": [12, 34, 39, 51, 62, 69], "fix": [12, 70], "establish": 12, "authorit": 12, "bodi": 12, "open": [12, 39, 67], "mind": [12, 27, 45, 51, 58], "author": 12, "select": [12, 24, 27, 28, 29, 34, 37, 47, 58, 62, 65], "somewhat": [12, 21, 30, 32, 46, 62, 71], "mostli": [12, 69], "greek": 12, "symbol": [12, 16, 27, 29, 30, 44, 45, 46, 47, 48, 49, 56, 58, 62, 65], "shortcut": [12, 27, 44, 45, 47], "detract": 12, "anonym": [12, 15], "moreov": 12, "content": [12, 13, 40, 69], "major": 12, "readi": 12, "remaind": 12, "lot": [12, 18, 28], "temp": 13, "stai": 13, "tune": 13, "recipe_id": [13, 15], "rank": [13, 15], "recipe_categori": [13, 15], "recipe_nam": [13, 15], "9257643": [13, 15], "8772": [13, 15], "cooki": [13, 15], "oatmeal": [13, 15], "crispi": [13, 15], "60029738": [13, 15], "bread": [13, 15, 19], "banana": [13, 15], "v": [14, 71], "algebra": [14, 15, 18, 19, 21, 37, 42, 62], "mean": [14, 15, 18, 19, 29, 34, 36, 37, 42, 45, 47, 50, 54, 56, 58, 62, 67, 69, 70], "product": [14, 36, 39], "initi": [14, 69], "big": 14, "pictur": [14, 37], "00definit": 15, "broad": [15, 69], "deem": 15, "resist": 15, "urg": 15, "quickli": [15, 30, 34], "crucial": [15, 18, 27, 28, 29], "second": [15, 22, 24, 27, 29, 34, 37, 38, 39, 42, 44, 45, 47, 48, 50, 54, 61, 62, 65, 69, 70, 71], "implicit": 15, "empti": 15, "rdmb": 15, "won": 15, "t": [15, 21, 22, 24, 26, 27, 28, 29, 30, 32, 34, 38, 39, 42, 45, 47, 48, 49, 62, 67], "hing": 15, "dozen": [15, 29], "common": [15, 34, 38, 44, 45, 53, 56, 58], "decept": 15, "unord": [15, 65], "dimens": 15, "enclos": 15, "venn": 15, "curli": 15, "brace": 15, "heterogen": 15, "remot": 15, "control": 15, "appl": 15, "jackhamm": 15, "pi": 15, "commonli": 15, "homogen": 15, "34": 15, "letter": [15, 44, 45, 47, 49, 50, 56, 58], "signific": [15, 27], "themselv": [15, 65], "complac": 15, "pai": [15, 50], "attent": [15, 50], "plai": 15, "critic": 15, "tini": 15, "size": 15, "denot": 15, "ital": 15, "underlin": [15, 18, 19], "4x2": 15, "recal": [15, 18, 28, 34, 36, 37, 38, 44, 45, 62, 65], "incorrect": [15, 32, 34], "singular": [15, 19, 21, 27, 70], "encod": 15, "domain": [15, 16, 67, 70], "dictat": 15, "left": [15, 16, 18, 22, 24, 29, 42, 45, 58, 59, 62, 65, 69, 70], "right": [15, 18, 22, 24, 28, 29, 34, 36, 39, 42, 45, 54, 61, 65, 69, 71], "meaning": 15, "charact": [15, 21], "smaller": [15, 65], "ph": 15, "0": [15, 22, 24, 27, 28, 30, 34, 45, 47, 48, 59, 67], "14": [15, 22, 24, 27, 29, 30, 32, 34, 42, 47, 48, 62, 65, 67, 71], "grade": 15, "constrain": 15, "f": [15, 32, 62], "explicitli": [15, 45, 47], "constraint": 15, "foolishli": 15, "trust": 15, "behav": [15, 38], "confus": 15, "especi": [15, 32, 58], "scale": 15, "nomin": 15, "ordin": 15, "numer": 15, "field": 15, "variabl": [15, 30], "tupl": 15, "atom": 15, "sensibl": 15, "assert": [15, 16], "current": [15, 28, 29, 65], "futur": 15, "exactli": [15, 18, 27, 28, 34, 39, 44, 45, 47, 49, 56, 64, 65, 67], "intern": [15, 18, 29], "temporari": 15, "alias": 15, "keystrok": 15, "noun": [15, 18, 19, 29, 32, 39, 70], "phrase": [15, 18, 29, 33, 34, 36, 37, 38, 47, 48, 49, 62, 69], "topic": [15, 71], "pervad": 15, "tax": 15, "student": [15, 29, 71], "appreci": 15, "namer": 15, "thu": [15, 16, 29, 30, 32, 34, 49, 51, 65, 67], "progress": [15, 29, 34, 71], "deriv": [15, 19, 36, 38, 71], "three": [15, 22, 24, 28, 30, 34, 36, 37, 44, 45, 46, 47, 48, 49, 50, 56, 62, 65, 67, 71], "video": 15, "summar": [15, 30], "playback": 15, "faster": 15, "feel": [15, 18, 62], "m": [15, 22, 24, 29, 44, 45, 46, 52, 53, 57, 59], "slow": 15, "speed": 15, "fine": [15, 32, 69], "01connect": 16, "variou": [16, 18, 21, 27, 31, 40, 62, 67], "pointer": 16, "address": [16, 18], "direct": [16, 19, 45, 52, 62], "zero": [16, 18, 27, 29, 30, 34, 42, 45, 58, 59], "updat": 16, "pairwis": 16, "home": [16, 22, 24, 29, 51], "guarante": [16, 58], "reside_townid": [16, 21, 22, 23, 24, 27, 28, 29, 30, 34, 45, 48, 49, 51, 55, 58, 65], "At": [16, 21], "referenti": [16, 24], "integr": [16, 24], "mouth": 16, "plain": 16, "shape": [16, 19, 26, 32, 34, 36, 44, 45, 47, 48, 50, 51, 52, 53, 54, 58, 62, 71], "varchar": [16, 22, 23, 24], "townnam": [16, 22, 23, 24, 29, 32], "countri": [16, 22, 23, 24, 29, 32], "townnicknam": [16, 22, 23, 24, 29, 32], "80": [16, 22, 23, 24], "townmotto": [16, 22, 23, 24, 29], "conflat": 16, "impli": [16, 19, 29, 42, 48, 69], "appropri": [16, 18], "belong": 16, "connect": [17, 19, 45], "00relat": 18, "chose": [18, 42, 54], "paramet": 18, "clearli": [18, 47, 65, 69, 71], "box": [18, 19, 32, 42, 65], "round": [18, 29], "edg": 18, "condit": [18, 19, 26, 34, 45], "insid": [18, 19, 30, 42, 45, 47, 71], "alongsid": 18, "soon": [18, 19, 34], "out": [18, 19, 28, 32, 34, 38, 39, 42, 45, 47, 49, 50, 51, 53, 58, 62, 65, 67, 70, 71], "fulli": [18, 59], "recogn": [18, 30], "except": [18, 37, 38, 47, 65, 69], "aris": [18, 30, 39], "properli": [18, 36, 58], "preach": 18, "gentli": 18, "pick": 18, "effort": 18, "worthwhil": 18, "rare": [18, 36], "congruent": 18, "ensur": [18, 27, 32, 34, 36, 37], "base": [18, 19, 26, 27, 28, 29, 30, 32, 34, 38, 40, 41, 44, 45, 46, 57, 65, 71], "shorten": [18, 27, 28, 36, 42, 54], "maintain": [18, 53], "signifi": [18, 22, 24], "down": [18, 32, 44, 47, 62, 70], "confid": [18, 44], "forgo": 18, "encourag": [18, 26], "throughout": [18, 21], "rather": [18, 32, 36, 37, 38, 65, 71], "shorter": [18, 26, 29], "lengthen": 18, "unlik": [18, 29], "old": [18, 29], "british": 18, "lawyer": 18, "am": [18, 51, 58, 71], "paid": 18, "subsect": 18, "constant": [18, 28, 30], "score": [18, 22, 23, 24, 28, 38, 42, 67], "list": [18, 22, 23, 24, 28, 29, 30, 34, 44, 45, 47], "locat": 18, "memori": 18, "third": [18, 22, 24, 29, 36, 37, 44, 45, 47, 49, 65, 69], "ninth": 18, "01operators_chart": 19, "partial": [19, 39], "former": [19, 29, 30], "latter": [19, 29, 30], "wast": 19, "convent": [19, 21, 47], "rectangular": 19, "arrow": [19, 36, 39, 45, 52], "bottom": [19, 70], "top": [19, 34, 42, 45, 47, 49], "label": [19, 32, 39], "alia": [19, 45], "peak": [19, 45, 47, 48, 49, 51, 52], "binari": [19, 37, 39, 45, 49, 62, 65, 71], "hous": [19, 36, 45, 47, 48, 49, 50, 51, 52], "triangl": [19, 62], "semant": 19, "corner": [19, 36, 45, 58], "pattern": [19, 27, 32, 36, 39, 42, 48, 57, 67], "discern": [19, 45, 69], "notabl": [19, 27, 28, 29, 30], "characterist": [19, 27, 28, 29, 33, 39], "unari": [19, 21, 27, 29, 30, 37, 42, 71], "sandwich": 19, "metaphor": 19, "meat": 19, "verb": [19, 28, 70], "outsid": [19, 65], "acycl": 19, "graph": 19, "procedur": 19, "exclud": 19, "loop": 19, "turn": [19, 39, 58, 67], "portion": [19, 21, 27, 42, 45, 47, 48, 53], "incomplet": 19, "00creaturedboverview": 21, "expand": 21, "simpler": 21, "heed": 21, "keep": [21, 22, 24, 27, 28, 29, 31, 34, 38, 39, 40, 44, 45, 58, 59, 65, 67], "copi": [21, 26, 27, 29, 31, 40, 47, 49, 51, 71], "long": [21, 26, 27, 28, 30, 38, 42, 62, 65], "provid": [21, 28, 36, 39, 45, 47, 58, 62], "insight": 21, "creaturedb": [21, 22], "central": 21, "fiction": 21, "scenario": 21, "aspir": [21, 22, 23, 24, 28, 32, 34, 37, 39, 46, 47, 50, 51, 53, 56, 62, 65], "main": [21, 27], "cast": 21, "idol_creatureid": [21, 22, 23, 24, 27, 28, 29, 30, 34, 45, 54], "10": [21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 65, 67], "d": [21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 44, 45, 46, 49, 56, 57, 58, 62, 67], "elastigirl": [21, 22, 24, 27, 28, 29, 30, 45], "mv": [21, 22, 24, 27, 28, 29, 30, 32, 34, 42, 45, 47, 48, 62, 67], "13": [21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 39, 42, 45, 47, 48, 49, 62, 65, 67], "david": [21, 22, 24, 27, 28, 29, 30, 45], "beckham": [21, 22, 24, 27, 28, 29, 30, 45], "le": [21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 67], "12": [21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 65, 67], "harri": [21, 22, 24, 27, 28, 29, 30, 45], "kane": [21, 22, 24, 27, 28, 29, 30, 45], "megan": [21, 22, 24, 27, 28, 29, 30, 45], "rapino": [21, 22, 24, 27, 28, 29, 30, 45], "sw": [21, 22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 67], "believ": [21, 71], "easier": [21, 32, 34, 38, 42, 45], "drop": [22, 24, 71], "IF": [22, 24], "id": [22, 24, 28, 29, 44, 45, 56], "INTO": [22, 24], "pa": [22, 24, 29], "unit": [22, 24, 29], "unexpect": [22, 23, 24], "indent": [22, 23, 24], "brotherli": [22, 24, 29], "love": [22, 24, 29], "endur": [22, 24, 29], "block": [22, 23, 24, 62], "blank": [22, 23, 24, 32, 34, 62], "unind": [22, 23, 24], "halloween": [22, 24, 29], "capit": [22, 24, 29], "world": [22, 24, 29, 70], "beyond": [22, 24, 27, 29, 71], "vallei": [22, 24, 29], "jolli": [22, 24, 29], "green": [22, 24, 29, 44, 62, 65], "giant": [22, 24, 29], "rich": [22, 24, 29], "citi": [22, 24, 29], "grow": [22, 24, 29], "mississippi": [22, 24, 29], "zenith": [22, 24, 29], "heart": [22, 24, 29], "soul": [22, 24, 29], "delta": [22, 24, 29], "food": [22, 24, 29], "shop": [22, 24, 29], "entertain": [22, 24, 29], "south": [22, 24, 29], "kanto": [22, 24, 29], "japan": [22, 24, 29], "odin": [22, 24, 29], "vault": [22, 24, 29], "magic": [22, 24, 29], "scienc": [22, 24, 29, 62], "metrovil": [22, 24, 29, 62], "incred": [22, 24, 29], "stand": [22, 24, 29], "london": [22, 24, 27, 29, 51], "england": [22, 24, 29, 51], "kingdom": [22, 24, 29], "smoke": [22, 24, 29], "domin": [22, 24, 29], "dirig": [22, 24, 29], "nos": [22, 24, 29], "seattl": [22, 24, 29], "washington": [22, 24, 29], "emerald": [22, 24, 29], "goodwil": [22, 24, 29], "40": [22, 23, 24], "maxprofici": [22, 23, 24, 28, 30, 34, 45, 47, 48, 49, 67], "max": [22, 23, 24, 30], "minprofici": [22, 23, 24, 28, 30, 34, 45, 47, 48, 67], "min": [22, 23, 24, 30], "origin_townid": [22, 23, 24, 27, 28, 30, 34, 37, 45, 47, 48, 51, 65, 67], "b2": [22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 65, 67], "crew": [22, 24, 28, 30, 34, 45, 47, 48, 67], "tr4": [22, 24, 27, 28, 29, 30, 32, 34, 37, 38, 42, 45, 47, 48, 49, 62, 65, 67], "4x100": [22, 24, 28, 30, 34, 37, 45, 47, 48, 62, 67], "meter": [22, 24, 28, 30, 34, 37, 45, 47, 48, 62, 67], "track": [22, 24, 28, 30, 34, 37, 39, 45, 47, 48, 62, 67], "relai": [22, 24, 28, 30, 34, 37, 45, 47, 48, 62, 67], "100": [22, 24, 28, 30, 34, 39, 45, 47, 48, 67], "c2": [22, 24, 28, 30, 34, 38, 39, 45, 47, 48, 49, 55, 65, 67], "cano": [22, 24, 28, 30, 34, 45, 47, 48, 62, 67], "thr": [22, 24, 27, 28, 29, 30, 32, 34, 42, 45, 47, 48, 62, 65, 67], "leg": [22, 24, 28, 29, 30, 34, 45, 47, 48, 62, 65, 67], "race": [22, 24, 28, 30, 34, 45, 47, 48, 62, 67], "d3": [22, 24, 27, 28, 29, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 65, 67], "australasia": [22, 24, 28, 30, 34, 45, 47, 48, 62, 67], "debat": [22, 24, 28, 30, 34, 45, 47, 48, 62, 67], "pk": [22, 24, 27, 28, 30, 32, 34, 38, 42, 45, 47, 48, 49, 62, 67], "soccer": [22, 24, 28, 30, 34, 45, 47, 48, 51, 62, 67], "penalti": [22, 24, 28, 30, 34, 45, 47, 48, 51, 62, 67], "kick": [22, 24, 28, 30, 34, 45, 47, 48, 51, 62, 67], "asgaard": [22, 24], "test_townid": [22, 23, 24, 27, 30, 32, 34, 37, 38, 42, 47, 48, 58, 62, 65, 67], "he": [22, 24, 32, 34, 58, 62, 67, 71], "2017": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "09": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "15": [22, 24, 27, 29, 30, 32, 34, 42, 47, 48, 62, 65, 67], "35": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "2018": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "07": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "00": [22, 27, 30, 32, 34, 42, 47, 48, 62, 67], "doesn": [22, 24, 26, 34], "2016": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "04": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "42": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "30": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "hi": [22, 24, 58, 62, 71], "dai": [22, 24, 27, 28], "06": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "1998": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "08": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "05": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "2012": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "poorli": [22, 24], "dare": [22, 24], "pilot": [22, 24, 29, 65], "goe": [22, 24, 45, 58], "brakeman": [22, 24, 29, 65], "76": [22, 24], "19": [22, 24, 27, 29, 30, 32, 34, 42, 47, 48, 62, 65, 67], "01": [22, 24, 27, 30, 32, 34, 42, 47, 48, 62, 67], "16": [22, 24, 27, 29, 30, 32, 34, 42, 47, 48, 62, 65, 67], "reali": [22, 24], "85": [22, 24, 27, 30, 32, 34, 38, 42, 47, 48, 49, 62, 67], "localtim": 22, "aspiredprofici": [22, 23, 24, 28, 32, 38, 49, 67], "desired_townid": [22, 23, 24, 38, 49, 67], "asppir": [22, 24], "rolenam": [22, 23, 24, 29, 32, 34, 65], "bobsl": [22, 24], "stern": [22, 24, 65], "paddler": [22, 24, 65], "bow": [22, 24, 65], "speaker": [22, 24, 29, 65], "captain": [22, 24, 29, 65], "17": [22, 24, 27, 29, 30, 32, 34, 42, 47, 48, 62, 65, 67, 71], "18": [22, 24, 27, 29, 30, 32, 34, 42, 47, 48, 62, 65, 67], "22": [22, 24, 27, 29, 30, 32, 34, 38, 42, 47, 48, 62, 65, 67], "21": [22, 24, 27, 29, 30, 32, 34, 42, 47, 48, 62, 65, 67], "aspiredcontribut": [22, 23, 24, 47, 49, 50], "ultim": [22, 24, 62], "creaturedb_create_mysql": 23, "alter": [23, 24], "auto_incr": [23, 24], "mysql": [23, 24, 37, 71], "_": [23, 24], "creaturedb_mysql": 24, "smallcreatur": 24, "fake": 24, "print": 24, "curdat": 24, "godizilla": 24, "00unaryintro": 26, "whether": [26, 30, 32, 36, 40, 45, 56, 62, 67, 70], "suppli": 26, "project": [26, 30, 33, 35, 38, 39, 45, 55, 57, 62, 65], "fewer": [26, 27, 32, 42, 44, 45, 48], "reduc": [26, 33, 35, 37, 38, 42, 45, 47, 48, 53, 57, 62, 65, 67], "probabl": [26, 54], "wrong": 26, "drawio": [26, 27, 29, 34, 37, 47], "templat": [26, 27, 29, 34, 37, 47, 62], "browser": [26, 27, 28, 29, 71], "googl": [26, 27, 29], "drive": [26, 27, 29], "space": [26, 27, 29, 67], "free": [26, 27], "web": [26, 27, 39], "net": [26, 27, 29, 34, 37, 39, 47], "dive": 26, "01filter": 27, "put": [27, 29, 34, 42, 47, 49, 58, 71], "pass": 27, "modifi": [27, 28, 29, 30, 39], "wide": [27, 28, 29, 30, 71], "Its": [27, 28, 29, 30, 39, 71], "height": [27, 29], "depend": [27, 28, 30, 34, 45], "relev": [27, 47], "translat": [27, 62, 69, 71], "saw": [27, 59], "renam": [27, 28, 29, 39, 44], "pose": [27, 53], "accur": [27, 30, 32, 34, 47, 69], "tab": [27, 28, 29, 32, 37, 38, 39, 42, 45, 47, 48, 49, 50, 54, 55, 62], "don": [27, 32, 34, 39, 45, 62], "explan": [27, 28, 29, 62], "fairli": [27, 28, 34, 42, 45, 46], "return": [27, 30, 62, 65], "claus": [27, 34, 39, 45, 47, 48, 55, 58, 65], "semi": [27, 45], "colon": [27, 45], "equal": [27, 32, 34, 44, 45, 47, 48, 49, 52, 65, 67], "inequ": 27, "greater": [27, 34, 38, 67], "resid": [27, 34, 45, 49, 50, 51, 55, 58, 65], "speech": 27, "descript": [27, 38, 62], "2020": [27, 30, 32, 34, 42, 47, 48, 62, 67, 71], "37": [27, 30, 32, 34, 42, 47, 48, 62, 67], "53": [27, 30, 32, 34, 42, 47, 48, 62, 67], "prior": 27, "august": 27, "qualifi": [27, 58, 70], "kept": [27, 44, 58], "boolean": 27, "connector": 27, "AND": [27, 38, 62], "idea": [27, 32, 62, 67], "sophist": [27, 53, 62, 71], "primit": [27, 36, 39, 40], "comparison": 27, "ones": [27, 28, 29, 30, 34, 50, 67], "exact": [27, 44, 48, 62, 63, 65], "manipul": [27, 28], "awar": [27, 44, 45], "month": [27, 69], "sing": 27, "overal": [27, 56], "format": [27, 71], "yyyi": 27, "mm": 27, "dd": 27, "hh": 27, "ss": 27, "great": [27, 69, 71], "advantag": 27, "regardless": [27, 30, 38], "whatev": 27, "suit": 27, "oval": 27, "style": [27, 28, 69], "clear": [27, 29, 47], "meet": 27, "per": [27, 30, 34, 42, 58, 62, 67], "draw": [27, 29, 33, 34, 36, 37, 38, 39, 47, 58, 65], "haven": [27, 29, 34, 38, 47], "hint": [27, 28], "02project": 28, "pr\u0259\u02c8jekt": 28, "stem": [28, 50, 70], "tall": [28, 29, 30], "addit": [28, 29, 37, 41, 45, 51, 58, 59, 67, 71], "carri": [28, 29, 30, 32, 67], "shortli": [28, 45, 62], "comma": [28, 29], "total": [28, 39, 46, 56, 62], "elaps": 28, "juliandai": 28, "minu": [28, 40, 41, 44, 62], "AS": [28, 39, 58, 62], "61": 28, "63": 28, "appeal": 28, "hopefulli": [28, 38, 58, 65], "handl": 28, "tricki": [28, 29, 32], "scope": [28, 33, 34], "averag": [28, 30, 38], "year": [28, 71], "arithmet": [28, 30], "built": 28, "manual": 28, "spend": 28, "awkward": 28, "talk": 28, "inconveni": 28, "complementari": 28, "prefer": [28, 32, 54], "specif": [28, 67], "easili": [28, 34, 45, 47, 49, 58, 67], "extrem": [28, 39, 44], "minimum": [28, 30, 34, 38, 62], "maximum": [28, 30, 34, 42], "03reduc": 29, "orient": [29, 56], "unless": [29, 30], "bullet": 29, "toward": [29, 34, 38, 51], "continu": [29, 39], "friend": 29, "came": 29, "seem": [29, 30, 39, 47, 51, 62], "overkil": 29, "invalu": 29, "real": 29, "hundr": 29, "longer": [29, 37, 39, 42, 45, 62], "explicit": 29, "violat": 29, "rule": [29, 69], "imagin": [29, 30, 37], "sort": 29, "bunch": 29, "absolut": 29, "necessari": [29, 34], "solidifi": 29, "readili": 29, "But": [29, 34, 62], "tempt": [29, 30, 34, 67], "skim": 29, "snazzier": 29, "grasp": 29, "fundament": 29, "sensit": [29, 69, 70], "drawn": [29, 37, 45], "conveni": [29, 36, 37, 58, 62], "necess": 29, "neither": [29, 32, 38], "somewher": 29, "elimin": [29, 45, 47, 48, 55, 58, 65], "render": 29, "though": [29, 30, 34, 49, 53], "restraint": 29, "04group": 30, "fourth": [30, 36], "calcul": 30, "aggreg": [30, 34, 70], "statist": 30, "review": [30, 34, 45], "circumst": [30, 31, 40, 47, 48, 50, 51, 57, 66], "partit": 30, "count": [30, 32, 34, 39, 45, 58, 62], "achievementcount": 30, "sum": 30, "varianc": 30, "deviat": 30, "horizont": 30, "numproficiencyvalu": 30, "scalar": 30, "vertic": 30, "arrai": 30, "vector": 30, "failur": 30, "emerg": 30, "cover": [30, 58, 71], "visibl": 30, "lurk": 30, "twice": [30, 42, 65], "parenthes": [30, 37, 42, 44], "contempl": 30, "scroll": [30, 34, 54], "highli": 30, "quit": [30, 34, 39, 52, 58, 62, 69], "entir": 30, "mislead": 30, "realli": [30, 34, 58], "potenti": [30, 50, 65], "test": [30, 50, 55, 58, 62, 65], "origintownid": 30, "residetownid": 30, "highest": 30, "maximumprofici": 30, "lowest": 30, "Then": [30, 32, 36, 42, 58, 59, 69], "05unaryframework": 31, "framework": [31, 40, 57], "document": [31, 40], "06unaryexercis": 32, "button": 32, "click": 32, "imag": [32, 44], "check": [32, 34, 42, 48, 67], "haw": 32, "versu": 32, "collaps": 32, "pleas": [32, 34], "fill": [32, 34, 49, 62], "straightforward": [32, 39, 46, 52, 65], "bad": [32, 33, 34], "possibli": [32, 58, 62], "squar": 32, "creaturecount": 32, "achievementprofici": 32, "rolecount": 32, "contributionrolenam": 32, "averageteams": 32, "towncountri": 32, "26": 32, "h": 32, "27": 32, "28": 32, "sensic": 32, "countofachievedskil": 32, "townoffirstachievedskil": 32, "achievingcreatur": 32, "middl": [32, 58], "remind": [32, 36], "j": 32, "test_town": 32, "31": 32, "basic": [32, 62, 71], "introduct": [33, 41, 57], "danger": 33, "over": [33, 34, 44, 45, 57, 59, 61, 69], "00unarycombo": 34, "categori": [34, 45, 71], "head": 34, "guid": [34, 37, 38, 47, 62, 69, 71], "BY": [34, 58, 62], "un": 34, "skillcodecount": 34, "poor": [34, 67, 70], "mistak": 34, "plural": [34, 70], "lost": 34, "similar": [34, 37, 38, 54, 55, 58, 65, 67], "envis": 34, "interpret": [34, 42, 57, 67], "achievementd": 34, "nearbi": [34, 38], "comment": 34, "method": [34, 62], "around": 34, "uncom": 34, "jump": 34, "straight": 34, "skip": 34, "enough": [34, 45, 69], "temptat": 34, "argu": 34, "scratch": 34, "paper": 34, "electron": [34, 44], "pad": 34, "observ": [34, 45], "figur": 34, "spin": 34, "wheel": 34, "senseless": 34, "reaction": 34, "move": [34, 39], "00setintro": 36, "speak": [36, 69], "theori": [36, 58, 71], "overlook": 36, "soak": 36, "ever": 36, "matter": [36, 40], "upper": [36, 58], "half": [36, 45, 47, 48, 49, 51, 52, 65], "symmetri": [36, 40, 44, 46, 47, 50, 53, 56, 57], "cartesian": [36, 39], "plu": [36, 39], "full": [36, 44, 45, 47, 50, 58, 62, 67, 71], "wider": 36, "basi": [36, 39, 45, 65], "subsequ": [36, 58], "action": [36, 58], "visual": [36, 38, 41, 42, 65, 71], "decidedli": 36, "01unionintersectminussimpl": 37, "symmetr": [37, 40, 41, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 56], "oracl": [37, 71], "job": [37, 42], "IN": 37, "known": [37, 51], "inner": [37, 47, 48, 50, 58], "relay4x100creatur": 37, "garglingcreatur": 37, "send": 37, "op": [37, 40], "dowload": [37, 47], "unachiev": [37, 38], "02unionintersectminusadvanc": 38, "relation": 38, "nearli": 38, "ident": 38, "compat": 38, "achievedskillintownwithprofici": 38, "highlight": [38, 44, 50], "sketch": 38, "OR": 38, "BUT": 38, "nor": 38, "area": 38, "03time": 39, "power": [39, 42, 62, 65, 67], "mere": 39, "juxtapos": [39, 44], "against": [39, 62], "cross": 39, "theorist": 39, "underpin": 39, "hear": 39, "wow": 39, "door": 39, "amazingli": 39, "univers": [39, 62], "embed": 39, "preval": [39, 44, 50], "odd": 39, "challeng": 39, "tag": [39, 44, 45], "essenti": [39, 58], "c1": [39, 65], "169": 39, "truncat": 39, "convinc": 39, "rephras": [39, 48], "creature1": 39, "creature2": 39, "catch": 39, "appar": [39, 47, 49], "04setopsframework": 40, "union": [41, 45, 52, 58], "00timesfilterreduceex": 42, "interlud": 42, "farther": 42, "longest": 42, "demonstr": 42, "wouldn": 42, "forward": 42, "bigger": 42, "favorit": 42, "editor": 42, "attain": 42, "debug": 42, "00mjintro": 44, "emphas": [44, 62], "simplifi": 44, "character": 44, "scheme": 44, "disjoint": [44, 45, 47, 56], "bid": [44, 45, 46, 56, 57, 58, 59], "front": 44, "five": 44, "card": 44, "notebook": 44, "handi": [44, 47], "memor": 44, "01circumst": 45, "fall": [45, 65, 67], "attempt": [45, 71], "side": [45, 47, 49, 58], "roof": [45, 58], "discuss": [45, 52, 69], "x": 45, "y": 45, "goal": [45, 65], "true": 45, "forget": 45, "verifi": [45, 58, 71], "ll": 45, "luckili": 45, "outlin": 45, "02tableofcircumst": 46, "seven": 46, "nine": [46, 56], "col": [46, 57], "proce": 46, "tast": 46, "motiv": [46, 50], "03differentbase_m_1_1": 47, "frequent": 47, "symmtric": 47, "db": [47, 49], "succinct": 47, "tradit": [47, 48], "ON": [47, 62], "dbmss": 47, "infer": 47, "omit": 47, "useabl": 47, "nice": 47, "04differentbase_m_1_2": 48, "Or": [48, 70], "close": [48, 62], "peski": 48, "05differentbase_m_1_3": 49, "pertain": [49, 50], "color": 49, "origin_towndid": 49, "obvious": 49, "led": [49, 50], "backward": 49, "branch": 49, "pull": [49, 51], "emsod": [49, 50], "06differentbase_m_m": 50, "previous": 50, "center": 50, "yellow": [50, 65], "becam": 50, "07samebase_1_1_m_m": 51, "live": [51, 65], "ski": 51, "minnesota": 51, "perfect": 51, "footbal": 51, "Being": 51, "star": 51, "contriv": 51, "recommend": 51, "trickier": 51, "inspir": 51, "08samebase_1_1_e_": 52, "referenc": 52, "09samebase_1_1": 53, "parallel": 53, "propos": [53, 63], "10samerelation_m_1": 54, "idol": 54, "reflex": 54, "pare": 54, "11samerelation_m_m": 55, "12matchjoinframework": 56, "recap": 57, "01outerjoin": 58, "creaturenjachiev": 58, "nomenclatur": 58, "unabl": 58, "him": 58, "flip": [58, 59], "swap": [58, 59], "counterpart": 58, "indictor": 58, "creaureid": 58, "tri": 58, "creaturelojachievement_w": 58, "unusu": 58, "util": 58, "happenst": 58, "vision": 58, "literatur": 58, "curiou": 58, "02ojgener": 59, "outer": [59, 62, 71], "finish": 59, "w": 59, "notusedojtest": 60, "rescu": 61, "outerjoin": 61, "01divid": 62, "edgar": 62, "ted": 62, "codd": 62, "inventor": 62, "adventur": 62, "fit": 62, "defer": 62, "creator": 62, "outstand": 62, "stood": 62, "http": 62, "en": 62, "org": 62, "wiki": 62, "relational_algebra": 62, "1970": 62, "bank": 62, "acm": 62, "377": 62, "387": 62, "doi": 62, "1145": 62, "362384": 62, "362685": 62, "www": 62, "sea": 62, "upenn": 62, "edu": 62, "zive": 62, "03f": 62, "cis550": 62, "pdf": 62, "edgar_f": 62, "_codd": 62, "complic": 62, "nonetheless": 62, "seri": 62, "principl": 62, "brand": 62, "typic": [62, 65, 71], "survivor": 62, "obtus": 62, "constitut": [62, 67, 70], "met": 62, "criteria": 62, "ye": 62, "chosen": 62, "bold": 62, "compact": [62, 65], "break": 62, "nest": 62, "popular": 62, "col1_of_input": 62, "fulfil": 62, "col_of_pattern": 62, "in1": 62, "in2": 62, "col_of_input": 62, "unpack": 62, "minor": 62, "accordingli": 62, "hardest": 62, "p1": 62, "player": 62, "spokesperson": 62, "club": 62, "encumb": 62, "enjoi": 62, "articl": 62, "joe": 62, "celko": 62, "superman": 62, "notuseddivide_test": 63, "divis": 63, "01comparejoin": 65, "largest": 65, "rdbm": 65, "unsettl": 65, "particularli": 65, "unsatisfactori": 65, "entri": 65, "matrix": 65, "stuck": 65, "valid": 65, "train": 65, "partner": 65, "mentor": 65, "mente": 65, "coupl": [65, 70], "io": 65, "variat": 66, "01categoryrel": 67, "divid": [67, 71], "assist": 67, "ourselv": 67, "fair": 67, "swimmer": 67, "man": 67, "rang": [67, 71], "codifi": 67, "consult": [67, 71], "low": 67, "high": [67, 69], "glimps": 67, "distribut": 67, "suffici": 67, "gargling_categori": 67, "late": 67, "00ww_intro": 69, "request": [69, 70], "vagu": [69, 70], "inaccuraci": 69, "concert": 69, "everydai": 69, "discours": 69, "strictli": 69, "contract": 69, "agre": 69, "vagari": 69, "inher": 69, "rigid": 69, "judgment": 69, "revisit": 69, "insensit": 69, "me": [69, 71], "dismai": 69, "otherwis": 69, "invit": 69, "parti": 69, "pedant": 69, "she": 69, "conclud": 69, "smart": 69, "deserv": 69, "salari": 69, "refin": 69, "picki": 69, "emploi": 69, "01narr": 70, "misunderstand": 70, "unfamiliar": 70, "vocabulari": 70, "floater": 70, "pin": 70, "collid": 70, "scientist": 70, "biologi": 70, "xyphoid": 70, "sternum": 70, "invent": 70, "primatologist": 70, "chimp": 70, "nativ": 70, "habitat": 70, "januari": 70, "1977": 70, "libbi": 71, "shoop": 71, "macalest": 71, "colleg": 71, "saint": 71, "paul": 71, "2019": 71, "accompani": 71, "activ": 71, "life": 71, "substitut": 71, "begun": 71, "hand": 71, "strongli": 71, "techniqu": 71, "increasingli": 71, "postgr": 71, "instal": 71, "server": 71, "virtual": 71, "desktop": 71, "laptop": 71, "exhaust": 71, "piec": 71, "instructor": 71, "semest": 71, "nosql": 71, "deal": 71, "audienc": 71, "undergradu": 71, "graduat": 71, "unpublish": 71, "manuscript": 71, "entitl": 71, "2015": 71, "death": 71, "edit": 71, "onlin": 71, "interleav": 71, "professor": 71, "copyright": 71, "1999": 71, "elizabeth": 71, "reserv": 71, "extend": 71, "brad": 71, "miller": 71, "runeston": 71, "interact": 71, "platform": 71, "happi": 71, "yiyi": 71, "yuan": 71}, "objects": {}, "objtypes": {}, "objnames": {}, "titleterms": {"brief": 0, "background": 0, "conceptu": [0, 1, 71], "data": [0, 1, 2, 5, 6, 11, 15, 17, 25, 67, 68, 71], "model": [0, 1, 3, 71], "transit": 0, "from": [0, 3, 71], "implement": [0, 5, 7, 9, 10], "beyond": 1, "begin": [1, 2, 11], "add": 1, "how": [1, 2, 14, 45], "what": [1, 4, 12, 18, 39, 65, 66, 71], "One": [2, 3, 6, 33], "entiti": [2, 3, 5, 7, 10], "shape": [2, 3, 5, 6, 7, 8, 9, 10], "consid": [2, 34, 44, 45, 48], "creatur": [2, 5, 21, 27, 28, 29, 30, 45], "instanc": [2, 3, 5], "tabl": [2, 5, 11, 71], "creation": [2, 71], "popul": [2, 5], "try": [2, 47, 49, 50, 55, 62, 65, 67], "yourself": [2, 62], "start": 3, "basic": 3, "we": [4, 12, 20, 25, 57, 65, 66], "have": 4, "seen": 4, "so": 4, "far": 4, "two": [5, 7, 62], "relat": [5, 11, 12, 14, 15, 16, 17, 18, 20, 29, 33, 39, 44, 54, 55, 56, 67, 68, 71], "databas": [5, 14, 15, 21, 25, 71], "creat": 5, "new": [5, 67], "town": [5, 29], "re": 5, "through": 5, "gotcha": 5, "peek": 5, "ahead": 5, "natur": [5, 27], "join": [5, 44, 45, 46, 56, 57, 58, 60, 61, 65, 66], "relationship": [6, 7, 10], "some": [6, 28, 38], "note": [6, 28], "about": [6, 27, 28, 29, 36], "The": [8, 9, 12, 15, 17, 27, 33, 41, 44, 46, 57, 61, 64], "chicken": [8, 9, 56], "feet": [8, 9, 56], "an": [8, 9, 14, 37, 42, 44], "intersect": [8, 9, 36, 37, 38], "arbitrari": 8, "identifi": 8, "summari": [8, 12, 15, 30, 31, 40], "concept": 8, "introduc": 8, "three": 10, "master": [11, 71], "analysi": [11, 12, 14, 25], "v": 11, "achiev": [11, 27, 30, 32, 34, 42, 47, 48, 62, 67], "algebra": [11, 12, 71], "diagram": 11, "mean": 12, "queri": [12, 14, 34, 38, 47, 49, 50, 55, 65, 67, 70, 71], "role": 12, "sql": [12, 34, 71], "end": 12, "product": 12, "initi": 12, "tool": 12, "practic": [12, 34], "disciplin": 12, "plan": 12, "instead": 12, "doe": 12, "big": 12, "pictur": 12, "recip": [13, 15], "stuff": 13, "think": [14, 29], "like": [14, 30, 41], "analyst": 14, "essenc": 15, "defin": 15, "connect": 16, "between": [16, 56], "most": [17, 57], "import": [17, 36], "notion": 17, "gain": 17, "masteri": 17, "input": [18, 33, 39, 44], "output": 18, "result": [18, 29], "i": [18, 29, 30, 39, 71], "preced": [19, 20], "chart": [19, 20, 26], "oper": [20, 26, 28, 29, 31, 32, 33, 34, 35, 36, 40, 41, 44, 57, 61, 62, 64], "outlin": 20, "journei": 20, "take": 20, "A": [21, 25, 27, 43, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58, 59, 65], "small": [21, 25], "exampl": [21, 25, 27, 28, 29, 30, 37, 38, 39, 43, 58, 63], "us": [25, 34, 38, 42, 43], "unari": [26, 31, 32, 33, 34, 35], "introduct": [26, 36, 44], "draw": 26, "filter": [27, 32, 34, 44], "simpl": 27, "condit": 27, "anoth": [27, 36], "combin": [27, 34, 35, 42, 44], "scope": 27, "date": 27, "datatyp": 27, "dbm": 27, "word": 27, "phrase": 27, "exercis": [27, 28, 29, 30, 32, 34, 37, 38, 39, 48, 51, 62], "project": [28, 29, 32, 34, 44], "column": [28, 29, 30, 38, 44, 45, 56, 58], "comput": [28, 29], "skill": [28, 30, 34, 45, 47, 48, 67], "reduc": [29, 30, 32, 34, 44], "let": [29, 61], "": [29, 49, 61, 63], "thi": [29, 46, 56, 71], "contribut": [29, 65], "compar": [29, 65, 66], "name": 29, "bad": [29, 30], "case": [29, 30, 61], "danger": [29, 30], "ar": 29, "group": [30, 32, 34], "1": [30, 39, 47, 48, 49, 51, 52, 53, 54, 56, 71], "over": [30, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58], "one": 30, "2": [30, 39, 71], "multipl": 30, "3": 30, "characterist": 30, "more": [30, 62], "after": [34, 65, 66], "follow": [34, 43], "befor": 34, "first": [34, 57, 58], "avoid": 34, "non": [34, 36], "work": [34, 44, 45, 56, 69], "ad": [35, 64], "bit": 35, "complex": [35, 38, 57], "binari": [36, 40, 41, 57], "set": [36, 40, 41], "union": [36, 37, 38], "symmetr": 36, "minu": [36, 37, 38], "point": 36, "time": [36, 39, 44, 65, 66], "simplest": 37, "visual": 37, "aspir": [38, 49, 67], "all": 38, "addit": 38, "differ": [39, 41, 47, 48, 49, 50, 53, 56], "base": [39, 47, 48, 49, 50, 51, 52, 53, 56], "same": [39, 51, 52, 53, 54, 55, 56], "mathemat": 41, "often": 42, "put": 43, "piec": 43, "togeth": 43, "larger": 43, "well": 43, "pattern": [43, 44, 62, 64], "match": [44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 62, 64], "abstract": 44, "being": 44, "possibl": [44, 45, 56], "circumst": [45, 46, 56, 65], "For": [45, 46, 56], "symmetri": 45, "aspect": 45, "recap": 45, "common": [46, 57], "In": [46, 56], "chapter": [46, 56], "b": [47, 48, 49, 50, 51, 52, 53, 54, 55, 56], "m": [47, 48, 49, 50, 51, 54, 55, 56], "col": [47, 48, 49, 50, 51, 52, 53, 54, 55, 56], "aid": [47, 48, 49, 50, 51, 52, 53, 54, 55, 68], "d": [47, 48, 50, 54, 55], "bid": [47, 48, 49, 50, 51, 52, 53, 54, 55], "e": [47, 49, 52, 53, 54], "other": [47, 49, 50, 55, 65, 67], "null": 48, "valu": 48, "interpret": 53, "framework": 56, "itself": 56, "studi": 57, "outer": [58, 60, 61], "our": 58, "rescu": 58, "second": 58, "extra": 58, "right": 58, "both": 58, "gener": 59, "version": 59, "outerjoin": 59, "test": 60, "includ": 61, "those": 61, "degener": 61, "divid": [62, 64], "type": 62, "origin": 62, "least": 62, "exactli": 62, "less": 62, "joe": 63, "celko": 63, "page": 63, "sophist": 64, "variat": 65, "can": [65, 66], "do": [65, 66], "also": 65, "appli": 65, "aspiredcontribut": 65, "els": 66, "categori": [67, 68], "make": [67, 68], "miss": 67, "inform": 67, "analys": 68, "wai": [69, 70], "form": 70, "narr": 70, "mislead": 70, "book": 71, "part": 71, "content": 71, "recognit": 71, "thank": 71}, "envversion": {"sphinx.domains.c": 2, "sphinx.domains.changeset": 1, "sphinx.domains.citation": 1, "sphinx.domains.cpp": 8, "sphinx.domains.index": 1, "sphinx.domains.javascript": 2, "sphinx.domains.math": 2, "sphinx.domains.python": 3, "sphinx.domains.rst": 2, "sphinx.domains.std": 2, "sphinx": 57}, "alltitles": {"Brief Background of Conceptual Data Modeling": [[0, "brief-background-of-conceptual-data-modeling"]], "Transition from Conceptual Models to Implementation": [[0, "transition-from-conceptual-models-to-implementation"]], "Beyond Conceptual Data Modeling": [[1, "beyond-conceptual-data-modeling"]], "Beginning to add 'how' to the what": [[1, null]], "One-entity shapes: begin to consider \u2018how\u2019": [[2, "one-entity-shapes-begin-to-consider-how"]], "Creature Data Instances": [[2, "creature-data-instances"]], "Creature table creation": [[2, "creature-table-creation"]], "Populate Creature table with data instances": [[2, "populate-creature-table-with-data-instances"], [5, "populate-creature-table-with-data-instances"]], "Try it yourself": [[2, "try-it-yourself"]], "From model to instances: One-entity shapes": [[3, "from-model-to-instances-one-entity-shapes"]], "Start with the basics": [[3, null]], "What we have seen so far": [[4, "what-we-have-seen-so-far"]], "Implementing Two-entity Shapes in relational databases": [[5, "implementing-two-entity-shapes-in-relational-databases"]], "Create the new Town Table": [[5, "create-the-new-town-table"]], "Populate Town table with data instances": [[5, "populate-town-table-with-data-instances"]], "Re-create a new Creature table": [[5, "re-create-a-new-creature-table"]], "Relating instances through data": [[5, "relating-instances-through-data"]], "Gotcha!": [[5, null]], "Peek ahead: natural join": [[5, "peek-ahead-natural-join"]], "One-One to-be relationship Shape": [[6, "one-one-to-be-relationship-shape"]], "Some Notes about shape and data": [[6, "some-notes-about-shape-and-data"]], "Implementing relationships: Two-entity shapes": [[7, "implementing-relationships-two-entity-shapes"]], "Two-entity shapes": [[7, null]], "The Chicken-feet-in Shape: an intersection with arbitrary identifier": [[8, "the-chicken-feet-in-shape-an-intersection-with-arbitrary-identifier"]], "Summary of Concepts Introduced": [[8, "summary-of-concepts-introduced"]], "The Chicken-feet-in Shape: implementing an intersection": [[9, "the-chicken-feet-in-shape-implementing-an-intersection"]], "Implementing relationships: Three-entity shapes": [[10, "implementing-relationships-three-entity-shapes"]], "Three-entity shapes": [[10, null]], "Mastering relational data analysis": [[11, "mastering-relational-data-analysis"]], "Relations vs. Tables": [[11, "relations-vs-tables"]], "Achievement": [[11, "id1"], [27, "id2"], [30, "id1"], [32, "id1"], [32, "id2"], [32, "id3"], [34, "id2"], [42, "id1"], [47, "id1"], [48, "id1"], [62, "id7"], [67, "id3"]], "Beginning Analysis  with relational algebra diagrams": [[11, "beginning-analysis-with-relational-algebra-diagrams"]], "What We Mean by Querying and Analysis": [[12, "what-we-mean-by-querying-and-analysis"]], "The Role of SQL: the end product, not the initial tool": [[12, "the-role-of-sql-the-end-product-not-the-initial-tool"]], "Practice Discipline and Planning Instead": [[12, "practice-discipline-and-planning-instead"]], "What does \u201cRelational Algebra\u201d mean?": [[12, "what-does-relational-algebra-mean"]], "The Big Picture Summary": [[12, "the-big-picture-summary"]], "recipe-stuff": [[13, "id1"], [13, "id2"]], "Relational Databases, Querying, and Analysis": [[14, "relational-databases-querying-and-analysis"]], "How to think like an analyst": [[14, null]], "The Essence of Relational Databases": [[15, "the-essence-of-relational-databases"]], "Data in Relations": [[15, "data-in-relations"]], "Relation Defined": [[15, "relation-defined"]], "Recipe": [[15, "id1"]], "Summary": [[15, "summary"]], "Connections between Relations": [[16, "connections-between-relations"]], "Relational Data": [[17, "relational-data"]], "The most important notions for gaining mastery": [[17, null]], "Relations as input and output": [[18, "relations-as-input-and-output"]], "What the result relation is": [[18, "what-the-result-relation-is"]], "What the result is not": [[18, "what-the-result-is-not"]], "Precedence Charts": [[19, "precedence-charts"]], "Relational Operations and Precedence Charts": [[20, "relational-operations-and-precedence-charts"]], "Outlining the journey we will take": [[20, null]], "A small example database": [[21, "a-small-example-database"]], "Creature": [[21, "id1"], [27, "id1"], [28, "id1"], [29, "id1"], [30, "id2"], [45, "id5"]], "A Small Example Database": [[25, "a-small-example-database"]], "Data we will use for analysis": [[25, null]], "Unary Operator Introduction": [[26, "unary-operator-introduction"]], "Drawing Charts": [[26, "drawing-charts"]], "Filter": [[27, "filter"], [32, "filter"]], "Examples": [[27, "examples"], [28, "examples"]], "A simple condition": [[27, "a-simple-condition"]], "Another simple condition": [[27, "another-simple-condition"]], "Combining conditions": [[27, "combining-conditions"]], "The Scope and Nature of Filter": [[27, "the-scope-and-nature-of-filter"]], "Date datatype in DBMS": [[27, "date-datatype-in-dbms"]], "A word about phrasing": [[27, "a-word-about-phrasing"]], "Exercises": [[27, "exercises"], [28, "exercises"], [29, "exercises"], [30, "exercises"], [34, "exercises"], [37, "exercises"], [39, "exercises"], [62, "exercises"]], "Project": [[28, "project"], [32, "project"]], "Project some of the columns": [[28, "project-some-of-the-columns"]], "Projecting computed columns": [[28, "projecting-computed-columns"]], "Some notes about the project operator": [[28, "some-notes-about-the-project-operator"]], "Skill": [[28, "id2"], [30, "id3"], [34, "id1"], [45, "id6"], [47, "id2"], [48, "id2"], [48, "id3"], [67, "id1"]], "Reduce": [[29, "reduce"], [32, "reduce"]], "Example": [[29, "example"]], "Let\u2019s think about this operator": [[29, "let-s-think-about-this-operator"]], "Contribution": [[29, "id2"], [65, "id1"]], "Comparing Reduce to Project": [[29, "comparing-reduce-to-project"]], "Naming the result relation": [[29, "naming-the-result-relation"]], "Bad Case: Reduce is dangerous!": [[29, "bad-case-reduce-is-dangerous"]], "Town": [[29, "id3"]], "Bad Case: Computed columns in Reduce are dangerous.": [[29, "bad-case-computed-columns-in-reduce-are-dangerous"]], "Group": [[30, "group"], [32, "group"]], "Example 1: Group over one column": [[30, "example-1-group-over-one-column"]], "Example 2: Group over multiple columns": [[30, "example-2-group-over-multiple-columns"]], "Example 3: Group over no columns": [[30, "example-3-group-over-no-columns"]], "Summary of Group Characteristics": [[30, "summary-of-group-characteristics"]], "Group over no columns": [[30, "group-over-no-columns"]], "Group over one or more columns": [[30, "group-over-one-or-more-columns"]], "Bad Cases: Group, like Reduce, is dangerous!": [[30, "bad-cases-group-like-reduce-is-dangerous"]], "Summary of Unary Operators": [[31, "summary-of-unary-operators"]], "Exercises for Unary Operators": [[32, "exercises-for-unary-operators"]], "The Unary Operators": [[33, "the-unary-operators"]], "One relation as input": [[33, null]], "Combination Queries to Consider After Unary Operators": [[34, "combination-queries-to-consider-after-unary-operators"]], "Filter followed by Reduce": [[34, "filter-followed-by-reduce"]], "Filter followed by Project": [[34, "filter-followed-by-project"]], "Filter before a Group": [[34, "filter-before-a-group"]], "Reduce first, then Group": [[34, "reduce-first-then-group"]], "Group followed by Group": [[34, "group-followed-by-group"]], "Group then Filter": [[34, "group-then-filter"]], "Avoid non-useful work": [[34, "avoid-non-useful-work"]], "SQL Practice for Combination Queries": [[34, "sql-practice-for-combination-queries"]], "Combining the Unary Operators": [[35, "combining-the-unary-operators"]], "Adding a bit of complexity": [[35, null]], "Introduction to the Binary Set Operations": [[36, "introduction-to-the-binary-set-operations"]], "Union and Intersect: the Symmetric Operators": [[36, "union-and-intersect-the-symmetric-operators"]], "Minus: the Non-Symmetric Operator": [[36, "minus-the-non-symmetric-operator"]], "Important Points about Union, Intersect, and Minus": [[36, "important-points-about-union-intersect-and-minus"]], "Times, another Symmetric Operator": [[36, "times-another-symmetric-operator"]], "Simplest Examples of Union, Intersect, and Minus": [[37, "simplest-examples-of-union-intersect-and-minus"]], "Visualize an Example": [[37, "visualize-an-example"]], "Union example": [[37, "union-example"]], "Intersect example": [[37, "intersect-example"]], "Minus examples": [[37, "minus-examples"]], "Complex Examples of Union, Intersect, and Minus": [[38, "complex-examples-of-union-intersect-and-minus"]], "Aspiration": [[38, "id1"], [49, "id1"], [67, "id2"]], "Queries using all columns": [[38, "queries-using-all-columns"]], "Exercise": [[38, "exercise"], [48, "exercise"], [51, "exercise"]], "Queries with some, but not all columns": [[38, "queries-with-some-but-not-all-columns"]], "Additional Exercises": [[38, "additional-exercises"]], "Times": [[39, "times"]], "Example 1: different bases as input relations": [[39, "example-1-different-bases-as-input-relations"]], "Example 2: Same relation inputs": [[39, "example-2-same-relation-inputs"]], "What is the base?": [[39, "what-is-the-base"]], "Summary of Binary Set Operators": [[40, "summary-of-binary-set-operators"]], "The Binary Set Operators": [[41, "the-binary-set-operators"]], "Like mathematical sets, but different": [[41, null]], "An often-used Combination": [[42, "an-often-used-combination"]], "Putting pieces together": [[43, "putting-pieces-together"]], "A larger example that follows a well-used pattern": [[43, null]], "Introduction to Match Join": [[44, "introduction-to-match-join"]], "Times - Filter - Reduce/Project Pattern": [[44, "times-filter-reduce-project-pattern"]], "The Match Join Operator: an abstract combination": [[44, "the-match-join-operator-an-abstract-combination"]], "Considering input relations and the columns being matched": [[44, "considering-input-relations-and-the-columns-being-matched"]], "Works-on column possibilities for Match Join": [[44, "id1"], [45, "id4"], [56, "id1"]], "Circumstances For Match Joins": [[45, "circumstances-for-match-joins"]], "How to consider the Symmetry Aspect": [[45, "how-to-consider-the-symmetry-aspect"]], "Recap": [[45, "recap"]], "The Common Circumstances": [[46, "the-common-circumstances"]], "Circumstances For Match Joins In this Chapter": [[46, "id1"], [56, "id2"]], "Different Base A and B, M - 1 match over cols Aid(D), Bid(E)": [[47, "different-base-a-and-b-m-1-match-over-cols-aid-d-bid-e"]], "Other Queries to try": [[47, "other-queries-to-try"]], "Different Base A and B, M - 1 match over cols Aid(D),Bid(M)": [[48, "different-base-a-and-b-m-1-match-over-cols-aid-d-bid-m"]], "Considering NULL values": [[48, "considering-null-values"]], "Different Base A and B, M - 1 match over cols Aid(S),Bid(E)": [[49, "different-base-a-and-b-m-1-match-over-cols-aid-s-bid-e"]], "Other Queries to try:": [[49, "other-queries-to-try"], [50, "other-queries-to-try"], [55, "other-queries-to-try"], [67, "other-queries-to-try"]], "Different Base A and B, M - M match over cols Aid(D),Bid(D)": [[50, "different-base-a-and-b-m-m-match-over-cols-aid-d-bid-d"]], "Same Base A and B, 1 - 1 match over cols Aid(M),Bid(M)": [[51, "same-base-a-and-b-1-1-match-over-cols-aid-m-bid-m"]], "Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)": [[52, "same-base-a-and-b-1-1-match-over-cols-aid-e-bid-e"], [53, "same-base-a-and-b-1-1-match-over-cols-aid-e-bid-e"]], "A Different Interpretation": [[53, "a-different-interpretation"]], "Same Relation A and B, M - 1 match over cols Aid(D),Bid(E)": [[54, "same-relation-a-and-b-m-1-match-over-cols-aid-d-bid-e"]], "Same Relation A and B, M - M match over cols Aid(D),Bid(D)": [[55, "same-relation-a-and-b-m-m-match-over-cols-aid-d-bid-d"]], "Match Join Framework": [[56, "match-join-framework"]], "M - 1 match over cols between Different Base A and B": [[56, "m-1-match-over-cols-between-different-base-a-and-b"]], "M - M match over cols between Different Base A, B": [[56, "m-m-match-over-cols-between-different-base-a-b"]], "1 - 1 match over cols between Same Base A, B: chicken feet in": [[56, "match-over-cols-between-same-base-a-b-chicken-feet-in"]], "1 - 1 match over cols between Same Base A and B": [[56, "match-over-cols-between-same-base-a-and-b"]], "M - 1 match over cols between A and itself (Same Relation)": [[56, "m-1-match-over-cols-between-a-and-itself-same-relation"]], "M - M match over cols between A and itself (Same Relation)": [[56, "m-m-match-over-cols-between-a-and-itself-same-relation"]], "The Match Join Operator": [[57, "the-match-join-operator"]], "The most common operation, and the first of the complex binary operators that we will study.": [[57, null]], "Outer Join by Examples": [[58, "outer-join-by-examples"]], "Our first Example: Outer Join to the Rescue": [[58, "our-first-example-outer-join-to-the-rescue"]], "A second Example: over extra columns": [[58, "a-second-example-over-extra-columns"]], "Right Outer Join": [[58, "right-outer-join"]], "Both Outer Join": [[58, "both-outer-join"]], "A Generic Version of OuterJoin": [[59, "a-generic-version-of-outerjoin"]], "Test of Outer Join": [[60, "test-of-outer-join"]], "The Outer Join Operator": [[61, "the-outer-join-operator"]], "Let's include those degenerate cases": [[61, null]], "Divide Operator: two types": [[62, "divide-operator-two-types"]], "Divide, originally: \u201cmatches at least\u201d": [[62, "divide-originally-matches-at-least"]], "Exactly Divide: matching the pattern exactly (no more, no less)": [[62, "exactly-divide-matching-the-pattern-exactly-no-more-no-less"]], "Try yourself": [[62, "try-yourself"]], "Joe Celko\u2019s page examples": [[63, "joe-celko-s-page-examples"]], "The Divide Operator": [[64, "the-divide-operator"]], "Adding sophistication: pattern matching": [[64, null]], "A Variation: Compare Join": [[65, "a-variation-compare-join"]], "What can we do after a Times?": [[65, "what-can-we-do-after-a-times"]], "Other Circumstances also Apply": [[65, "other-circumstances-also-apply"]], "AspiredContribution": [[65, "id2"]], "Queries to try": [[65, "queries-to-try"]], "Compare Join": [[66, "compare-join"]], "What else we can do after a times": [[66, null]], "Category Relations": [[67, "category-relations"], [68, "category-relations"]], "Making missing information new data": [[67, "making-missing-information-new-data"]], "Making data to aid analyses": [[68, null]], "Ways of Work": [[69, "ways-of-work"]], "Ways of Forming Query Narratives": [[70, "ways-of-forming-query-narratives"]], "Misleading Narratives": [[70, "misleading-narratives"]], "Mastering Relational Databases: from Models to Querying": [[71, "mastering-relational-databases-from-models-to-querying"]], "What this book is for": [[71, "what-this-book-is-for"]], "What this book is not": [[71, "what-this-book-is-not"]], "Part 1: From conceptual models to SQL data creation": [[71, "part-1-from-conceptual-models-to-sql-data-creation"]], "Part 2: Mastering Database Querying with Relational Algebra and SQL": [[71, "part-2-mastering-database-querying-with-relational-algebra-and-sql"]], "Table of Contents": [[71, "table-of-contents"]], "Recognition and Thanks": [[71, "recognition-and-thanks"]]}, "indexentries": {}})