Database Processing: Fundamentals, Design, and Implementation, Global Edition
5.490 kr.
Lýsing:
For undergraduate database management courses. Get Students Straight to the Point of Database Processing Database Processing: Fundamentals, Design, and Implementation reflects a new teaching and professional workplace environment and method that gets students straight to the point with its thorough and modern presentation of database processing fundamentals. The full text downloaded to your computer With eBooks you can: search for key concepts, words and phrases make highlights and notes as you study share your notes with friends eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.
Annað
- Höfundar: David M. Kroenke, David J. Auer
- Útgáfa:14
- Útgáfudagur: 2016-02-23
- Blaðsíður: 640
- Hægt að prenta út 2 bls.
- Hægt að afrita 2 bls.
- Format:Page Fidelity
- ISBN 13: 9781292107646
- Print ISBN: 9781292107639
- ISBN 10: 1292107642
Efnisyfirlit
- Title Page
- Copyright Page
- Supplements
- Acknowledgments
- About the Authors
- Contents
- Preface
- Part 1 Getting Started
- Chapter 1: Introduction
- Chapter Objectives
- The Importance of Databases in the Internet and Smartphone World
- The Characteristics of Databases
- A Note on Naming Conventions
- A Database Has Data and Relationships
- Databases Create Information
- Database Examples
- Single-User Database Applications
- Multiuser Database Applications
- E-Commerce Database Applications
- Reporting and Data Mining Database Applications
- The Components of a Database System
- Database Applications and SQL
- The DBMS
- The Database
- Personal Versus Enterprise-Class Database Systems
- What Is Microsoft Access?
- What Is an Enterprise-Class Database System?
- Database Design
- Database Design from Existing Data
- Database Design for New Systems Development
- Database Redesign
- What You Need to Learn
- A Brief History of Database Processing
- The Early Years
- The Emergence and Dominance of the Relational Model
- Post-Relational Developments
- Summary
- Key Terms
- Review Questions
- Project Questions
- Chapter 2: Introduction to Structured Query Language
- Chapter Objectives
- Cape Codd Outdoor Sports
- Business Intelligence Systems and Data Warehouses
- The Cape Codd Outdoor Sports Extracted Retail Sales Data
- RETAIL_ORDER Data
- ORDER_ITEM Data
- SKU_DATA Table
- CATALOG_SKU_20## Tables
- The Complete Cape Codd Data Extract Schema
- Data Extracts Are Common
- SQL Background
- The SQL SELECT/FROM/WHERE Framework
- Reading Specified Columns from a Single Table
- Specifying Column Order in SQL Queries from a Single Table
- Submitting SQL Statements to the DBMS
- Using SQL in Microsoft Access 2013
- Using SQL in Microsoft SQL Server 2014
- Using SQL in Oracle Database
- Using SQL in Oracle MySQL 5.6
- SQL Enhancements for Querying a Single Table
- Reading Specified Rows from a Single Table
- Reading Specified Columns and Rows from a Single Table
- Sorting the SQL Query Results
- SQL WHERE Clause Options
- Performing Calculations in SQL Queries
- Using SQL Built-in Aggregate Functions
- SQL Expressions in SQL SELECT Statements
- Grouping Rows in SQL SELECT Statements
- Querying Two or More Tables with SQL
- Querying Multiple Tables with Subqueries
- Querying Multiple Tables with Joins
- Comparing Subqueries and Joins
- The SQL JOIN ON Syntax
- Outer Joins
- Using SQL Set Operators
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 1: Introduction
- Chapter 3: The Relational Model and Normalization
- Chapter Objectives
- Relational Model Terminology
- Relations
- Characteristics of Relations
- Alternative Terminology
- To Key, or Not to Key—That Is the Question!
- Functional Dependencies
- Finding Functional Dependencies
- Keys
- Normal Forms
- Modification Anomalies
- A Short History of Normal Forms
- Normalization Categories
- From First Normal Form to Boyce-Codd Normal Form Step by Step
- Eliminating Anomalies from Functional Dependencies with BCNF
- Eliminating Anomalies from Multivalued Dependencies
- Fifth Normal Form
- Domain/Key Normal Form
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 4: Database Design Using Normalization
- Chapter Objectives
- Assess Table Structure
- Designing Updatable Databases
- Advantages and Disadvantages of Normalization
- Functional Dependencies
- Normalizing with SQL
- Choosing Not to Use BCNF
- Multivalued Dependencies
- Designing Read-Only Databases
- Denormalization
- Customized Duplicated Tables
- Common Design Problems
- The Multivalue, Multicolumn Problem
- Inconsistent Values
- Missing Values
- The General-Purpose Remarks Column
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 5: Data Modeling with the Entity-Relationship Model
- Chapter Objectives
- The Purpose of a Data Model
- The Entity-Relationship Model
- Entities
- Attributes
- Identifiers
- Relationships
- Maximum Cardinality
- Minimum Cardinality
- Entity-Relationship Diagrams and Their Versions
- Variations of the E-R Model
- E-R Diagrams Using the IE Crow’s Foot Model
- Strong Entities and Weak Entities
- ID-Dependent Entities
- Non-ID-Dependent Weak Entities
- The Ambiguity of the Weak Entity
- Subtype Entities
- Patterns in Forms, Reports, and E-R Models
- Strong Entity Patterns
- ID-Dependent Relationships
- Mixed Identifying and Nonidentifying Patterns
- The For-Use-By Pattern
- Recursive Patterns
- The Data Modeling Process
- The College Report
- The Department Report
- The Department/Major Report
- The Student Acceptance Letter
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 6: Transforming Data Models into Database Designs
- Chapter Objectives
- The Purpose of a Database Design
- Create a Table for Each Entity
- Selecting the Primary Key
- Specifying Alternate Keys
- Specifying Column Properties
- Verify Normalization
- Create Relationships
- Relationships Between Strong Entities
- Relationships Using ID-Dependent Entities
- Relationships with a Weak Non-ID-Dependent Entity
- Relationships in Mixed Entity Designs
- Relationships Between Supertype and Subtype Entities
- Recursive Relationships
- Representing Ternary and Higher-Order Relationships
- Relational Representation of the Highline University Data Model
- Design for Minimum Cardinality
- Actions when the Parent Is Required
- Actions when the Child Is Required
- Implementing Actions for M-O Relationships
- Implementing Actions for O-M Relationships
- Implementing Actions for M-M Relationships
- Designing Special Case M-M Relationships
- Documenting the Minimum Cardinality Design
- An Additional Complication
- Summary of Minimum Cardinality Design
- The View Ridge Gallery Database
- View Ridge Gallery Database Summary of Requirements
- The View Ridge Data Model
- Database Design with Data Keys
- Minimum Cardinality Enforcement for Required Parents
- Minimum Cardinality Enforcement for the Required Child
- Column Properties for the View Ridge Database Design Tables
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 7: SQL for Database Construction and Application Processing
- Chapter Objectives
- The Importance of Working with an Installed DBMS Product
- The View Ridge Gallery Database
- SQL DDL and DML
- Managing Table Structure with SQL DDL
- Creating the VRG Database
- Using SQL Scripts
- Using the SQL CREATE TABLE Statement
- Variations in SQL Data Types and SQL/PSM
- Creating the VRG Database ARTIST Table
- Creating the VRG Database WORK Table and the 1:N ARTIST-to-WORK Relationship
- Implementing Required Parent Rows
- Implementing 1:1 Relationships
- Casual Relationships
- Creating Default Values and Data-Constraints with SQL
- Creating the VRG Database Tables
- The SQL ALTER TABLE Statement
- The SQL DROP TABLE Statement
- The SQL TRUNCATE TABLE Statement
- The SQL CREATE INDEX Statement
- SQL DML Statements
- The SQL INSERT Statement
- Populating the VRG Database Tables
- The SQL UPDATE Statement
- The SQL MERGE Statement
- The SQL DELETE Statement
- Using SQL Views
- Using SQL Views to Hide Columns and Rows
- Using SQL Views to Display Results of Computed Columns
- Using SQL Views to Hide Complicated SQL Syntax
- Layering Built-in Functions
- Using SQL Views for Isolation, Multiple Permissions, and Multiple Triggers
- Updating SQL Views
- Embedding SQL in Program Code
- SQL/Persistent Stored Modules (SQL/PSM)
- Using SQL User-Defined Functions
- Using SQL Triggers
- Using Stored Procedures
- Comparing User-Defined Functions, Triggers, and Stored Procedures
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 8: Database Redesign
- Chapter Objectives
- The Need for Database Redesign
- SQL Statements for Checking Functional Dependencies
- What Is a Correlated Subquery
- How Do I Analyze an Existing Database
- Reverse Engineering
- Dependency Graphs
- Database Backup and Test Databases
- Changing Table Names and Table Columns
- Changing Table Names
- Adding and Dropping Columns
- Changing a Column Data Type or Column Constraints
- Adding and Dropping Constraints
- Changing Relationship Cardinalities
- Changing Minimum Cardinalities
- Changing Maximum Cardinalities
- Adding and Deleting Tables and Relationships
- Forward Engineering
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 9: Managing Multiuser Databases
- Chapter Objectives
- The Importance of Working with an Installed DBMS Product
- Database Administration
- Managing the Database Structure
- Concurrency Control
- The Need for Atomic Transactions
- Resource Locking
- Optimistic Versus Pessimistic Locking
- SQL Transaction Control Language and Declaring Lock Characteristics
- Implicit and Explicit COMMIT TRANSACTION
- Consistent Transactions
- Transaction Isolation Level
- SQL Cursors
- Database Security
- Processing Rights and Responsibilities
- DBMS Security
- DBMS Security Guidelines
- Application Security
- The SQL Injection Attack
- Database Backup and Recovery
- Recovery via Reprocessing
- Recovery via Rollback/Rollforward
- Managing the DBMS
- Maintaining the Data Repository
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 10: Managing Databases with Microsoft SQL Server 2014, Oracle Database, and MySQL 5.6
- Chapter Objectives
- Installing the DBMS
- Using the DBMS Database Administration and Database Development Utilities
- Creating a Database
- Creating and Running SQL Scripts
- Reviewing the Database Structure in the DBMS GUI Utility
- Creating and Populating the View Ridge Gallery VRG Database Tables
- Creating SQL Views for the View Ridge Gallery VRG Database
- Database Application Logic and SQL/Persistent Stored Modules (SQL/PSM)
- DBMS Concurrency Control
- DBMS Security
- DBMS Database Backup and Recovery
- Other DBMS Topics Not Discussed
- Choose Your DBMS Product(s)!
- Summary
- Key Terms
- Project Questions
- Chapter 11: The Web Server Environment
- Chapter Objectives
- A Web Database Application for the View Ridge Gallery
- The Web Database Processing Environment
- Database Server Access Standards
- The ODBC Standard
- ODBC Architecture
- Conformance Levels
- Creating an ODBC Data Source Name
- The Microsoft.NET Framework and ADO.NET
- OLE DB
- ADO and ADO.NET
- The ADO.NET Object Model
- The Java Platform
- JDBC
- Java Server Pages (JSP) and Servlets
- Apache Tomcat
- Web Database Processing with PHP
- Web Database Processing with PHP and the NetBeans IDE
- Getting Started with HTML Web Pages
- The index.html Web Page
- Creating the index.html Web Page
- Using PHP
- Web Page Examples with PHP
- Example 1: Updating a Table
- Example 2: Using PHP Data Objects (PDO)
- Example 3: Invoking a Stored Procedure
- Challenges for Web Database Processing
- SQL Injection Attacks
- Extensible Markup Language (XML)
- The Importance of XML
- XML as a Markup Language
- Creating XML Documents from Database Data
- Using the SQL SELECT . . . FOR XML Statement
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- Chapter 12: Big Data, Data Warehouses, and Business Intelligence Systems
- Chapter Objectives
- 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
- Components of a Data Warehouse
- Data Warehouses Versus Data Marts
- Dimensional Databases
- Reporting Systems
- RFM Analysis
- OLAP
- Data Mining
- Distributed Database Processing
- Types of Distributed Databases
- Challenges of Distributed Databases
- Object-Relational Databases
- Virtualization
- Cloud Computing
- Big Data and the Not Only SQL Movement
- Column Family Databases
- MapReduce
- Hadoop
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 9649
- Útgáfuár : 2016
- Leyfi : 380