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.
Ans: DBMS can eliminate limitations of conventional file management in operating systems; increase data independence; enhance data sharing and flexibility of access; minimize storage redundancy; increase performance and efficiency of data manipulation; increase data integrity, and data administration and control.
From the small database we used in our lab exercise - Products and Suppliers, we can see that it can
a) divides information into subject-based tables to reduce redundant data ~ All product name & supplier name were recorded by a unique ID#, it can avoid duplicate information which would increases the likelihood of errors and inconsistencies
b) accommodate data processing and reporting needs ~ we can easily to general reporting by sort out the data from those database.
The report wizard in MS ACCESS lets us easily design reports by choosing the data to be included, any grouping levels, sorting sequence, layout, orientation, etc.
回覆刪除Our database is also organized into two tables (Product and Supplier) - each table deals with a single suject only.