Q:
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:
Refer to last lab exercise, we can organize the information into tables, where each table lists of rows and columns reminiscent. For example, we entry the related data into table and assign the primary keys of table in database. We can use this database to divide the information items into major entities or subjects and require to join the information in the tables together.
We can easily to find out the general reports as we can accommodate the data processing and reporting such as inventory status by product category report.
1 留言:
That's right. Our small database has two tables - for Products and Suppliers. This shows that our data has been organized by Subject, because each table is only concerned with one subject.
The "Supplier Number" field, which is common to both tables, allows us to link or join related records from the two tables.
We also used the Report Wizard to retrieve and combine data from these two tables in a more meaningful way (e.g. selecting only certain fields and records, sorting/grouping these records, designing the layout, adding totals, etc.)
發佈留言