Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / DB Theory / August 2005

Tip: Looking for answers? Try searching our database.

Web resources for teaching data base design.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David  Cressey - 25 Aug 2005 13:43 GMT
Hey Fran, This one's for you.

Over the course of time,  I've looked for web resources that illustrate
database design principles, so that I can refer to them instead of typing in
the same responses over and over again.

Here are the best two I've found:

http://www.databaseanswers.com/

this one has about 200 data models that you can grab right off the web.  The
models are in the form of an ER diagram (for conceptual models)  or a
relational schematic (for logical models).  In addition,  the owner will
send you, by e-mail, an empty MS Access database derived from the model,  if
you send an appropriate e-mail to him (or to his mailbot, I guess).

These models provide functional examples of minimal level models for a
variety of situations.  You can typically use one of these models as a
starting place for prototyping your way up to a full model.

http://www.utexas.edu/its/windows/database/datamodeling/index.html

This one contains a bare bones introduction to both the ER model (conceptual
data modeling) and the relational model
(logical data modeling).   It's not perfect, as some regulars in
comp.databases.theory have pointed out,  but it's very good.  It lays out
the essentials in a format that's easily followed.

I particularly like the fact that it differentiates clearly between
conceptual data modeling and logical data modeling.  There are many experts
who skip right over conceptual modeling and start out right away with
logical modeling.  I think that's a mistake, when it comes to discussing
information requirements with subject matter experts that may be very naive
about data.  But other professionals report the opposite experience.  Go
figure.

Anyway,  I hope this helps.
huychat2005@gmail.com - 26 Aug 2005 01:21 GMT
thanks for yours,
It's very cool, and helpful !!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.