CreateTalColonialSolmaris (this script creates the 3 databases)

SQL9e_PPT_CH02 PPT

SQL9e_PPT_CH02 PDF

SQL Cert Questions 1

Three ways to deisgn a database

1. Normalization:

(starting with a flat file and breaking it up)

http://raider.mountunion.edu/csc/csc100/spring2015/database/normalizationexample.html

http://salinaitmind.blogspot.com/2012/10/data-warehouse-data-normalization.html

2. Design from scratch

(interviewing business people)

ERD COLONIAL (PNG)

Solmaris ERD (PNG)

TAL ERD (PNG)

OracleLogins

Day3