Structuring Database for Accounting

In this sense, it can be used as a sub-language in a database-programming context. Basic Queries in SQL : Data Query Language (DQL), which is a sub-set of SQL is widely used to answer most of the basic queries. The basic set of queries consists of those, for which the SELECT-FROM-WHERE Structure is put to use SELECT : This clause is used to specify the data or information that is desired to answer the query. FROM : This clause is used to specify the source of data for answering the query.

It can be a data table, an existing query or both. WHERE : This clause is meant to specify the conditions that are used to narrow down the choice of data to extract the information desired in select clause. The following queries have been considered using the database design given in Model-I and Model-II. The solution to queries has been given using MS ACCESS implementation.

I. Query to retrieve all columns of data records from a table, subject to a condition : To project all the attribute values of selected tuples, an asterisk (*) need be specified. This asterisk stands for all the attributes. ( ) To retrieve all columns of voucher records whose voucher has been authorised by an employee whose EmpId is equal to “A001”.

( Model-I and Model-II ) SELECT * vouchers AuthBy=”A001” ;