A database is a collection of data organized to service many applications at the same time by storing and managing data so that they appear to be in one location.
In our lab exercise, we used the database of Products and Supplier.
I brief how this database observes the principles outline that Jenny mentioned.
*Divides your information into subject-based table to reduce redundant data.
*Provides the database management system (e. g ACCESS) with the information it requires to join the information in the table together as needed
We enter the data of product and supplier into below subjects and the function were listed as below
Table-used for data storage
Query-used for selecting and viewing records
Form-used for data input
Report-Used for formatting, calculating, printing, summarizing data
ACCESS collects the data as a small database.
We choose the data that we need due to that reduce redundant data. For designing and generating report, we arrange order that is most important. For example, the selling price is the point that I concern, so I sort the database of selling price data ascending. After the generate report, it was shown the column of selling price first. I check it clearly.
In our lab exercise, we used the database of Products and Supplier.
I brief how this database observes the principles outline that Jenny mentioned.
*Divides your information into subject-based table to reduce redundant data.
*Provides the database management system (e. g ACCESS) with the information it requires to join the information in the table together as needed
We enter the data of product and supplier into below subjects and the function were listed as below
Table-used for data storage
Query-used for selecting and viewing records
Form-used for data input
Report-Used for formatting, calculating, printing, summarizing data
ACCESS collects the data as a small database. We choose the data that we need due to that reduce redundant data. For designing and generating report, we arrange order that is most important. For example, the selling price is the point that I concern, so I sort the database of selling price data ascending. After the generate report, it was shown the column of selling price first. I check it clearly.
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 foreign key "Supplier Number" allows us to link or comine related records from the two tables.