"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: <ul style="line-height: 25px; margin-left: 15px; margin-top: 0px; font-family: Arial; font-size: 13.3333px;"> Lasting hands-on knowledge of a pervasive and useful technology Acquisition of immediately marketable skills Development of analytical thinking and problem solving. Designing a database is a highly analytical skill, involving breaking down a situation into its critical components and clearly elucidating the relationships between these components. Learning such a skill develops the mind generally, fostering abilities in critical thinking and problem solving. Developing such abilities is an important component of any college education, regardless of students' fields of study"-- Provided by publisher.

"This book develops understanding of relational databases step-by-step, through numerous compact but realistic examples that build gradually in complexity. While readers will not necessarily gain enough experience to design large-scale organizational systems with hundreds or thousands of tables, they do get a thorough grounding in the technology and its applications, enough to build useful systems with dozens of tables. At every stage, the technology is presented through application examples from business, as well as other fields, giving the reader a chance to concretely think through the details and issues that often arise"-- Provided by publisher.

Includes bibliographical references and index.

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.

Print version record and CIP data provided by publisher.

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

John Wiley and Sons Wiley Online Library: Complete oBooks