RelationalDBDesign  
prev next prev next
  Course navigation
 
Lesson 1
Relational Database Design
Why should I be interested in learning about Relational Databases?
This course describes a design methodology for creating a database capable of producing useful information in a consistent manner.
    Module introduction
Current relational database software has brought point-and-click ease to the task of creating databases.
However, unless your database is properly designed, it will be characterized by data problems such as
  1. missing data,
  2. incorrect data and
  3. mismatched data
that will make it almost useless, no matter how user-friendly the software is.
This course on Relational Database Design is the first step in learning a design methodology that will help you create a database capable of producing useful information in a consistent manner.
Specifically, I will discuss the principles of data modeling, culminating in the creation of a database diagram.
    Learning objectives
After completing the first course in this series, you will be able to:
  1. Explain relational database design concepts and terminology
  2. Explain the difference between conceptual and physical models
  3. Develop a conceptual design
  4. Analyze user information requirements
  5. Describe the entity/relationship modeling approach
  6. Identify entities
  7. Model relationships and identify attributes
  8. Use primary and foreign keys
   
In this course, I will discuss relational database design with the aid of two kinds of graphical displays
  1. the SlideShow and
  2. the MouseOver.
You will complete a course project that involves creating a database design diagram appropriate to the needs of Stories on CD, Inc.
This is a fictional company that sells books on CD via mail order.
You will complete the project incrementally via a series of exercises that provide opportunities to apply what you have learned to a real-world situation.
While the company is small and its needs relatively simple, the principles you apply to analyzing its requirements and designing a database to meet them are the same as those that database designers apply to much larger projects involving multi-national corporations.
    Database series
Data Modeling is the first of two courses in the Relational Database Design Fundamentals series.
    The next lesson outlines the prerequisites for this course.
Advanced Structured Query Language  
Characteristics of SQL Group By Clause Sub-Select Statements Sub-Select Equals Clause
Basic Structured Query Language  
DB Normalization - Exercise Relational DB Analogy Relational vs. Flatfile Customer Table Example
SQL Approaches - Quiz SQL-92
Database Creation Architecture    
Oracle Describe Command Oracle Spool Command Oracle Exit Command desc oracle command
Start Server Manager Locating Oracle Home Server Manager Executable Server Manager HELP Command
Set output off - Oracle
Managing Database Objects   
Oracle Segment Role Alter extent size table Tablespace Fragmentation Quiz Operating system blocks
Oracle Extents Free Diction-Quiz Oracle Storage Concepts Describing Columns View
Coalesce Tablespace Oracle Tablespace Default Storage Fragmented TableSpace Oracle Extents Data Dictionary
Oracle Dictionary Extents Oracle storage management concepts Oracle free space Auction House Database
Oracle Network Topology  
Location Independence Transparent NS Distributed Databases Searching Oracle Topology
Hardware Independence
Oracle SQL Tuning  
Heuristics Based Optimizer Oracle Explain Plan Utility SQL Tuning Quiz Decode ansi standard sql
PL/SQL Programming   
dbms_out.put_line in sql Petstore schema pl sql dbms_output Building Queries with PL/SQL
non pl/sql variables bind and host (PGA) Program Global Area Pet Store DataModel Adding PL/SQL Comments
PL/SQL Block Conclusion Oracle Naming Conventions
Define: Truth Table Define: Unary Define: Pragma
Relational Database Analysis  
Define Primary Key Concatenated Keys Normalization First Normal Form Exercise
DB Tables Characteristics Database Design Diagram Second Normal Form - Exercise Normalization Process - Quiz
Referential Integrity Defining Foreign Keys Functional Dependencies - Exercise Normalization Database - Quiz
Relational Theory Notation Achieving 2nd Normal Form
Relational Database Design  
Design Stages in DBLC ERD Modeling CaseStudy Three Schema Architecture Database LifeCycle
Database Design - Quiz Database Design Strategy RDBMS Functions Relational DB Design
Relational DB Design Quiz Post Database Design Stages Top Down Design Relational Database Course Project
ERD Exercise Bottom-up Design