Monday, June 15, 2009

Session 5: assignment one

-products' name
-products' type
-suppliers' name
-suppliers' location
-suppliers' discount given by them

Data Base management system is a special type of software for crearing, organising and assessing data from a data base. It is a centralization and management of data in a logical way so that web browers can retrive and update the data from DBMS.
In the above example, data is stored in tables made up of one or more colums with unique data while the value from each colum of a data is called recordor row.
As the data is created, organized ,grouped, pdated and retrieved in a logical manner, the colum of the data or the special field must not be duplicated but correct and complete so that the data can be analysed and retrieved to be the meaningful data.

1 comment:

  1. You can try to make your answer specific to the database we used in class.

    For example, 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.

    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.)

    ReplyDelete