Introductory relational database design for business, with Microsoft Access / (Record no. 648868)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 07567cam a2200625Mi 4500 |
| 001 - CONTROL NUMBER | |
| control field | on1011113995 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20250919141833.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr ||||||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 170613s2017 nju ob 001 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1119329426 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119329428 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119430087 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1119430089 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9781119329428 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9781119329411 |
| Qualifying information | (hardback) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 1119329418 |
| Qualifying information | (hardback) |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | AU@ |
| System control number | 000060214933 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHBIS |
| System control number | 011150917 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHNEW |
| System control number | 000977992 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHVBK |
| System control number | 504541862 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHVBK |
| System control number | 508820480 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | GBVCP |
| System control number | 1014968178 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)1011113995 |
| Canceled/invalid control number | (OCoLC)1011116591 |
| 037 ## - SOURCE OF ACQUISITION | |
| Stock number | 1047393 |
| Source of stock number/acquisition | MIL |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | IDEBK |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | IDEBK |
| Modifying agency | OCLCO |
| -- | YDX |
| -- | DG1 |
| -- | EBLCP |
| -- | OCLCF |
| -- | RECBK |
| -- | MERER |
| -- | OCLCQ |
| -- | UPM |
| -- | UAB |
| -- | DG1 |
| -- | OCLCQ |
| -- | IDEBK |
| -- | COO |
| -- | WYU |
| -- | LVT |
| 049 ## - LOCAL HOLDINGS (OCLC) | |
| Holding library | MAIN |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.D3 |
| 082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.75/65 |
| Edition information | 23 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Eckstein, Jonathan, |
| Relator term | author. |
| 245 10 - TITLE STATEMENT | |
| Title | Introductory relational database design for business, with Microsoft Access / |
| Statement of responsibility, etc. | by Jonathan Eckstein and Bonnie R. Schultz. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Hoboken : |
| Name of producer, publisher, distributor, manufacturer | Wiley, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2017. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 505 0# - FORMATTED CONTENTS NOTE | |
| 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'' |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | ''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'' |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | ''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'' |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | ''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'' |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | ''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'' |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | 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 background, but they focus primarily on details of the user interface, with inadequate coverage of the underlying design issues of how to structure databases. Growing out of Professor Jonathan Eckstein's twenty years' experience teaching courses on management information systems (MIS) at Rutgers Business School, this book fills this gap in the literature by providing a rigorous introduction to relational databases for readers without prior computer science or programming experience. Relational Database Design for Business, with Microsoft Access helps readers to quickly develop a thorough, practical understanding of relational database design. It takes a step-by-step, real-world approach, using application examples from business and finance every step the way. As a result, readers learn to think concretely about database design and how to address issues that commonly arise when developing and manipulating relational databases. By the time they finish the final chapter, students will have the knowledge and skills needed to build relational databases with dozens of tables. They will also be able to build complete Microsoft Access applications around such databases. This text: -Takes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more -Gets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access -Moves swiftly from conceptual fundamentals to advanced design techniques -Leads readers step-by-step through data management and design, relational database theory, multiple tables and the possible relationships between them, Microsoft Access features such as forms and navigation, formulating queries in SQL, and normalization Introductory Relational Database Design for Business, with Microsoft Access is the definitive guide for undergraduate and graduate students in business, finance, and data analysis without prior experience in database design. While Microsoft Access is its primary'hands-on' learning vehicle, most of the skills in this text are transferrable to other relational database software such as MySQL. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Relational databases. |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | BUSINESS & ECONOMICS |
| General subdivision | Statistics. |
| Source of heading or term | bisacsh |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Relational databases. |
| Source of heading or term | fast |
| Authority record control number or standard number | (OCoLC)fst01093575 |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Schultz, Bonnie R., |
| Relator term | author. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| International Standard Book Number | 9781119329411 |
| -- | 1119329418 |
| Record control number | (DLC) 2017019748 |
| -- | (OCoLC)989034302 |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://eresourcesptsl.ukm.remotexs.co/user/login?url=https://doi.org/10.1002/9781119430087">https://eresourcesptsl.ukm.remotexs.co/user/login?url=https://doi.org/10.1002/9781119430087</a> |
| Public note | Wiley Online Library |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | .b16814587 |
| b | 2022-11-01 |
| c | 2020-07-17 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Suppress in OPAC | No |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| Library | |
| Operator's initials, OID (RLIN) | 2020-07-17 |
| Cataloger's initials, CIN (RLIN) | m |
| Material Type (Sierra) | E-Book |
| Language | English |
| Country | |
| -- | 0 |
| -- | .b16814587 |
No items available.