Database Development and Management (Foundations of Database Design)

Introduction to Database Systems Functions of a DatabaseDatabase Management SystemDatabase ComponentsDatabase Development ProcessConceptual Design and Data Modeling Introduction to Database Design Process Understanding Business ProcessEntity-Relationship Data Model Representing Business Process with Entity-RelationshipModelTable Structure and NormalizationIntroduction to TablesTable NormalizationTransforming Data Models to Relational Databases .DBMS Selection Transforming Data Models to Relational DatabasesEnforcing ConstraintsCreating Database for Business ProcessPhysical Design and Database Implementation with SQLPhysical DesignCreating, Controlling, and Modifying DatabaseObjects with SQLTransporting Database Data Querying Databases Retrieving Data from TablesSQL Procedures SQL Programming ExtensionProcedures and Functions TriggersDebugging SQL ProceduresDatabase Views, Indexes, and Cursors Creating and Managing ViewsCreating and Managing Indexes Creating and Managing CursorsCase Study: Hillcrest ComputingAccessing Data Database Accessing Open Database Connectivity (ODBC)Object Linking and Embedding Database (OLE DB)Active Data Object (ADO)Database Application DevelopmentUnderstanding Business ProcessUser Interface Design and FormatCreating FormsCreating ReportsNetwork Databases Client/Server ComputingIntroduction to Extensible Markup Language (XML) Developing Database Applicationswith Visual Studio .NETXML Web Services and InfoPathDatabase AdministrationManaging Database User Accounts and Security Backing Up and Recovering Databases Database Replication Database Maintenance PlanData Analysis ServicesData WarehouseOnLine Analytical Processing (OLAP)Data Mining Data-Mining ProcessData-Mining Algorithms Developing Data-Mining Models in SQL ServerAPPENDICESAppendix A: Sample DatabasesStudent_Club Database Hillcrest Computing Database Appendix B

Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications.

Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well as data analysis for business intelligence. This self-contained text gives students hands-on projects required for professionally developing and managing databases. It provides detailed instruction via an easy-to-follow, step-by-step case-based approach.

Following an introduction to database components, the book uses case studies to illustrate the modeling process, covers table structures and normalization, and analyzes the transformation of a data model to a relational database. It explains the use of SQL in managing database objects and in querying databases, then discusses Transact-SQL and the views, indexes, and cursors that bridge databases and their applications.

The book examines three major data-accessing techniques, and then shows how to develop sophisticated applications based upon the material included in previous chapters. It explores the use of databases in network environments, and details the multiple tasks handled by database administrators (DBAs).

The text also discusses the OnLine Analytical Processing (OLAP) system, data warehousing, and other analysis tools that support business intelligence and decision making. It concludes with a review of data mining.

Database Development and Management explains all aspects of database design, access, implementation, application development, and management, as well as data analysis for business intelligence. This self-contained text gives students hands-on projects required for professionally developing and managing databases. It provides detailed instruction via an easy-to-follow, step-by-step, case-based approach.Following an introduction to database components, the book uses case studies to illustrate the modeling process, covers table structures and normalization, and analyzes the transformation of a data model to a relational database. It explains the use of SQL in managing database objects and in querying databases, then discusses Transact - SQL and the views, indexes, and cursors that bridge databases and their applications.The book examines three major data-accessing techniques, and then shows how to develop sophisticated applications based upon the material included in previous chapters. It explores the use of databases in network environments, and details the multiple tasks handled by database administrators (DBAs).The text also discusses OnLine Analytical Processing (OLAP), data warehousing, and other analysis tools that support business intelligence and decision making. It concludes with a review of data mining. Title 3 Copyright 4 Contents 5 Preface 16 Acknowledgments 23 Introduction to Database Systems 24 Conceptual Design and Data Modeling 40 Table Structure and Normalization 80 Transforming Data Modelsto Relational Databases 110 Physical Design and Database Implementationwith SQL 146 Querying Databases 182 SQL Procedures 208 Database Views, Indexes,and Cursors 244 Accessing Data 280 Database Application Development 310 Network Databases 362 Database Administration 434 Data Analysis Services 488 Data Mining 536 Appendix A Sample Databases 590 Appendix B Installation of SQL Server 608 Appendix C Suggested Resources 614 Пустая страница 607 Front Cover; Contents; Preface; Acknowledgments; Chapter 1: Introduction to Database Systems; Body; Chapter 2: Conceptual Design and Data Modeling; Chapter 3: Table Structure and Normalization; Chapter 4: Transforming Data Models to Relational Databases; Chapter 5: Physical Design and Database Implementation with SQL; Chapter 6: Querying Databases; Chapter 7: SQL Procedures; Chapter 8: Database Views, Indexes, and Cursors; Chapter 9: Accessing Data; Chapter 10: Database Application Development; Chapter 11: Network Databases; Chapter 12: Database Administration This is a comprehensive and self-contained text that provides instruction suitable for self-study. With a focus on Microsoft database technology, it examines both the theory and the hands-on practice of database management