Hands-on Database: An Introduction to Database Design and Development

Pearsоn Education, Prеntісе Hаll, 2012. - 214 p. - ISBN: 013610827Х, 9780136108276.This book shows readers how to build a database by providing them with the context of a running case throughout each step of the process.

The book focuses on the process of creating a database. It guides the students through the initial conception of the database. It covers gathering of requirements and business rules, the logical and physical design, and the testing of the database.Contents:

Preface

Acknowledgments

About the Author

Who Needs a Database

Overview of Relational Databases and Their Uses

The Situation

The Opportunity

Getting the Scope

The First Interview

Identifying the Big Topics

Writing the Statement of Work

Reviewing the Statement of Work

The Statement of Work

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

Gathering Information

Interviews, Observations, and Reviewing Documents

Looking at the Documents

Preparing for the Interview

The Interview

The Questionnaire

Tutors at Work

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

Suggestions for Scenarios

Requirements and Business Rules

Getting Started

Review of the Issues

Requirements

Business Rules

Review of Requirements and Business Rules with Terry

A Little Bit of Grammar

Entities and Attributes

Candidate Keys

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

Databas Design

Entity Relation Diagrams

Designing the Database

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

Normalization and Design Review

The Design Review

Final Content Review

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

Suggestions for Scenarios

Physical Design

Choosing the Management System

Creating the Database

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

SQL

Running Queries

Testing the Database

Joins

Inserts, Updates, and Deletes

Creating a Trigger

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

Is It Secure?

The Issue

Where to Start

Analyzing Security Needs

Threats

Finding Solutions

Documentation

Things We Have Done

Vocabulary

Things to Look Up

Practices

Scenarios

Appendix A: Using Microsoft Access with the Book

Appendix B: SQL Server Express

Appendix C: Visio

Appendix D: Common Relational Patterns

Glossary

Index with TOC BookMarkLinks