* 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."
(Reference: http://office.microsoft.com/en-us/access/HA012242471033.aspx?pid=CH100645691033#Good)
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.
1) * Accommodates your data processing and reporting needs.
The database can provide the reports in different categories between two databases. It can sort by the top 5 of Product or best salesman......etc. It helps the business to do better decision in a short period as the data a general provided in an accuracy and integrity way. It is convenience and improve performance for the business.
2) * Divides your information into subject-based tables to reduce redundant data.
In the last lesson, we used small database (Products and Suppliers) in our lab exercise. And we can find that the database can reduce redundant data as it can auto-carify is the data are re-entry data or not. Thus the data will not be duplicated. It is more efficiency and it make the data more accuracy and integrity. We also save time to double check and avoid human mistake/ typing mistake.
--------------------------------------------------------------------------Last but not least, a good database design is worth of using. Because the right method can make our business a breeze, the wrong method can make our business a chore.
The MS ACCESS report wizard allows users to easily design customized reports. The two subject-based tables in our example - Product and Supplier - also contain information that is only specific to a single topic. For example, in order to find out the address of the supplier of a certain product, it's necessary to look up the information in the Supplier table instead of saving it along with the Product record.
回覆刪除