Database, Sixth Edition

Design, Application Development, and Administration

by Mannino

ISBN: 978-0-9833324-2-8 | Copyright 2015

Tabs

This textbook provides a foundation to understand database technology supporting enterprise computing concerns such as those faced by Paul Hong. As a new student of database management, you first need to understand the fundamental concepts of database management and the relational data model. Then you need to master skills in database design and database application development. This textbook provides tools to help you understand relational databases and acquire skills to solve basic and advanced problems in query formulation, data modeling, normalization, application data requirements, and customization of database applications.

After establishing these skills, you are ready to study the organizational context, role of database specialists, and the processing environments in which databases are used. Students will learn about decision making needs, accountability requirements, organization structures, and roles of database specialists associated with databases and database technology. For environments, this textbook presents the fundamental database technologies in each processing environment and relates these technologies to new advances in electronic commerce and enterprise computing. You will learn the vocabulary, architectures, and design issues of database technology that provide a background for advanced study of individual database management systems, electronic commerce applications, and enterprise computing.

Expand/Collapse All
Cover (pg. i)
Table of Contents (pg. iii)
Preface (pg. xix)
Part 1: Introduction to Database Environments (pg. xxviii)
Chapter 1: Introduction to Database Management (pg. 1)
Chapter 2: Introduction to Database Development (pg. 23)
Part 2: Understanding Relational Databases (pg. 40)
Chapter 3: Introduction to Database Development (pg. 41)
Chapter 4: Query Formulation with SQL (pg. 77)
Part 3: Data Modeling (pg. 130)
Chapter 5: Understanding Entity Relationship Diagrams (pg. 131)
Chapter 6: Developing Data Models for Business Databases (pg. 163)
Part 4: Relational Database Design (pg. 218)
Chapter 7: Normalization of Relational Tables (pg. 219)
Chapter 8: Physical Database Design (pg. 249)
Part 5: Application Development with Relational Databases (pg. 300)
Chapter 9: Advanced Query Formulation with SQL (pg. 301)
Chapter 10: Application Development with Views (pg. 353)
Chapter 11: Stored Procedurs and Triggers (pg. 389)
Part 6: Advanced Database Development (pg. 446)
Chapter 12: View Design and Integration (pg. 447)
Chapter 13: Database Development for Student Loan Limited (pg. 467)
Part 7: Managing Database Environments (pg. 494)
Chapter 14: Data and Database Administration (pg. 495)
Chapter 15: Transaction Management (pg. 533)
Chapter 16: Data Warehouse Concepts and Design (pg. 575)
Chapter 17: Data Integration Practices and Relational DBMS Extensions for Data Warehouses (pg. 613)
Chapter 18: Client-Server Processing, Parallel Database Processing, and Distributed Databases (pg. 653)
Chapter 19: Object Database Management Systems (pg. 693)
Glossary (pg. 730)
Index (pg. 757)