𝔖 Scriptorium
✦   LIBER   ✦

📁

Introductory relational database design for business, with Microsoft Access

✍ Scribed by Eckstein, Jonathan; Schultz, Bonnie R


Publisher
Wiley
Year
2017
Tongue
English
Leaves
314
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


A hands-on beginner's guide to designing relational databases and managing data using Microsoft Access Relational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less Read more...


Abstract:
A hands-on beginner s guide to designing relational databases and managing data using Microsoft Access Relational databases represent one of the most enduring and pervasive forms of information Read more...

✦ Table of Contents


Content: ""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 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""
""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 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""
""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 Tables""""Creating 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""

✦ Subjects


Relational databases.;BUSINESS & ECONOMICS / Statistics.


📜 SIMILAR VOLUMES


Introductory Relational Database Design
✍ Jonathan Eckstein, Bonnie R. Schultz 📂 Library 📅 2018 🏛 Wiley 🌐 English

A hands-on beginner's guide to designing relational databases and managing data using Microsoft Access   Relational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated comp

Database Design and Applications Develop
✍ Rob P., Williams T. 📂 Library 📅 1995 🏛 MGH 🌐 English

This practical, introductory text fits a full semester database tutorial course or database design course and is designed to be used with Microsoft Access 2.0 for Windows software. This unique text serves a dual purpose by offering keystroke, step-by-step instructions and good database design princi

Go! with Microsoft Access 2010: introduc
✍ Gaskin, Shelley;McLellan, Carolyn E;Graviett, Nancy 📂 Library 📅 2013;2014 🏛 Pearson 🌐 English

For introductory computer courses on Microsoft Access 2010 or courses in computer concepts with a lab component on Access. Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clear

Programming Microsoft Visual Basic .NET
✍ Rick Dobson 📂 Library 📅 2002 🏛 Microsoft Press 🌐 English

The MicrosoftR .NET Framework represents an exciting new world for developers who work with Microsoft Access, Visual BasicR, and Visual Basic for Applications. This book provides complete, practical details on how to take advantage of this world by building or upgrading Access-based client applicati