Introductory relational database design for business, with Microsoft Access / by Jonathan Eckstein and Bonnie R. Schultz.
2017
QA76.9.D3
Formats
| Format | |
|---|---|
| BibTeX | |
| MARCXML | |
| TextMARC | |
| MARC | |
| DublinCore | |
| EndNote | |
| NLM | |
| RefWorks | |
| RIS |
Linked e-resources
Details
Title
Introductory relational database design for business, with Microsoft Access / by Jonathan Eckstein and Bonnie R. Schultz.
Author
ISBN
9781119329442 (epub)
1119329442
9781119329428 (pdf)
1119329426
9781119430087 (electronic bk.)
1119430089 (electronic bk.)
9781119329411 (hardback)
1119329418
1119329442
9781119329428 (pdf)
1119329426
9781119430087 (electronic bk.)
1119430089 (electronic bk.)
9781119329411 (hardback)
1119329418
Published
Hoboken : Wiley, 2017.
Language
English
Description
1 online resource
Call Number
QA76.9.D3
System Control No.
(OCoLC)990141297
Summary
"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:
- 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.
Note
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.
Bibliography, etc. Note
Includes bibliographical references and index.
Formatted Contents Note
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
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
Source of Description
Print version record and CIP data provided by publisher.
Added Author
Available in Other Form
Print version: Eckstein, Jonathan. Introductory relational database design for business, with Microsoft Access. Hoboken : Wiley, 2017
Linked Resources
Record Appears in