RelationalDBDesign(Database Design and Analysis)

RelationalDBDesign RelationalDBDesign

SiteMap

Welcome to RelationalDBDesign!

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

RelationalDBDesign

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

Characteristics of SQL	PUBS Database explained	Group By Clause	Subquery Equals Clause
GETDATE, SYSDATE, TODAY

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

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

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