The Database Design Resource Center



Easy-to-navigate sitemap

To help you to find the information you seek, I have added this graphical sitemap.

DATABASEDESIGN-RESOURCE.COM SITEMAP Atomic database values Atomic database values Formal definitions Formal definitions Object-Oriented programming and and Relational Databases Object-Oriented programming and and Relational Databases Oracle constraints and indexing Oracle constraints and indexing http://www.databasedesign-resource.com/oracle-import.html http://www.databasedesign-resource.com/oracle-import.html Software http:\www.databasedesign-resource.com\database-software-products.html Software http:\www.databasedesign-resource.com\database-software-products.html Analysis Progress Analysis Progress Business rules Business rules http://www.databasedesign-resource.com/redefining-oracle-objects.html http://www.databasedesign-resource.com/redefining-oracle-objects.html http://www.databasedesign-resource.com/project-management-failure.html http://www.databasedesign-resource.com/project-management-failure.html Hardcopy Books Hardcopy Books SQL programming basics SQL programming basics Analysis phase Analysis phase Database jobs options Database jobs options http://www.databasedesign-resource.com/work-breakdown-structure.html http://www.databasedesign-resource.com/work-breakdown-structure.html Setting up a maintenance plan Setting up a maintenance plan SQL Server database SQL Server database Database & Application Architecture Database & Application Architecture Scheduling periodic jobs Scheduling periodic jobs SQL Server Transaction log SQL Server Transaction log Entity Relationship Modeling - Principles Entity Relationship Modeling - Principles The Database Analysis Team The Database Analysis Team Primary/Foreign Key issues & more Primary/Foreign Key issues & more Unique constraints Unique constraints Database Design Workshop Database Design Workshop Constraint naming standard Constraint naming standard http://www.databasedesign-resource.com/pert-charts.html http://www.databasedesign-resource.com/pert-charts.html Constraints on views Constraints on views Theory and Practice section Theory and Practice section Import and export data Import and export data Denormalization and performance Denormalization and performance http://www.databasedesign-resource.com/managing-software-projects.html http://www.databasedesign-resource.com/managing-software-projects.html http://www.databasedesign-resource.com/oracle-partitions.html http://www.databasedesign-resource.com/oracle-partitions.html Database Glossary Database Glossary Adding users in a SQL Server database Adding users in a SQL Server database http://blogs.ittoolbox.com/database/design/ http://blogs.ittoolbox.com/database/design/ Oracle constraints defined Oracle constraints defined Managing indexes in the database Managing indexes in the database http://www.softwareprojects.org/ http://www.softwareprojects.org/ Analysis Trap 1 - Incomplete modeling Analysis Trap 1 - Incomplete modeling Database Normalization Database Normalization Moving the database (Detach and attach) Moving the database (Detach and attach) Creating an Oracle ref cursor Creating an Oracle ref cursor Newsletter subscription Newsletter subscription http://www.databasedesign-resource.com/software-project-management.html http://www.databasedesign-resource.com/software-project-management.html http://www.databasedesign-resource.com/oracle-backup.html http://www.databasedesign-resource.com/oracle-backup.html Foreign key constraints Foreign key constraints http://www.databasedesign-resource.com/oracle-scheduler.html http://www.databasedesign-resource.com/oracle-scheduler.html Candidate Keys Candidate Keys eBook Affiliate Program eBook Affiliate Program SQL Server Client tier SQL Server Client tier Disabling constraints Disabling constraints http://www.databasedesign-resource.com/gantt-charts.html http://www.databasedesign-resource.com/gantt-charts.html Using an Oracle ref cursor from Java Using an Oracle ref cursor from Java http://www.databasedesign-resource.com/project-time-tracking.html http://www.databasedesign-resource.com/project-time-tracking.html SQL Server Profiler SQL Server Profiler CASE Tools CASE Tools http://www.databasedesign-resource.com/users-in-oracle.html http://www.databasedesign-resource.com/users-in-oracle.html Referential Integrity Referential Integrity Flat tables : And the Earth is flat... Flat tables : And the Earth is flat... Testimonials Testimonials http://www.databasedesign-resource.com/collaborative-project-management.html http://www.databasedesign-resource.com/collaborative-project-management.html Common tasks faced by SQL Server DBAs Common tasks faced by SQL Server DBAs Your own business opportunity Your own business opportunity http://www.databasedesign-resource.com/oracle-export.html http://www.databasedesign-resource.com/oracle-export.html http://www.accessdatabasetips.com/ http://www.accessdatabasetips.com/ NULL values and problems NULL values and problems SQL Server Business layer SQL Server Business layer Database Primary (& other) keys Database Primary (& other) keys Database Design Home Database Design Home Oracle database constraints Oracle database constraints Programming tips & Resources Programming tips & Resources Restore the database from backup Restore the database from backup http://www.databasedesign-resource.com/oracle-recovery.html http://www.databasedesign-resource.com/oracle-recovery.html IT Project Management IT Project Management Analyst ethics Analyst ethics Perform a database backup Perform a database backup Generic or specific modeling Generic or specific modeling Objects vs. relational tables Objects vs. relational tables Database Reporting Database Reporting The Universe - A modeling game The Universe - A modeling game Enabling and disabling links Enabling and disabling links http://www.databasedesign-resource.com/multidimensional-project-management.html http://www.databasedesign-resource.com/multidimensional-project-management.html http://www.databasedesign-resource.com/oracle-log-files.html http://www.databasedesign-resource.com/oracle-log-files.html Compare SQL Server databases Compare SQL Server databases http://www.databasedesign-resource.com/oracle-dba.html http://www.databasedesign-resource.com/oracle-dba.html Deferred integrity constraints Deferred integrity constraints Influence the content of this site! Influence the content of this site! http://www.databasedesign-resource.com/agile-project-management.html http://www.databasedesign-resource.com/agile-project-management.html http://www.databasedesign-resource.com/project-management-success.html http://www.databasedesign-resource.com/project-management-success.html Analysis Trap 2 : Incomplete business understanding Analysis Trap 2 : Incomplete business understanding http://www.customerservicepoint.com/ http://www.customerservicepoint.com/ User-defined types User-defined types http://www.databasedesign-resource.com/oracle-indexes.html http://www.databasedesign-resource.com/oracle-indexes.html Normalization Normalization Contact me Contact me eBooks eBooks

Return to Database Design home

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant


Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:


What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials



Database Normalization eBook:


Database Normalization eBook




Copyright © www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.