000 07567cam a2200625Mi 4500
001 on1011113995
005 20250919141833.0
006 m o d
007 cr |||||||||||
008 170613s2017 nju ob 001 0 eng d
020 _a1119329426
_q(electronic bk.)
020 _a9781119329428
_q(electronic bk.)
020 _a9781119430087
_q(electronic bk.)
020 _a1119430089
_q(electronic bk.)
020 _z9781119329428
020 _z9781119329411
_q(hardback)
020 _z1119329418
_q(hardback)
029 1 _aAU@
_b000060214933
029 1 _aCHBIS
_b011150917
029 1 _aCHNEW
_b000977992
029 1 _aCHVBK
_b504541862
029 1 _aCHVBK
_b508820480
029 1 _aGBVCP
_b1014968178
035 _a(OCoLC)1011113995
_z(OCoLC)1011116591
037 _a1047393
_bMIL
040 _aIDEBK
_beng
_erda
_epn
_cIDEBK
_dOCLCO
_dYDX
_dDG1
_dEBLCP
_dOCLCF
_dRECBK
_dMERER
_dOCLCQ
_dUPM
_dUAB
_dDG1
_dOCLCQ
_dIDEBK
_dCOO
_dWYU
_dLVT
049 _aMAIN
050 4 _aQA76.9.D3
082 0 4 _a005.75/65
_223
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
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
505 0 _a''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 _a''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 _a''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 _a''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 _a''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 _aA 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 _aRelational databases.
650 7 _aBUSINESS & ECONOMICS
_xStatistics.
_2bisacsh
650 7 _aRelational databases.
_2fast
_0(OCoLC)fst01093575
655 4 _aElectronic books.
700 1 _aSchultz, Bonnie R.,
_eauthor.
776 0 8 _iPrint version:
_z9781119329411
_z1119329418
_w(DLC) 2017019748
_w(OCoLC)989034302
856 4 0 _uhttps://eresourcesptsl.ukm.remotexs.co/user/login?url=https://doi.org/10.1002/9781119430087
_zWiley Online Library
907 _a.b16814587
_b2022-11-01
_c2020-07-17
942 _n0
998 _ae
_b2020-07-17
_cm
_dz
_feng
_gnju
_y0
_z.b16814587
999 _c648868
_d648868