9780131986251

Database Concepts

by ;
  • ISBN13:

    9780131986251

  • ISBN10:

    0131986252

  • Edition: 3rd
  • Format: Paperback
  • Copyright: 1/1/2008
  • Publisher: Prentice Hall
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $78.67

Summary

Written by one of the world's leading database authorities,Database Concepts 3e, introduces the essential concepts students need to create and use small databases. Appropriate for all introductory courses or brief courses on database development and management, as well as database courses designed around specific database products such as Microsoft Access, SQL Server, or MySQL.

Table of Contents

Fundamentals
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
The Relational Model
Relations. Types of Keys. The Problem of Null Values. Functional Dependencies and Normalization. The Access Workbench II
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 Modificaiton and Deletion. SQL Views. The Access Workbench III
Database Design and Management
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
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
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
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
Getting Started with Microsoft SQL Server 2005 Express Edition
Getting Started with MySQL
SQL Views
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review