Design & E-R Web Sites
 Web Sites with More Information on  Conceptual Design and E-R (Entity Relationship) Modeling

Site Map

Sites with more Access explanations and examples

Sites with more Normalization explanations and examples

Home


 

 

Data Modeling: Finding the Perfect Fit
by Tim McLellan (simple greenhouse (plant, watering, feeding) database - 1995
A simple short (4 pages) paper on Data Modeling that covers entities, attributes, relationships and diagrams. Using a plant greenhouse example.   It is a great place to start.

 Introduction to Data Modeling gives an overview of developing a conceptual data model as the first step in creating a relational database. It is broken up into nice screen size chunks but mostly words (not many diagrams)
by: Academic Computing and Instructional Technology Services ACITS  at The University of Texas at Austin
ACC2000: "Understanding Relational Database Design" Document Available in Download Center has a download of an excellent paper. (20 pages with Access examples based on Northwinds customers, orders, suppliers model) Conceptual Design Using the Entity-Relationship (ER) Model 
PowerPoint Lectures by Raghu Ramakrishnan's 
PowerPoint of Prof. Hermann Gruenwald,  University of Oklahoma, covers all  the key terms of the E-R Model
Univ of Michigan comprehensive (25+ pages) review of ER modeling

Entity-Relationship Modeling by Apple

 Babson College in Wellesley MA poses and Order Entry  problem and solution.

Some theory of creating ERDs.
Jose's Database Programming Corner

Fundamentals of Database Design uses a student database to show E-R  modeling.

Webmonkey
1  Your First Database — Lesson 2
2  The Relational Database
3  Defining Tables
4  Making Those Tables Relate
5  Working with Access
6  Connecting to the Web Server
Webmonkey has 4 fun to read lessons.  Lesson 2 is theory (which we are learning) 
Lesson 3 and 4 show you have to put put database on the Internet!  The author is a programmer and let me quote what he says about database, "where a solid data structure is absolutely vital. If you start out with poorly arranged data, you could be in big trouble down the line, trouble from which you might never recover. Even experienced database administrators have been known to discover, halfway into a project, that their data design is flawed and they have no choice but to throw out all the code they've written so far and start from scratch."
  Chilli Source LogoChilli demo download is good only for 14 days. DeZign for Databases is ERD modeling tool -download evaluation copy.  You can't print it but who cares you can save it, post it and email it.. 
  CASE Studio 2 can be downloaded

[ Site Map ] [ Home ]

This page was created by Professor Maureen Greenbaum and was last updated on 02/04/06 .

Page Name:  Design & E-R Model Web Sites
URL:             http://faculty.ucc.edu/business-greenbaum/DB/websitesER.htm
Disclaimer:    http://www.ucc.edu/professional_disclaimer.htm
Copyright:      © Maureen Greenbaum 2001. ©2002.  All rights reserved.