{"product_id":"introductory-relational-database-design-for-business-with-microsoft-access-9781119329411","title":"Introductory Relational Database Design for","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eIntroductory Relational Database Design for Business with Microsoft Access takes a different approach to relational database design in that it develops understanding step-by-step, through numerous compact but realistic examples which build gradually in complexity.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003ePreface ix\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Basic Definitions and Concepts 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasic Terms and Definitions 1\u003c\/p\u003e \u003cp\u003eTypes of Information Systems 3\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Beginning Fundamentals of Relational Databases and MS Access 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBeginning Fundamentals of MS Access 8\u003c\/p\u003e \u003cp\u003eA “Hands‐On” Example 9\u003c\/p\u003e \u003cp\u003eIntroduction to Forms 15\u003c\/p\u003e \u003cp\u003eAnother Method to Create Forms 18\u003c\/p\u003e \u003cp\u003eIntroduction to Reports 22\u003c\/p\u003e \u003cp\u003eIntroduction to Queries 26\u003c\/p\u003e \u003cp\u003eCommon Datatypes in MS Access 32\u003c\/p\u003e \u003cp\u003eExercises 34\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Introduction to Data Management and Database Design 43\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction to Data Management 43\u003c\/p\u003e \u003cp\u003eGeneral Data Management Issues 43\u003c\/p\u003e \u003cp\u003eClassifying Information Systems Tasks: Transaction and Analytical Processing 45\u003c\/p\u003e \u003cp\u003eWhat is Wrong with Just One Table? 46\u003c\/p\u003e \u003cp\u003eRepeating Groups 47\u003c\/p\u003e \u003cp\u003eAn Illustration of Multiple Tables and Foreign Keys 48\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Basic Relational Database Theory 53\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTables and Their Characteristics 53\u003c\/p\u003e \u003cp\u003ePrimary Keys and Composite Keys 55\u003c\/p\u003e \u003cp\u003eForeign Keys and Outline Notation 57\u003c\/p\u003e \u003cp\u003eCreating Entity‐Relationship (ER) Diagrams 59\u003c\/p\u003e \u003cp\u003eFunctional Dependency 60\u003c\/p\u003e \u003cp\u003eDependency Diagrams 61\u003c\/p\u003e \u003cp\u003ePartial Dependency 62\u003c\/p\u003e \u003cp\u003eTransitive Dependency 63\u003c\/p\u003e \u003cp\u003eDatabase Anomalies 63\u003c\/p\u003e \u003cp\u003eWhat Causes Anomalies? 64\u003c\/p\u003e \u003cp\u003eHow to Fix Anomalies 65\u003c\/p\u003e \u003cp\u003eGood Database Design Principles 66\u003c\/p\u003e \u003cp\u003eNormalization and Zip Codes 67\u003c\/p\u003e \u003cp\u003eExpanding the Customer Loans Database 68\u003c\/p\u003e \u003cp\u003eDVD Lending Library Example without Loan History 71\u003c\/p\u003e \u003cp\u003eThe DVD Lending Library Example with Loan History 75\u003c\/p\u003e \u003cp\u003eSubtypes 78\u003c\/p\u003e \u003cp\u003eExercises 85\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Multiple Tables in Access 95\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Relationships Window and Referential Integrity 95\u003c\/p\u003e \u003cp\u003eNested Table View 100\u003c\/p\u003e \u003cp\u003eNested Forms 101\u003c\/p\u003e \u003cp\u003eQueries with Multiple Tables 103\u003c\/p\u003e \u003cp\u003eMultiple Joins and Aggregation 108\u003c\/p\u003e \u003cp\u003ePersonnel: Database Design with Multiple Paths between Tables 115\u003c\/p\u003e \u003cp\u003eCreating the Database in Access using Autonumber Keys 119\u003c\/p\u003e \u003cp\u003eA Simple Query and a Different Way to Express Joins in SQL 120\u003c\/p\u003e \u003cp\u003eExercises 123\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 More about Forms and Navigation 127\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMore Capabilities of Forms 127\u003c\/p\u003e \u003cp\u003ePackaging it Up – Navigation 132\u003c\/p\u003e \u003cp\u003eExercises 135\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Many‐to‐Many Relationships 139\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFocus Groups Example 139\u003c\/p\u003e \u003cp\u003eThe Plumbing Store: Many‐to‐Many with an Additional Quantity Field 143\u003c\/p\u003e \u003cp\u003eHands‐ On Exercise and More About Queries and SQL 146\u003c\/p\u003e \u003cp\u003eProject Teams: Many‐to‐Many with “Flavors” of Membership 154\u003c\/p\u003e \u003cp\u003eThe Library 159\u003c\/p\u003e \u003cp\u003eExercises 163\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Multiple Relationships between the Same Pair of Tables 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCommuter Airline Example 171\u003c\/p\u003e \u003cp\u003eThe College 177\u003c\/p\u003e \u003cp\u003eSports League Example 181\u003c\/p\u003e \u003cp\u003eMultiple Relationships in Access 183\u003c\/p\u003e \u003cp\u003eExercises 184\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Normalization 189\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFirst Normal Form 189\u003c\/p\u003e \u003cp\u003eSecond Normal Form 192\u003c\/p\u003e \u003cp\u003eThird Normal Form 194\u003c\/p\u003e \u003cp\u003eMore Normal Forms 197\u003c\/p\u003e \u003cp\u003eKey Factors to Recognize 3NF 198\u003c\/p\u003e \u003cp\u003eExample with Multiple Candidate Keys 198\u003c\/p\u003e \u003cp\u003eNormalizing an Office Supplies Database 198\u003c\/p\u003e \u003cp\u003eSummary of Guidelines for Database Design 202\u003c\/p\u003e \u003cp\u003eExercises 203\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Basic Structured Query Language (SQL) 215\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing SQL in Access 215\u003c\/p\u003e \u003cp\u003eThe SELECT … FROM Statement 215\u003c\/p\u003e \u003cp\u003eWHERE Conditions 217\u003c\/p\u003e \u003cp\u003eInner Joins 218\u003c\/p\u003e \u003cp\u003eCartesian Joins and a Different Way to Express Inner Joins 221\u003c\/p\u003e \u003cp\u003eAggregation 228\u003c\/p\u003e \u003cp\u003eGROUP BY 231\u003c\/p\u003e \u003cp\u003eHAVING 237\u003c\/p\u003e \u003cp\u003eORDER BY 238\u003c\/p\u003e \u003cp\u003eThe Overall Conceptual Structure of Queries 240\u003c\/p\u003e \u003cp\u003eExercises 243\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Advanced Query Techniques 253\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOuter Joins 253\u003c\/p\u003e \u003cp\u003eOuter Joins and Aggregation 256\u003c\/p\u003e \u003cp\u003eJoining Multiple Records from the Same Table: AS in the FROM Clause 260\u003c\/p\u003e \u003cp\u003eAnother Use for AS in the FROM Clause 262\u003c\/p\u003e \u003cp\u003eAn Introduction to Query Chaining and Nesting 262\u003c\/p\u003e \u003cp\u003eA More Complicated Example of Query Chaining: The League Standings 265\u003c\/p\u003e \u003cp\u003eSubqueries and Back to the Plumbing Store Database 270\u003c\/p\u003e \u003cp\u003ePractical Considerations and “Bending the Rules” Against Redundancy 274\u003c\/p\u003e \u003cp\u003eExercises 275\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Unary Relationships 279\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEmployee Database 279\u003c\/p\u003e \u003cp\u003eSetting Up and Querying a Unary Relationship in Access 283\u003c\/p\u003e \u003cp\u003eThe Course Catalog Database 291\u003c\/p\u003e \u003cp\u003eExercises 294\u003c\/p\u003e \u003cp\u003eFurther Reading 301\u003c\/p\u003e \u003cp\u003eIndex 303\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49407034786135,"sku":"9781119329411","price":71.06,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119329411.jpg?v=1730497950","url":"https:\/\/bookcurl.com\/products\/introductory-relational-database-design-for-business-with-microsoft-access-9781119329411","provider":"Book Curl","version":"1.0","type":"link"}