gogo
Amazon cover image
Image from Amazon.com

Database concepts.

By: Contributor(s): Material type: TextTextPublication details: Upper Saddle River, N.J. : Pearson Prentice Hall, c2008.Edition: 3rd ed. / David M. Kroenke, David J. AuerDescription: xvii, 426 p. : col. ill. ; 28 cmISBN:
  • 9780131986251 (pbk.) :
  • 9780131986251
Subject(s): DDC classification:
  • 005.74 KRO
LOC classification:
  • QA76.9.D3 K736 2008
Contents:
Part I. Fundamentals 1. Getting Started Why Use a Database? Problems with Lists. Using Relational Database Tables. Processing the Relational Tables. What is a Database System? The Access Workbench I 2. The Relational Model Relations. Types of Keys. The Problem of Null Values. Functional Dependencies and Normalization. The Access Workbench II 3. Structured Query Language An Example Database. Does Not Work With MS Access SQL. SQL for Data Definition. SQL for Inserting Relational Data. SQL for Relational Query. SQL for Relational Data Modification and Deletion. SQL for Table and Constraint Modification and Deletion. SQL Views. The Access Workbench III Part II. Database Design and Management 4. Data Modeling and the Entity-Relationship Model The Requirements Stage. The Entity-Relationship Data Model. Entity-Relationship Diagrams. In-Dependent Entities. Recursive Relationships. Developing an Example E-R Diagram. The Access Workbench IV 5. Database Design Transforming a Data Model into a Database Design. Representing Entities with the Relational Model. Representing Relationships. Database Design at Heather Sweeney Designs. The Access Workbench V 6. Advanced Topics The Heather Sweeney Design Database. The Need for Control, Security, and Reliability. Concurrency Control. Database Security. Database Backup and Recovery. Additional DBA Responsibilities. Distributed Database Processing. Object-Relational Databases. The Access Workbench VI 7. Database Administration The Database Processing Environment. Queries, Forms, and Reports. Client/Server and Traditional Applicaiton Processing. Stored Procedures and Triggers. Web Database Processing. Database Processing and XML. Business Intelligence Systems. The Access Workbench VII Appendix A. Getting Started with Microsoft SQL Server 2005 Express Edition Appendix B. Getting Started with MySQL Appendix C. SQL Views Appendix D- Access 2007 Tutorial.
Holdings
Item type Current library Call number Copy number Status Date due Barcode
Long Loan TUS: Midlands, Main Library Athlone General Lending 005.74 KRO (Browse shelf(Opens below)) 1 Available 204469

Previous ed.: 2005.

Includes index.

Includes index.

Part I. Fundamentals 1. Getting Started Why Use a Database? Problems with Lists. Using Relational Database Tables. Processing the Relational Tables. What is a Database System? The Access Workbench I 2. The Relational Model Relations. Types of Keys. The Problem of Null Values. Functional Dependencies and Normalization. The Access Workbench II 3. Structured Query Language An Example Database. Does Not Work With MS Access SQL. SQL for Data Definition. SQL for Inserting Relational Data. SQL for Relational Query. SQL for Relational Data Modification and Deletion. SQL for Table and Constraint Modification and Deletion. SQL Views. The Access Workbench III Part II. Database Design and Management 4. Data Modeling and the Entity-Relationship Model The Requirements Stage. The Entity-Relationship Data Model. Entity-Relationship Diagrams. In-Dependent Entities. Recursive Relationships. Developing an Example E-R Diagram. The Access Workbench IV 5. Database Design Transforming a Data Model into a Database Design. Representing Entities with the Relational Model. Representing Relationships. Database Design at Heather Sweeney Designs. The Access Workbench V 6. Advanced Topics The Heather Sweeney Design Database. The Need for Control, Security, and Reliability. Concurrency Control. Database Security. Database Backup and Recovery. Additional DBA Responsibilities. Distributed Database Processing. Object-Relational Databases. The Access Workbench VI 7. Database Administration The Database Processing Environment. Queries, Forms, and Reports. Client/Server and Traditional Applicaiton Processing. Stored Procedures and Triggers. Web Database Processing. Database Processing and XML. Business Intelligence Systems. The Access Workbench VII Appendix A. Getting Started with Microsoft SQL Server 2005 Express Edition Appendix B. Getting Started with MySQL Appendix C. SQL Views Appendix D- Access 2007 Tutorial.

Powered by Koha