Foundation of Information Technology

Database is a collection of information that is organised, so that it can easily be accessed, managed and updated. Database systems do not maintain copies of same data. All data is kept at one place and all applications that require data refer to the centrally maintained database. If any change is to be made to data, it will be made at just one place and same changed information will be available to all the applications referring to it. Unnecessary duplication of data is avoided. Database reduces the extra storage required, eliminates the extra processing involving large masses of data and eliminates inconsistencies which can exist in multiple copies. BASE is a popular RDBMS that manages the database by providing variety of features. Database file of BASE is stored with extension .odb. Table refers to storage container storing data pertaining to single object, subject or purpose. Query is a statement that gives filtered data according to conditions and specifications. To find and retrieve the data that meets the conditions that are specify including data from multiple tables, a query may be created. Report is an effective way to present data in a printed format. It is a formal, presentable printed document that lists data in a formatted manner. To analyse data, a report is created.

To Access the full content, Please Purchase