{"product_id":"introductory-relational-database-design-for-business-with-microsoft-access-isbn-9781119329411","title":"Introductory Relational Database Design for Business, with Microsoft Access","description":"\u003cp\u003e\u003cb\u003eA hands-on beginner’s guide to designing relational databases and managing data using Microsoft Access\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRelational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less background, but they focus primarily on details of the user interface, with inadequate coverage of the underlying design issues of how to structure databases. Growing out of Professor Jonathan Eckstein’s twenty years’ experience teaching courses on management information systems (MIS) at Rutgers Business School, this book fills this gap in the literature by providing a rigorous introduction to relational databases for readers without prior computer science or programming experience.\u003c\/p\u003e \u003cp\u003e\u003ci\u003eRelational Database Design for Business, with Microsoft\u003c\/i\u003e \u003ci\u003eAccess\u003c\/i\u003e helps readers to quickly develop a thorough, practical understanding of relational database design. It takes a step-by-step, real-world approach, using application examples from business and finance every step the way. As a result, readers learn to think concretely about database design and how to address issues that commonly arise when developing and manipulating relational databases. By the time they finish the final chapter, students will have the knowledge and skills needed to build relational databases with dozens of tables. They will also be able to build complete Microsoft Access applications around such databases.  This text:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eTakes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more\u003c\/li\u003e \u003cli\u003eGets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access\u003c\/li\u003e \u003cli\u003eMoves swiftly from conceptual fundamentals to advanced design techniques\u003c\/li\u003e \u003cli\u003eLeads readers step-by-step through data management and design, relational database theory, multiple tables and the possible relationships between them, Microsoft Access features such as forms and navigation, formulating queries in SQL, and normalization \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eIntroductory Relational Database Design for Business, with Microsoft\u003c\/i\u003e\u003ci\u003eAccess\u003c\/i\u003e is the definitive guide for undergraduate and graduate students in business, finance, and data analysis without prior experience in database design. While Microsoft Access is its primary “hands-on” learning vehicle, most of the skills in this text are transferrable to other relational database software such as MySQL.\u003c\/p\u003e \u003cp\u003e \u003c\/p\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  \u003cp\u003e\u003cb\u003eJonathan Eckstein\u003c\/b\u003e is a Professor in the MSIS (Management Science and Information Systems) department at Rutgers Business School, Rutgers University, USA. He has taught at Harvard and Princeton Universities and has a strong profile on Google Scholar with over 9000 citations. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eBonnie R. Schultz\u003c\/b\u003e is a freelance writer and editor based in Princeton, New Jersey. She has worked as a technical writer in the software industry as well as a freelance journalist for various news publications.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eINTRODUCTORY RELATIONAL DATABASE DESIGN FOR BUSINESS\u003c\/b\u003e WITH MICROSOFT ACCESS \u003c\/p\u003e\u003cp\u003e\u003cb\u003eA HANDS-ON BEGINNER'S GUIDE TO DESIGNING RELATIONAL DATABASES AND MANAGING DATA USING MICROSOFT ACCESS\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eRelational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less background, but they focus primarily on details of the user interface, with inadequate coverage of the underlying design issues of how to structure databases. Growing out of Professor Jonathan Eckstein's twenty years' experience teaching courses on management information systems (MIS) at Rutgers Business School, this book fills this gap in the literature by providing a rigorous introduction to relational databases for readers without prior computer science or programming experience. \u003c\/p\u003e\u003cp\u003e\u003ci\u003eIntroductory Relational Database Design for Business, with Microsoft Access\u003c\/i\u003e helps readers to quickly develop a thorough, practical understanding of relational database design. It takes a step-by-step, real-world approach, using application examples from business and finance every step of the way. As a result, readers learn to think concretely about database design and how to address issues that commonly arise when developing and manipulating relational databases. By the time they finish the final chapter, students will have the knowledge and skills needed to build relational databases with dozens of tables. They will also be able to build complete Microsoft Access applications around such databases. This text: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eTakes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more\u003c\/li\u003e \u003cli\u003eGets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access\u003c\/li\u003e \u003cli\u003eMoves swiftly from conceptual fundamentals to advanced design techniques\u003c\/li\u003e \u003cli\u003eLeads readers step-by-step through data management and design, relational database theory, multiple tables and the possible relationships between them, Microsoft Access features such as forms and navigation, formulating queries in SQL, and normalization\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eIntroductory Relational Database Design for Business, with Microsoft Access\u003c\/i\u003e is the definitive guide for undergraduate and graduate students in business, finance, and data analysis without prior experience in database design. While Microsoft Access is its primary \"hands-on\" learning vehicle, most of the skills in this text are transferrable to other relational database software such as MySQL.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989470560485,"sku":"NP9781119329411","price":93.95,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119329411.jpg?v=1761784231","url":"https:\/\/k12savings.com\/es\/products\/introductory-relational-database-design-for-business-with-microsoft-access-isbn-9781119329411","provider":"K12savings","version":"1.0","type":"link"}