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.
* Provides the database management system (e.g. ACCESS) with the information it requires to join the information in the tables together as needed.
-in our lab exercise, we used a small database in ACCESS. The data is stored in tables made up of columns and rows. Two tables can be join together as they have same field of data.
* Accommodates your data processing and reporting needs
-We can just type in the data we need to generate a report we need. It is good for formatting, calculating, printing, and summarizing data.
The foreign key "Supplier Number" allows us to link or comine related records from the two tables - Product and Supplier.
回覆刪除The report wizard lets non-technical users easily design a report after users answer a series of questions.