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.