value of Vtype( = , means codes being debited, means codes being credited) Sno : Serial number of accounts being debited in debit voucher and those being credited in credit voucher Vtype : = means debit voucher, = credit voucher Amount : Amount of transaction Narration : Narration of transaction (iv) Write relational operation expressions and relevant SQL statements for following queries using Database Design Model-I and Model-II : (a) Retrieve the voucher details and type of voucher authorised by a particular employee. (b) Retrieve every bank payment voucher details, account name, amount. You are given that bank account code =”632001”. (c) Find details of cash vouchers pertaining to an expense account whose account code = ”711003”.
You are given that cash account code=”631001”. (d) Make a list of accounts and amount with respect to which a voucher has been either prepared or authorised by a particular employee. (e) Retrieve details of vouchers without support documents. (f) List details of documents with at least one support document.
(g) Find all vouchers with total amounts raised during a particular month. (h) Retrieve all vouchers prepared by an employee whose First name is “Smith”. (iv) Write relational operation expressions and relevant SQL statements for following queries using Database Design Model-I and Model-II. (a) Retrieve all vouchers pertaining to a particular account with amounts ranging between Rs.
, to Rs. , . (b) Retrieve details of each voucher whose support document has the same date as that of the voucher itself. (c) Retrieve details of voucher authorised by employees who do not have supervisors.
(d) Find sum of cash payments, maximum payments, minimum payments and average. (e) Find sum of cash payment, maximum and minimum amount with respect to a particular account Code. (f) Retrieve every bank payment voucher details, account name, amount pertaining to a particular period ranging from Date1 to Date . (g) Find details of cash vouchers pertaining to a particular expense account.
(h) Make a list of accounts and amount with respect to which a voucher has been either prepared or authorised by a particular employee.