|
::
Introduction
::
Database principles
::
Tables
::
Queries
::
Data security
::
Glossary
::
Resources
::
Student Files
:: Contact
:: Back to Main Site
:: Site
Map
|
Microsoft Access - Class 1 - Part XIII
|
>
Back |
Key Steps to designing a useful, efficient database model:
| 1. |
Identify the problems to be solved |
| |
|
| 2. |
Classify solution |
| |
|
| 3. |
List the objects |
| |
|
| 4. |
List the facts about the objects |
| |
|
| 5. |
Turn the objects and facts into tables and columns
|
| |
|
| 6. |
Determine the relationships among objects |
| |
|
| 7. |
Determine the key columns |
| |
|
| 8. |
Determine the linking columns |
| |
|
| 9. |
Determine the relationship constraints |
| |
|
| 10. |
Evaluate the design. |
Print this page
|
