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
