
Database Concepts, Global Edition
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Cover
- Brief Contents
- Contents
- Part I: Database Fundamentals
- Chapter 1: Getting Started: An Overview of Databases
- Why Use a Database?
- Problems with Lists
- Using Relational Database Tables
- Processing Relational Tables
- What Is a Database System?
- The Database
- The DBMS
- Personal Versus Enterprise-Class Database Systems
- What Is a NoSQL Database?
- The Access Workbench Section 1-Getting Started with Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Key Terms
- Access Workbench Exercises
- San Juan Sailboat Charters Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions (See Online Appendix D)
- The Queen Anne Curiosity Shop Project Questions
- Chapter 2: The Relational Model and Database Normalization
- Relations
- A Sample Relation and Two Nonrelations
- A Note on Presenting Relation Structures
- A Note on Terminology
- Types of Keys
- Composite Keys
- Candidate and Primary Keys
- Surrogate Keys
- Foreign Keys and Referential Integrity
- The Problem of Null Values
- Functional Dependencies and Normalization
- Functional Dependencies
- Primary and Candidate Keys Revisited
- Normalization
- Relational Design Principles
- The Normalization Process
- Normalization Examples
- Eliminating Anomalies from Multivalued Dependencies
- Normal Forms: One Step at a Time
- The Access Workbench Section 2-Working with Multiple Tables in Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Key Terms
- Access Workbench Exercises
- Regional Labs Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions (See Online Appendix D)
- The Queen Anne Curiosity Shop Project Questions
- Chapter 3: Structured Query Language
- An Example Database
- Does Not Work with Microsoft Access ANSI-89 SQL
- SQL for Data Definition (DDL)-Creating Tables and Relationships
- Defining Primary Keys with Table Constraints
- Defining Foreign Keys with the Table Constraints
- Submitting SQL to the DBMS
- SQL for Data Manipulation (DML)-Inserting Data
- Inserting Data
- SQL for Data Manipulation (DML)-Single Table Queries
- The SQL SELECT/FROM/WHERE Framework
- Reading Specified Columns from a Single Table
- Reading Specified Rows from a Single Table
- Reading Specified Columns and Specified Rows from a Single Table
- Ranges, Wildcards, and Nulls in WHERE Clauses
- Sorting the Results of a Query
- SQL Built-in Functions and Calculations
- Built-in Functions and Grouping
- SQL for Data Manipulation (DML)- Multiple Table Queries
- Querying Multiple Tables with Subqueries
- Querying Multiple Tables with Joins
- The SQL JOIN ON Syntax
- Inner Joins and Outer Joins
- SQL for Data Manipulation (DML)-Data Modification and Deletion
- Modifying Data
- Deleting Data
- SQL for Data Definition (DDL)-Table and Constraint Modification and Deletion
- The SQL DROP TABLE Statement
- The SQL ALTER TABLE Statement
- The SQL TRUNCATE TABLE Statement
- The CHECK Constraint
- SQL Views
- The Access Workbench Section 3-Working with Queries in Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Key Terms
- Access Workbench Exercises
- Heather Sweeney Designs Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions (See Online Appendix D
- The Queen Anne Curiosity Shop Project Questions
- Part 2: Database Design
- Chapter 4: Data Modeling and the Entity-Relationship Model
- Requirements Analysis
- The Entity-Relationship Data Model
- Entities
- Attributes
- Identifiers
- Relationships
- Entity-Relationship Diagrams
- Variations of the E-R Model
- The IE Crow's Foot E-R Model
- Weak Entities
- ID-Dependent Entities
- Non-ID-Dependent Weak Entities
- Associative Entities
- Subtype Entities
- Recursive Relationships
- Developing an Example E-R Diagram
- Heather Sweeney Designs
- The Seminar Customer List
- The Customer Form Letter
- The Sales Invoice
- Attribute Specifications
- Business Rules
- Validating the Data Model
- The Access Workbench Section 4-Prototyping Using Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Key Terms
- Access Workbench Exercises
- Highline University Mentor Program Case Questions
- Washington State Patrol Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions (See Online Appendix D)
- The Queen Anne Curiosity Shop Project Questions
- Chapter 5: Database Design
- The Purpose of a Database Design
- Transforming a Data Model into a Database Design
- Representing Entities with the Relational Model
- Representing the ITEM Entity
- Representing the CUSTOMER Entity
- Denormalization
- A Relational Design for the SALES_COMMISSION Entity
- Representing Weak Entities
- Representing Relationships
- Relationships Between Strong Entities
- Relationships Using Weak Entities
- Relationships with Subtypes
- Representing Recursive Relationships
- Database Design at Heather Sweeney Designs
- Weak Entities
- Verifying Normalization
- Specifying Column Properties
- Relationships
- Enforcing Referential Integrity
- The Access Workbench Section 5-Relationships in Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Key Terms
- Access Workbench Exercises
- San Juan Sailboat Charters Case Questions
- Washington State Patrol Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions (See Online Appendix D)
- The Queen Anne Curiosity Shop Project Questions
- Part 3: Database Management
- Chapter 6: Database Administration and Management
- The Heather Sweeney Designs Database
- The Need for Control, Security, and Reliability
- Concurrency Control
- The Need for Atomic Transactions
- Concurrent Transaction Processing
- The Lost Update Problem
- Resource Locking
- Serializable Transactions
- Deadlock
- Optimistic Versus Pessimistic Locking
- SQL Transaction Control Language and Declaring Lock Characteristics
- Consistent Transactions
- Transaction Isolation Level
- Cursor Types
- Database Security
- User Accounts
- User Processing Rights and Responsibilities
- DBMS-Level Security
- Application-Level Security
- Database Backup and Recovery
- Recovery via Reprocessing
- Recovery via Rollback and Rollforward
- Additional DBA Responsibilities
- The Access Workbench Section 6-Database Administration in Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Key Terms
- Access Workbench Exercises
- Marcia's Dry Cleaning Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions (See Online Appendix D)
- The Queen Anne Curiosity Shop Project Questions
- Chapter 7: Database Processing in Applications
- The Database Processing Environment
- Queries, Forms, and Reports
- Client/Server and Traditional Application Processing
- SQL/PSM: User-Defined Functions, Stored Procedures, and Triggers
- Web Application Database Processing
- ODBC
- Web Processing with the Microsoft IIS
- Getting Started with HTML Web Pages
- The index.html Web Page
- Creating the index.html Web Page
- Web Database Processing Using PHP
- Updating a Table with PHP
- Challenges for Web Database Processing
- SQL Injection Attacks
- Database Processing and XML
- The Importance of XML
- XML as a Markup Language
- XML and Database Processing
- XML Web Services
- The Access Workbench Section 7-Web Database Processing Using Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Exercises
- Marcia's Dry Cleaning Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions (See Online Appendix D)
- The Queen Anne Curiosity Shop Project Questions
- Chapter 8: Big Data, Data Warehouses, and Business Intelligence Systems
- Business Intelligence Systems
- The Relationship Between Operational and BI Systems
- Reporting Systems and Data Mining Applications
- Reporting Systems
- Data Mining Applications
- Data Warehouses and Data Marts
- The Components of a Data Warehouse
- Data Warehouses Versus Data Marts
- Dimensional Databases
- OLAP
- Distributed Database Processing
- Types of Distributed Databases
- Challenges of Distributed Databases
- Object-Relational Databases
- Big Data and the Not Only SQL Movement
- Column Family Databases
- MapReduce
- Hadoop
- The Access Workbench Section 8-Business Intelligence Systems Using Microsoft Access
- Summary
- Key Terms
- Review Questions
- Exercises
- Access Workbench Exercises
- Marcia's Dry Cleaning Case Questions
- Garden Glory Project Questions
- James River Jewelry Project Questions
- The Queen Anne Curiosity Shop Project Questions
- Online Appendices
- Glossary
- Index
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.