"A good database design is, therefore, one that:
* Divides your information into subject-based tables to reduce redundant data.
* Provides the database management system (e.g. ACCESS) with the information it requires to join the information in the tables together as needed.
* Helps support and ensure the accuracy and integrity of your information.
* Accommodates your data processing and reporting needs."
Think of the small database we used in our lab exercise - Products and Suppliers. Briefly describe how this database observes any two of the four design principles outlined above.
In the small database we used in lab exercise , it first to show the principle of " Provides the database management system (e.g. ACCESS) with the information it requires to join the information in the tables together as needed."
in the database of " product " and "supplier " also have a field of " ID "
this " ID" field can join two of the database table together .
The other one are "Accommodates your data processing and reporting needs"
we can create the report to analysis the information between two database .such as we need to know all the supplier information of product " children . it can list our the accuracy and integrity of supplier data in the report.