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.
Answer:
As we can see, the lab exercise - Products and Suppliers is already considered as the first principles "Divides your information into subject-based tables to reduce redundant data", it is becasue we can consolidated all datas into different main categories: Children, Hybrid, Leisure...etc
Also, we can just print everything out in a table or report for the easiest access like the print out I got from the class, a single page which showing all supplier and products info. This is obvious fall into another principles: "Accommodates your data processing and reporting needs"
20090625
Subscribe to:
Post Comments (Atom)
That's right, the database itself is organized into two separate tables - Products and Suppliers. Each table only focuses on a single subject. For example, a product record does not contain the supplier's name or address.
ReplyDeleteReport Wizard in MS ACCESS also allows anyone, even a non-technical user, to easily custom-design a report.