Beginning Database Design Solutions (Google eBook)

Front Cover
John Wiley & Sons, Dec 30, 2010 - Computers - 400 pages
3 Reviews
The vast majority of software applications use relational databases that virtually every application developer must work†with. This book introduces you to database design, whether you're a DBA or database developer. You'll discover what databases are, their goals, and why proper design is necessary to achieve those goals. Additionally, you'll master how to structure the database so it gives good performance while minimizing the chance for error. You will learn how to decide what should be in a database to meet the application's requirements.
  

What people are saying - Write a review

Review: Beginning Database Design Solutions

User Review  - Hosein - Goodreads

I learned so much from it especially from the first half of the book It is essential for a student who wants to work with databases to read such a book. I skimmed the second half because I didn't really feel like needing it. It has a real work case study which helps you understand the book. Read full review

Review: Beginning Database Design Solutions

User Review  - Terri Jones - Goodreads

Database Concepts course Read full review

Contents

Database Types
23
Spreadsheets
30
Network
40
Exercises
47
Database Design Process and Techniques
63
Security
68
Study Current Operations
74
Write the Requirements Document
80
A Detailed Case Study
225
Determining Security Needs
236
Write the Requirements Document
242
Extracting Business Rules
263
Normalization and Refinement
273
Implementing Databases
285
MySQL
313
Using MySQL Workbench
330

Exercises
86
Extracting Business Rules
121
Normalizing Data
137
Designing Databases to Support Software Applications
173
Common Design Patterns
185
Common Design Pitfalls
207
Advanced Topics
343
Building Databases with SQL Scripts
369
Database Maintenance
379
Database Security
389
Exercise Solutions
403
Sample Database Designs
467

Common terms and phrases

About the author (2010)

In a previous incarnation, Rod Stephens was a mathematician. During his stint at MIT, he discovered the joys of algorithms and graphics, and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications spanning such topics as repair dispatch, telephone switch programming, tax processing, and training for professional football players. Rod has written more than a dozen books that have been translated into half a dozen different languages, and more than 200 magazine articles covering Visual Basic, Visual Basic for Applications, Delphi, and Java. He is a columnist for Hardcore Visual Basic. Rod's popular website, VB Helper ( http: //www.vb-helper.com) receives several million hits per month and contains more than a thousand pages of tips, tricks, and example code for Visual Basic programmers.

Bibliographic information