Structuring Database for Accounting

using * and range specification within rectangular brackets. For Example: ( ) To make a list of accounts pertaining to the assets of the company, given that each of the assets account code begins with “ ”, following query need be executed: ( Model-I and Model-II ) Code, Name accounts Code like “ *” ( ) To make a list of employees whose names start from a to k, following query need be executed : ( Model-I and Model-II ) Fname & “ “ & Minit & “ “ & Lname As ‘Name of Employee’ Employees Fname like “[a-e]*” VI. Another comparison operator used in SQL is BETWEEN ....AND .... operator.

This operator facilitates numeric range tests for selection of tuples. For Example: ( ) To retrieve vouchers with amount ranging between , and , , following query need be formulated. ( Model-I ) Vno, Amount Vouchers Amount BETWEEN AND 10000 ; (Model-II) Vno, Amount Vouchers AS V, Details AS D WHERE . V.vno = D.vno AND Amount BETWEEN , AND , ; VII.

Another feature of SQL permits the use of standard arithmetic operators, which can be directly applied to numeric values appearing in a query