rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: Introductory relational database design for business, with Microsoft Access
  name:
    name part: Eckstein, Jonathan
    role:
      role term: creator
    role:
      role term: author.
  name:
    name part: Schultz, Bonnie R.
    role:
      role term: author.
  type of resource: text
  genre: bibliography
  genre: Electronic books.
  origin info:
    place:
      place term: nju
    date issued: 2017
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: remote
    extent: 1 online resource
  abstract: "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: 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"--
  abstract: "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"--
  table of contents: 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
  table of contents: 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
  table of contents: 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
  table of contents: 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
  table of contents: 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
  note: by Jonathan Eckstein and Bonnie R. Schultz.
  note: 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.
  note: Includes bibliographical references and index.
  subject:
    title info:
      title: Microsoft Access
  subject:
    topic: Relational databases
  classification: QA76.9.D3 E35 2017
  classification: 005.75/65
  classification: BUS061000 COM039000
  related item:
    title info:
      title: Introductory relational database design for business, with Microsoft Access
    name:
      name part: Eckstein, Jonathan.
    origin info:
      publisher: Hoboken : Wiley, 2017
    identifier: (DLC) 2017019748
  identifier: 9781119329442
  identifier: 1119329442
  identifier: 9781119329428
  identifier: 1119329426
  identifier: 9781119430087
  identifier: 1119430089
  identifier: 9781119329411
  identifier: 1119329418
  identifier: 2017028117
  identifier: 5D9AD70D-E187-49E9-8CC9-D5CA7F4ABF33 OverDrive, Inc.
  identifier: http://proxy.library.tamu.edu/login
  record info:
    record content source: DLC
    record creation date: 170613
    record change date: 20260214210200.3
    record identifier: in00004686144
    language of cataloging:
      language term: eng