Cover Image

Introductory relational database design for business, with Microsoft Access /

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

Full description

Bibliographic Details
Main Authors: Eckstein, Jonathan (Author), Schultz, Bonnie R. (Author)
Format: eBook
Language:English
Published: Hoboken : Wiley, 2017.
Subjects:
Microsoft Access.
Relational databases.
Electronic books.
Online Access:Connect to the full text of this electronic book
Table of Contents:
  • 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 â#x80;#x9C;Hands-Onâ#x80;#x9D; 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 ManagementGeneral 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 AnomaliesWhat 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 TablesCreating 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 â#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 â#x80;#x9C;Flavorsâ#x80;#x9D; 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