CS157 Links

Overview

Introduction to Relational Database Design---Written by Fernando Lozano

DBMS

What is A Data Model?

Conceptual Modeling

The Entity-Relationship Model

On-to-many relationship

Other Styles of E-R Diagram

Converting an E-R diagram to a relational schema

Lecture Note ER-diagram

Database Normalization And Design Techniques

Designing an effective database

Relational model

Lecture Note Relational Database

Deletion and Insertion Anomaly

Functional Dependence

Armstrong’s Axioms

Examples

Note on Closure of FD

Normal Forms

Boyce Codd Normal Form

Fifth Normal Form

Normalization

Relational Database and Normalization

Relational Database Design and BCNF

Relational Algebra

Relational Algebra Examples

Relational Algebra Operations

Relational Algebra Tutorial

Lecture Note Relational Algebra

MySQL

SQL

SQL Programming

SQL Relational Algebra Examples

SQL Transactions

Relational Calculus

Relational Calculus Module

Examples

QBE

Object-Oriented Database Design: What is the Difference with Relational Database Design

 

DB Magazines

DB2 Magazine

Oracle Magazine