Introductory Relational Database Design for Business, with Microsoft Access

 
 
Standards Information Network (Verlag)
  • 1. Auflage
  • |
  • erschienen am 3. November 2017
  • |
  • 328 Seiten
 
E-Book | PDF mit Adobe DRM | Systemvoraussetzungen
978-1-119-32942-8 (ISBN)
 

A hands-on beginner's guide to designing relational databases and managing data using Microsoft Access

Relational 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.

Relational Database Design for Business, with Microsoft Access 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:

  • Takes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more
  • Gets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access
  • Moves swiftly from conceptual fundamentals to advanced design techniques
  • Leads 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

Introductory Relational Database Design for Business, with Microsoft Access 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.



Jonathan Eckstein 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.

Bonnie R. Schultz
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.

  • Englisch
  • Newark
  • |
  • Großbritannien
John Wiley & Sons Inc
  • Für höhere Schule und Studium
  • |
  • Für Beruf und Forschung
  • 14,49 MB
978-1-119-32942-8 (9781119329428)
1119329426 (1119329426)
weitere Ausgaben werden ermittelt
Jonathan Eckstein 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.

Bonnie R. Schultz 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.
  • "Title Page "
  • "Copyright Page"
  • "Contents"
  • "Preface"
  • "Chapter 1 Basic Definitions and Concepts"
  • "Basic Terms and Definitions"
  • "Types of Information Systems"
  • "Chapter 2 Beginning Fundamentals of Relational Databases and MS Access"
  • "Beginning Fundamentals of MS Access"
  • "A â??Hands-Onâ?? Example "
  • "Introduction to Forms"
  • "Another Method to Create Forms"
  • "Introduction to Reports"
  • "Introduction to Queries"
  • "Common Datatypes in MS Access"
  • "Exercises"
  • "Chapter 3 Introduction to Data Management and Database Design"
  • "Introduction to Data Management"
  • "General Data Management Issues"
  • "Classifying Information Systems Tasks: Transaction and Analytical Processing"
  • "What Is Wrong with Just One Table?"
  • "Repeating Groups"
  • "An Illustration of Multiple Tables and Foreign Keys"
  • "Chapter 4 Basic Relational Database Theory"
  • "Tables and Their Characteristics"
  • "Primary Keys and Composite Keys"
  • "Foreign Keys and Outline Notation"
  • "Creating Entity-Relationship (ER) Diagrams "
  • "Functional Dependency"
  • "Dependency Diagrams"
  • "Partial Dependency"
  • "Transitive Dependency"
  • "Database Anomalies"
  • "What Causes Anomalies?"
  • "How to Fix Anomalies"
  • "Good Database Design Principles"
  • "Normalization and Zip Codes"
  • "Expanding the Customer Loans Database"
  • "DVD Lending Library Example without Loan History"
  • "The DVD Lending Library Example with Loan History"
  • "Subtypes"
  • "Exercises"
  • "Chapter 5 Multiple Tables in Access"
  • "The Relationships Window and Referential Integrity"
  • "Nested Table View"
  • "Nested Forms"
  • "Queries with Multiple Tables"
  • "Multiple Joins and Aggregation"
  • "Personnel: Database Design with Multiple Paths between Tables"
  • "Creating the Database in Access using Autonumber Keys"
  • "A Simple Query and a Different Way to Express Joins in SQL"
  • "Exercises"
  • "Chapter 6 More about Forms and Navigation"
  • "More Capabilities of Forms"
  • "Packaging it Up â?? Navigation"
  • "Exercises"
  • "Chapter 7 Many-to-Many Relationships "
  • "Focus Groups Example"
  • "The Plumbing Store: Many-to-Many with an Additional Quantity Field "
  • "Hands-On Exercise and More About Queries and SQL "
  • "Project Teams: Many-to-Many with â??Flavorsâ?? of Membership "
  • "The Library"
  • "Exercises"
  • "Chapter 8 Multiple Relationships between the Same Pair of Tables"
  • "Commuter Airline Example"
  • "The College"
  • "Sports League Example"
  • "Multiple Relationships in Access"
  • "Exercises"
  • "Chapter 9 Normalization"
  • "First Normal Form"
  • "Second Normal Form"
  • "Third Normal Form"
  • "More Normal Forms"
  • "Key Factors to Recognize 3NF"
  • "Example with Multiple Candidate Keys"
  • "Normalizing an Office Supplies Database"
  • "Summary of Guidelines for Database Design"
  • "Exercises"
  • "Chapter 10 Basic Structured Query Language (SQL)"
  • "Using SQL in Access"
  • "The SELECT â?¦ FROM Statement"
  • "WHERE Conditions"
  • "Inner Joins"
  • "Cartesian Joins and a Different Way to Express Inner Joins"
  • "Aggregation"
  • "GROUP BY"
  • "HAVING"
  • "ORDER BY"
  • "The Overall Conceptual Structure of Queries"
  • "Exercises"
  • "Chapter 11 Advanced Query Techniques"
  • "Outer Joins"
  • "Outer Joins and Aggregation"
  • "Joining Multiple Records from the Same Table: AS in the FROM Clause"
  • "Another Use for AS in the FROM Clause"
  • "An Introduction to Query Chaining and Nesting"
  • "A More Complicated Example of Query Chaining: The League Standings"
  • "Subqueries and Back to the Plumbing Store Database"
  • "Practical Considerations and â??Bending the Rulesâ?? Against Redundancy"
  • "Exercises"
  • "Chapter 12 Unary Relationships"
  • "Employee Database"
  • "Setting Up and Querying a Unary Relationship in Access"
  • "The Course Catalog Database"
  • "Exercises"
  • "Further Reading"
  • "Index"

Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).

Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions (siehe E-Book Hilfe).

E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist. Mit Adobe-DRM wird hier ein "harter" Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Weitere Informationen finden Sie in unserer E-Book Hilfe.


Download (sofort verfügbar)

84,00 €
inkl. 19% MwSt.
Download / Einzel-Lizenz
PDF mit Adobe DRM
siehe Systemvoraussetzungen
E-Book bestellen

Unsere Web-Seiten verwenden Cookies. Mit der Nutzung dieser Web-Seiten erklären Sie sich damit einverstanden. Mehr Informationen finden Sie in unserem Datenschutzhinweis. Ok