RelationalDBDesign RelationalDBDesign


Welcome to RelationalDBDesign!

This website discusses Normalization, Relational Database Design, SQL and Oracle Technology.


p(D)p(W | D) = p(D,W) = p(W)p(D |W)
p(W|D) =
p(W) p(D|W) / p(D)

Oracle SQL Tuning
High Water Mark PCTFree Optimal Performance Monitoring Tuning  
Object Oriented Database Abstract Data Type
Concatenated Indexes STAR Transformation Queries B-Tree Bitmapped Indexes Function Based Indexed

Advanced SQL
Characteristics of SQL PUBS Database explained Group By Clause Subquery Equals Clause

Basic SQL
SQL Approaches - Quiz SQL-92 Relational DB Analogy Three Normalization Levels
Customer Table Example Flatfile Database Relational vs Flatfile Normalization Example Table

Database Architecture
Oracle Describe Command Oracle Spool Command desc Oracle command Archive Log List Command
Checkpoint process (CKPT) (DBW0) Database Writer Instance vs. Database Oracle Large Pool

Managing Objects
Coalesce Tablespace Operating System Blocks Describing Columns View Oracle Extents
Oracle free Space Oracle Segment Role Oracle Storage Concepts Fragmented TableSpace
Alter extent size Table Oracle Dictionary Extents Describing Table Columns Data Dictionary Constraints

Network Topology
Transparent Network Substrate Database Local Autonomy Location Independence Distributed Fragmentation
Oracle Networked Computers Searching Oracle Topology Evolution Network Protocols sqlnet.ora Location

SQL Extensions
Union, Intersect, Minus Hierarchical Retrieval via Connect Advanced Group Operators Oracle Pseudo Columns
Decode NVL Functions Concat substr, length Character, String Functions to_char, round, trunc

SQL Tuning
Oracle Explain Plan Utility Decode ANSI SQL Heuristics Based Optimizer SQL Tuning Quiz
SQL Optimizer Modes Non-correlated Subquery Analyze Explain Plan SQL Optimizer Modes

PL/SQL Programming 
Petstore DB Schema Creating Naming Conventions non-PL/SQL VAR bind host DBMS_OUTPUT.PUT_LINE
PL/SQL Block Conclusion Adding PL/SQL Comments Explicit/Implicit Data Conversions Variables Nested Blocks

Database Design
Linking Tables Relational Database Model Relationally Complete Relational Database Quiz
RDBMS Functions Database LifeCycle Design Stages in DBLC Three Schema Architecture
Application Approach Design Post Database Design Stages Top Down Design Database Design Strategy
Business Rules Importance Purpose Requirements Analysis Define Business Objects Business Object Characteristics
Entities Attributes Conceptual Model Multi-valued Attribute Resolve Entity Identifier Attribute Attribute Domain Types
Three Relationship Types Many to Many to One-to-Many Optional Participation Relationship One-to-one Relationship

Database Analysis
DB Tables Characteristics Concatenated Keys Define Primary Key Defining Foreign Keys
Referential Integrity Relational Theory Notation Database Null Values Relational Notation
Normalization Defined Normalization Objective Identify Functional Dependencies Normalization Process - Quiz
Achieving 2nd Normal Form Functional Dependencies - Exercise Normalization Database - Quiz Reduce Data Redundancy
Third Normal Form 1st, 2nd, 3rd Normal Form Second NF Limitations Transitive Dependencies
Table Joins User Views Permissions Roles DB Permissions Requirements SQL Inner Join
Downside Horizontal Partitioning Downside Vertical Partitioning Horizontal Partitioning Database Partitioning

  1. Terms of Service
  2. Privacy Policy