Beginning Database Design

Front Cover
John Wiley & Sons, 2006 - Computers - 467 pages
  • The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
  • Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle
  • Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
  • Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Approaching Relational Database Modeling
1
Database Modeling in the Workplace
23
Database Modeling Building Blocks
35
Designing Relational Database Models
71
3rd Normal Form 3NF
96
Beyond 3rd Normal Form 3NF
103
Reading and Writing Data with SQL
123
Advanced Relational Database Modeling
151
A Case Study in Relational Database Modeling
215
Creating and Refining Tables During the Design Phase
259
Filling in the Details with a Detailed Design
319
Business Rules and Field Settings
353
Advanced Topics
381
Glossary
403
Exercise Answers
421
Sample Databases
435

Understanding Data Warehouse Database Modeling
171
Building FastPerforming Database Models
193

Common terms and phrases

About the author (2006)

Gavin Powell has a Bachelor of Science degree in Computer Science, with numerous professional accreditations and skills (including Microsoft Word, PowerPoint, Excel, Windows 2000, ERWin, and Paintshop, as well as Microsoft Access, Ingres, and Oracle relational databases, plus a multitude of application development languages). He has almost 20 years of contracting, consulting, and hands-on educating experience in both software development and database administration roles. He has worked with all sorts of tools and languages, on various platforms over the years. He has lived, studied, and worked on three different continents, and is now scratching out a living as a writer, musician, and family man. He can be contacted at oracledbaexpert@earthlink.net or info@oracledbaexpert.com. His Web site at http: //www.oracledbaexpert.com offers information on database modeling, database software, and many development languages. Other titles by this author include Oracle Data Warehouse Tuning for 10g (Burlington, MA: Digital Press, 2005), Oracle 9i: SQL Exam Cram 2 (1Z0-007) (Indianapolis: Que, 2004), Oracle SQL: Jumpstart with Examples (Burlington, MA: Digital Press, 2004), Oracle Performance Tuning for 9i and 10g (Burlington, MA: Digital Press, 2003), ASP Scripting (Stephens City, VA: Virtual Training Company, 2005), Oracle Performance Tuning (Stephens City, VA: Virtual Training Company, 2004), Oracle Database Administration Fundamentals II (Stephens City, VA: Virtual Training Company, 2004), Oracle Database Administration Fundamentals I (Stephens City, VA: Virtual Training Company, 2003), and Introduction to Oracle 9i and Beyond: SQL & PL/SQL (Stephens City, VA: Virtual Training Company, 2003).

Bibliographic information