The Reldes.doc Word document shows you how to plan and design a database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in Microsoft Access 2002.
The following file is available for download from the Microsoft Download Center:
Collapse this imageExpand this image
The DBDesign.exe file contains the following file:
Reldes.doc A Microsoft Word document
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Â
(http://kbalertz.com/Feedback.aspx?kbNumber=119591/
)
How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
Note To see this information for earlier versions of Microsoft Access, please see the following article in the Microsoft Knowledge Base:
164172Â
(http://kbalertz.com/Feedback.aspx?kbNumber=164172/
)
"Understanding Relational Database Design" document available in Download Center
The Table of Contents of Reldes.doc is as follows:
Overview
The database design process
Steps in designing a database
Common design problems
Determining the purpose
Determining the tables you need
Determining the fields you need
Tips for determining fields
Primary key fields
Determining the relationships
Refining the design
Additional reading and practice
: Microsoft offers a WebCast that discusses the basics of database normalization. To view this WebCast, please visit the following Microsoft Web site: