Introductory relational database design for business, with Microsoft Access / Jonathan Eckstein, Bonnie R. Schultz
Book | John Wiley & Sons, Inc. | 2018
Available at Gateway-Racine Campus General Collection (QA 76.9 D3 E3.25 2018)

Additional actions:

close
see all

Items

Location Call No. Status
Gateway-Racine Campus General Collection QA 76.9 D3 E3.25 2018 Available
Show fewer items

More Details

Description
xii, 309 pages ; 24 cm
Bibliography
Includes bibliographical references and index.
Contents
1. Basic Definition and Concepts
Basic Terms and Definitions -- Types of Information Systems
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
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
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
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
6. More about Forms and Navigation
More Capabilities of Forms -- Packaging it Up - Navigation -- Exercises
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
8. Multiple Relationships between the Same Pair of Tables
Communter Airline Example -- The College -- Sports League Example -- Multiple Relationships in Access -- Exercises
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
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 Strucutre of Queries -- Exercises
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
12. Unary Relationships
Employee Database -- Setting Up and Querying a Unary Relationship in Access -- The Course Catalog Database -- Exercises
Summary
"Introductory Relational Database Design for Business with Microsoft Access takes a different approach to relational 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 thorough grounding 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, and 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.
85.00 DPWEB (31-152-4)
Subject
Added Author
Schultz, Bonnie R., author.
Browse Results
Other Sources:
View in classic catalog View MARC display
Back to top