Database processing : fundamentals, design, and implementation / / David M. Kroenke, David Auer

• Autore: Kroenke David M. <1946->
• Pubblicazione: Boston : , : Pearson, , [2016]; ©2016
• Edizione: Fourteenth, global edition.
• Descrizione fisica: 1 online resource (637 pages) : color illustrations, graphs
• Disciplina: 005.7565
• Soggetto topico: Database management
• Persona (resp. second.): AuerDavid J.
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: Cover -- 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 -- Part 2 Database Design -- 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 -- Part 3 Database Implementation -- 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 -- Part 4 Multiuser Database Processing -- Chapter 9: Managing Multiuser Databases -- Chapter Objectives -- The Importance of Working with an Installed DBMS Product. ; Database Administration.
• Sommario/riassunto: 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 Fourteenth Edition has been thoroughly updated to reflect the latest software.
• Titolo autorizzato: Database processing
• ISBN: 1-292-10764-2
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910154762203321
• Lo trovi qui: Univ. Federico II