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
 

Selected pages

Contents

Part 1 Approaching Relational Database Modeling
1
Part 2 Designing Relational Database Models
71
Part 3 A Case Study in Relational Database Modeling
215
Part 4 Advanced Topics
381
Glossary
403
Appendix A Exercise Answers
421
Appendix B Sample Databases
435
Index
445

Common terms and phrases

address_line_2 allow analysis application AUTHOR_ID BAND band_id FK BCNF bids BTree business rules buyer buyer_id FK candidate key category_id chapter CHAR VARYING 32 CHECK constraints child table clause commands comment_date contain CREATE INDEX CREATE TABLE currency customer_id data warehouse database database engines database model design datatypes Del Rey Books denormalization dependent dimensions employee end-users exchange_rate fact table FOREIGN KEY REFERENCES FORMAT GENRE genre_id instrument_id INTEGER FOREIGN KEY INTEGER PRIMARY KEY ISBN James Blish join key field KEY NOT NULL Larry Niven listing_days location_id materialized views multiple MUSICIAN musician_id Normal Form object database OLTP database model one-to-many relationship online auction house parent table parent_id performance primary and foreign PUBLISHER publisher_id query records referential integrity relational database model return_policy secondary_id seller_id FK shown in Figure SMALLINT snowflake schema star schema STRING subject_id surrogate keys table structure time_id types unique users warehouse database model

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

TitleBeginning Database Design
Programmer to programmer
Wrox beginning guides
AuthorGavin Powell
Editionillustrated
PublisherJohn Wiley & Sons, 2006
ISBN0764574906, 9780764574900
Length467 pages
Subjects ›  › 

Computers / Data Science / Data Modeling & Design
Computers / Database Administration & Management
Computers / Desktop Applications / General
Computers / Information Technology
Computers / Languages / SQL
Computers / System Administration / Storage & Retrieval
  
Export CitationBiBTeX EndNote RefMan