Roger's Access Library Homepage
Forum Home Forum Home>Roger's Access Library>Tutorials
  Active Topics Active Topics
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Database Design
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Online Status: Offline
Posts: 217 		  Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: Database Design
    Posted: 21 Jul 2008 at 7:01am

What follows are some topics important to proper database design.  Following these are several examples of database design problems and their solutions.

Topics:
What Is Normalization?
Entity-Relationship Diagramming
ERMaster.ppt (ER Diagram template for PowerPoint)

Examples:
**Note: The PROCESS is the important thing here.  It may be that I have made a mistake in the actual modeling.  That will come out in the discussions with the customer and the prototyping.  But pay attention to the process that went into the examples. **
Class Information Database (stores information about students in a college class)
Cater-It Database (small catering business)
GSA Database (Gender Non-specific Scouts of America)
Scrip Database (a high school fund-raising program )

Consolidated Widgets (stores information for the Widget Trade Show)

Design Links:
Please consider donating $1 per sample downloaded, find out why here.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Bulletin Board Software by Web Wiz Forums® version 9.06
Copyright ©2001-2007 Web Wiz