Introductory relational database design for business, with Microsoft Access

Başlık:

Yazar:

Eckstein, Jonathan, author.

ISBN:

9781119329442

9781119329428

9781119430087

Fiziksel Tanımlama:

1 online resource

Genel Not:

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.

İçerik:

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

Özet:

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

Notlar:

John Wiley and Sons

Konu Başlığı Ek Girişi:

Microsoft Access.

Microsoft Access

Konu Terimleri:

Relational databases.

Bases de données relationnelles.

BUSINESS & ECONOMICS -- Statistics.

COMPUTERS -- Management Information Systems.

Statistics.

Management Information Systems.