Links and Tutorials for CIS39 - Database Design

Relational Database Concepts Lesson #1 in a series, be sure to go to lesson #2
Information about relational databases and normalization from Microsoft
More information on normalization and design
Links to information on relational databases
Very complete and more advanced reference
Taking it further
Another source
Step-by-step guide to using databases
From how stuff works
Introduction to Relational Database Design
Beginning Database Design
Practical Database Design
Practical Database Design part 2
Database Design Principles
Understanding Relational Databases
Introduction to Relational Database
Introduction to Relational Database Systems
Introduction to Data Modeling
Introduction to Relational Databases
Design concepts
Beginning of the series on database development
Relational Databases
Database Modeling Introduction to Data Modeling
Database Design and Modeling Fundamentals
Database Design thoughts for Packaged Applications
Databases from Scratch
Database design with UML and SQL
Best free database design training materials
Data Data Warehousing Information Center
DataWarehousing Online
Data Warehousing - a research oriented bibliography
Data Warehousing - Knowledge Base
Data Warehousing at Stanford
Data Warehousing
Data Mining
Helpful links/notes This is an article on Oracle and databases
Help with Oracle
Oracle/SQL/PL/SQL tutorial
Oracle tutorial
PL/SQL
SQL*Plus tutorial
Underground Oracle FAQ
Interactive SQL Training
More information Evolutionary Database Design
About article on database Design
Unicode and cleansing
Relational Database
Entity-Relationship Diagrams Peter Chen home page with interesting links look under papers
Paper on Entity-Relationship by Chen
English Sentence Structure and Entity-Relationship Diagrams
Examples and explanation
Examples and explanation at bottom set of links
Exercise on developing
Another writeup on ERD
Developing Entity Relationship Diagrams (ERDs)
Introduction to Data Modeling
Access Access tutorial from Florida Gulf Coast University
Access tutorial
Another Access Tutorial
And another Access tutorial
And one more recommended by a classmate
Textbook Support Textbook support for Database Systems by Rob and Coronel (I recommend this book if you want to dig deeper)
White Paper on normalization by Hernandez
Accounting Support Information about aging accounts
Case Studies Blue Claw Database Design Case Studies
Scholarship Billing System
Installation and login information for Oracle for anyone who wants to use it Disclaimer: Needless to say, I have not checked everything listed here, many of them come highly recommended, others just look promising. If you find good solutions to any problems you encounter, please post them on the boardroom.
Logging in at home using 7.3 (similar in other versions)
Login instructions - lab
Information about installing 8i
Information about installing 9i that comes with your text
Link to Oracle where you can download 8i or 9i
Another link for downloading either 8i or 9i
Source for frequently asked questions about Oracle - includes a forum
Source for frequently asked questions about Oracle - specifically operating systems
Installing Personal Oracle 8i
Installing Oracle 9i

Send e-mail to Mrs. Grocer: pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page