000 08738cam a2200877 i 4500
001 ocn990141297
003 OCoLC
005 20240523125540.0
006 m o d
007 cr |||||||||||
008 170613s2017 nju ob 001 0 eng
010 _a 2017028117
040 _aDLC
_beng
_erda
_epn
_cDLC
_dOCLCF
_dN$T
_dYDX
_dTEFOD
_dDLC
_dIDEBK
_dDG1
_dEBLCP
_dRECBK
_dMERER
_dUPM
_dUAB
_dCOO
_dWYU
_dLVT
_dMERUC
_dU3W
_dOCLCQ
_dOCLCO
_dOCLCQ
_dUKMGB
_dOCLCQ
_dOCLCO
_dOCLCQ
_dOCLCO
_dOCLCL
015 _aGBB7H1018
_2bnb
016 7 _a018518875
_2Uk
019 _a1011113995
_a1011116591
020 _a9781119329442
_q(epub)
020 _a1119329442
020 _a9781119329428
_q(pdf)
020 _a1119329426
020 _a9781119430087
_q(electronic bk.)
020 _a1119430089
_q(electronic bk.)
020 _z9781119329411
_q(hardback)
020 _z1119329418
029 1 _aAU@
_b000060214933
029 1 _aCHBIS
_b011150917
029 1 _aCHNEW
_b000977992
029 1 _aCHVBK
_b504541862
029 1 _aGBVCP
_b1014968178
029 1 _aUKMGB
_b018518875
035 _a(OCoLC)990141297
_z(OCoLC)1011113995
_z(OCoLC)1011116591
037 _a5D9AD70D-E187-49E9-8CC9-D5CA7F4ABF33
_bOverDrive, Inc.
_nhttp://www.overdrive.com
042 _apcc
050 0 0 _aQA76.9.D3
072 7 _aBUS
_x061000
_2bisacsh
072 7 _aCOM
_x039000
_2bisacsh
072 7 _aCOM
_x0210000
_2bisacsh
082 0 0 _a005.75/65
_223
084 _aBUS061000
_aCOM039000
_2bisacsh
049 _aMAIN
100 1 _aEckstein, Jonathan,
_eauthor.
245 1 0 _aIntroductory relational database design for business, with Microsoft Access /
_cby Jonathan Eckstein and Bonnie R. Schultz.
264 1 _aHoboken :
_bWiley,
_c2017.
300 _a1 online resource
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bn
_2rdamedia
338 _aonline resource
_bnc
_2rdacarrier
520 _a"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"--
_cProvided by publisher.
520 _a"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"--
_cProvided by publisher.
504 _aIncludes bibliographical references and index.
500 _aMachine 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.
588 0 _aPrint version record and CIP data provided by publisher.
505 0 _aTitle Page -- Copyright Page -- Contents -- Preface -- Chapter 1 Basic Definitions and�A Concepts -- Basic Terms and�A Definitions -- Types of�A Information Systems -- Chapter 2 Beginning Fundamentals of�A Relational Databases�A and�A MS Access -- Beginning Fundamentals of�A MS Access -- A �a#x80;#x9C;Hands-On�a#x80;#x9D; Example -- Introduction to�A Forms -- Another Method to�A Create Forms -- Introduction to�A Reports -- Introduction to�A Queries -- Common Datatypes in�A MS Access -- Exercises -- Chapter 3 Introduction to�A Data Management and�A Database Design
505 8 _aIntroduction to�A Data ManagementGeneral Data Management Issues -- Classifying Information Systems Tasks: Transaction and�A Analytical Processing -- What Is Wrong with�A Just One Table? -- Repeating Groups -- An Illustration of�A Multiple Tables and�A Foreign Keys -- Chapter 4 Basic Relational Database Theory -- Tables and�A Their Characteristics -- Primary Keys and�A Composite Keys -- Foreign Keys and�A Outline Notation -- Creating Entity-Relationship (ER) Diagrams -- Functional Dependency -- Dependency Diagrams -- Partial Dependency -- Transitive Dependency
505 8 _aDatabase AnomaliesWhat Causes Anomalies? -- How to�A Fix Anomalies -- Good Database Design Principles -- Normalization and�A Zip Codes -- Expanding the�A Customer Loans Database -- DVD Lending Library Example without Loan History -- The DVD Lending Library Example with�A Loan History -- Subtypes -- Exercises -- Chapter 5 Multiple Tables in�A Access -- The Relationships Window and�A Referential Integrity -- Nested Table View -- Nested Forms -- Queries with�A Multiple Tables -- Multiple Joins and�A Aggregation
505 8 _aPersonnel: Database Design with�A Multiple Paths between TablesCreating the�A Database in�A Access using Autonumber Keys -- A Simple Query and�A a�A Different Way to�A Express Joins in�A SQL -- Exercises -- Chapter 6 More about Forms and�A Navigation -- More Capabilities of�A Forms -- Packaging it Up�A �a#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 _aProject Teams: Many-to-Many with �a#x80;#x9C;Flavors�a#x80;#x9D; of Membership The Library -- Exercises -- Chapter 8 Multiple Relationships between the�A Same Pair�A of�A Tables -- Commuter Airline Example -- The College -- Sports League Example -- Multiple Relationships in�A Access -- Exercises -- Chapter 9 Normalization -- First Normal Form -- Second Normal Form -- Third Normal Form -- More Normal Forms -- Key Factors to�A Recognize 3NF -- Example with�A Multiple Candidate Keys -- Normalizing an�A Office Supplies Database -- Summary of�A Guidelines for�A Database Design
590 _aJohn Wiley and Sons
_bWiley Online Library: Complete oBooks
630 0 0 _aMicrosoft Access.
630 0 7 _aMicrosoft Access
_2fast
650 0 _aRelational databases.
650 6 _aBases de donn�ees relationnelles.
650 7 _aBUSINESS & ECONOMICS
_xStatistics.
_2bisacsh
650 7 _aCOMPUTERS
_xManagement Information Systems.
_2bisacsh
650 7 _aRelational databases
_2fast
700 1 _aSchultz, Bonnie R.,
_eauthor.
758 _ihas work:
_aIntroductory relational database design for business, with Microsoft Access (Text)
_1https://id.oclc.org/worldcat/entity/E39PCFPqtYrvqYMq98CQV3D7wP
_4https://id.oclc.org/worldcat/ontology/hasWork
776 0 8 _iPrint version:
_aEckstein, Jonathan.
_tIntroductory relational database design for business, with Microsoft Access.
_dHoboken : Wiley, 2017
_z9781119329411
_w(DLC) 2017019748
856 4 0 _uhttps://onlinelibrary.wiley.com/doi/book/10.1002/9781119430087
938 _aEBSCOhost
_bEBSC
_n1626799
938 _aProQuest MyiLibrary Digital eBook Collection
_bIDEB
_ncis38120426
938 _aRecorded Books, LLC
_bRECE
_nrbeEB00717150
938 _aYBP Library Services
_bYANK
_n14981670
938 _aYBP Library Services
_bYANK
_n14964086
994 _a92
_bINLUM
999 _c12449
_d12449