Eckstein, Jonathan,

Introductory relational database design for business, with Microsoft Access / by Jonathan Eckstein and Bonnie R. Schultz. - 1 online resource

Machine generated contents note: Preface 1. Basic Definitions and Concepts 2. Beginning Fundamentals of Relational Databases and MS Access 3. Introduction to Data Management and Database Design 4. Basic Relational Database Theory 5. Multiple Tables in Access 6. More about Forms and Navigation 7. Many-to-Many Relationships 8. Multiple Relationships between the Same Pair of Tables 9. Normalization 10. Basic SQL 11. Advanced Query Techniques 12. Unary Relationships Further Reading Index.

Includes bibliographical references and index.

Title Page -- Copyright Page -- Contents -- Preface -- Chapter 1 Basic Definitions and�A Concepts -- Basic Terms and�A Definitions -- Types of�A Information Systems -- Chapter 2 Beginning Fundamentals of�A Relational Databases�A and�A MS Access -- Beginning Fundamentals of�A MS Access -- A �a#x80;#x9C;Hands-On�a#x80;#x9D; Example -- Introduction to�A Forms -- Another Method to�A Create Forms -- Introduction to�A Reports -- Introduction to�A Queries -- Common Datatypes in�A MS Access -- Exercises -- Chapter 3 Introduction to�A Data Management and�A Database Design Introduction to�A Data ManagementGeneral Data Management Issues -- Classifying Information Systems Tasks: Transaction and�A Analytical Processing -- What Is Wrong with�A Just One Table? -- Repeating Groups -- An Illustration of�A Multiple Tables and�A Foreign Keys -- Chapter 4 Basic Relational Database Theory -- Tables and�A Their Characteristics -- Primary Keys and�A Composite Keys -- Foreign Keys and�A Outline Notation -- Creating Entity-Relationship (ER) Diagrams -- Functional Dependency -- Dependency Diagrams -- Partial Dependency -- Transitive Dependency Database AnomaliesWhat Causes Anomalies? -- How to�A Fix Anomalies -- Good Database Design Principles -- Normalization and�A Zip Codes -- Expanding the�A Customer Loans Database -- DVD Lending Library Example without Loan History -- The DVD Lending Library Example with�A Loan History -- Subtypes -- Exercises -- Chapter 5 Multiple Tables in�A Access -- The Relationships Window and�A Referential Integrity -- Nested Table View -- Nested Forms -- Queries with�A Multiple Tables -- Multiple Joins and�A Aggregation Personnel: Database Design with�A Multiple Paths between TablesCreating the�A Database in�A Access using Autonumber Keys -- A Simple Query and�A a�A Different Way to�A Express Joins in�A SQL -- Exercises -- Chapter 6 More about Forms and�A Navigation -- More Capabilities of�A Forms -- Packaging it Up�A �a#x80;#x93; 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 �a#x80;#x9C;Flavors�a#x80;#x9D; of Membership The Library -- Exercises -- Chapter 8 Multiple Relationships between the�A Same Pair�A of�A Tables -- Commuter Airline Example -- The College -- Sports League Example -- Multiple Relationships in�A Access -- Exercises -- Chapter 9 Normalization -- First Normal Form -- Second Normal Form -- Third Normal Form -- More Normal Forms -- Key Factors to�A Recognize 3NF -- Example with�A Multiple Candidate Keys -- Normalizing an�A Office Supplies Database -- Summary of�A Guidelines for�A Database Design

"Introductory Relational Database Design for Business with Microsoft Access takes a different approachtorelational database design in that it develops understanding step-by-step, through numerous compact but realistic examples which build gradually in complexity. Readers will be able to achieve a thoroughgrounding in the technology and its applications and at every stage, the technology is presented through applications examples from business, as well as other fields, giving the reader a chance to concretely think through the details and issues that often arise. By using this textbook, the student will be able to achieve: