ACC2000: "Understanding Relational Database Design" Document Available on MSL

ID: Q234208

The information in this article applies to:
Novice: Requires knowledge of the user interface on single-user computers.


SUMMARY

The Reldes00.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 the Microsoft Access package.

Reldes00.exe is available for download from the Microsoft Software Library. It contains the following files: 


   Reldes00.doc  A Microsoft Word document
   Readme.txt    This Readme file
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:
Q119591 How to Obtain Microsoft Support Files from Online Services


MORE INFORMATION

The Table of Contents of Reldes00.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

Additional query words: 


Keywords          : kbfile kbdta Softlib 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: June 8, 1999