Question
Explain the data base design for Model-I for producing the receipts the series of SQL statements for producing the payment side of cash book for Model-II.
✓
Answer
The following series of SQL Statement retrieve a record set of producing the payments side of the Cash Book for Model II.
WHERE tType = 1 AND V.VNO = D.VNO
AND Acc-code like “141*”.
WHERE tType = 0 AND V.VNO = D.VNO
AND Code Like “141*”.
WHERE tType = 1 AND V.VNO = D.VNo
AND Acc-code Like “141*”.
UNION
SELECT Narration, Code, Amount
FROM vouchers As v, Details As D
WHERE tType = 0 AND V. VNO = D.VNo
AND Acc-code like “141*”.
This SQL statement is source as Query D1
GROUP BY Code
This SQL statement is saved as Query D2.
FROM Query D2 As a, Account As b
WHERE a code = b code
- SELECT Narration, Acc-code As Code Amount
WHERE tType = 1 AND V.VNO = D.VNO
AND Acc-code like “141*”.
- SELECT Narration, Code, Amount
WHERE tType = 0 AND V.VNO = D.VNO
AND Code Like “141*”.
- SELECT Narration, Acc-code As Code Amount
WHERE tType = 1 AND V.VNO = D.VNo
AND Acc-code Like “141*”.
UNION
SELECT Narration, Code, Amount
FROM vouchers As v, Details As D
WHERE tType = 0 AND V. VNO = D.VNo
AND Acc-code like “141*”.
This SQL statement is source as Query D1
- SELECT Code, Sum (Amount) As Total
GROUP BY Code
This SQL statement is saved as Query D2.
- SELECT a.Code b.Name As [Name of Account],
FROM Query D2 As a, Account As b
WHERE a code = b code
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Explain the following along with their advantages:
- Ready to use accounting software.
- Customised accounting software.
- Tailored accounting software.
Rectify the following errors:
- Purchases Book is overcast by ₹ 500.
- Salary paid to an employee, Mr. Ajay, is debited to his Personal account ₹ 3,000.
- Goods sold to Shashi on credit ₹ 300 have been wrongly passed through the Purchases Book.
- Total of Returns Inward Book has been added ₹ 9 short.
- Purchase of chair from Happy Traders for ₹ 35 has been entered in the Purchases Book as ₹ 53.
From the following particulars, ascertain the bank balance as per Pass Book as on 31st March, 2019 (a) without correcting the Cash Book balance and (b) after correcting the Cash Book balance:
- The bank balance as per Cash Book on 31st March, 2019 ₹ 40,000.
- Cheques issued but not encashed up to 31st March, 2019 amounted to ₹ 10,000.
- Cheques paid into the bank, but not cleared up to 31st March, 2019 amounted to ₹ 15,000.
- Interest on investments collected by the bank but not entered in the Cash Book ₹ 500.
- Cheques deposited in the bank but not entered in the Cash Book ₹ 12,500.
- Bank charges debited in the Pass Book but not entered in the Cash Book ₹ 100.
Siya maintains her books of account from Incomplete Records. Her books provide the following information:
She withdraws ₹ 500 per month for personal expenses. She sold her Investments ₹ 16,000 at $5 \%$ premium and introduced the amount into a business.
You are required to prepare a Statement of Profit or Loss for the year ending $31^{\text {st }}$ March 2023.
→| Particulars | 1^(st ") April 2022 (₹) | 31^(st ") March2023 (₹) |
| Cash | 1,200 | 4,000 |
| Debtors | 16,800 | 27,200 |
| Stock | 22,400 | 24,400 |
| Investments | ________ | 8,000 |
| Furniture | 7,500 | 8,000 |
| Creditors | 14,900 | 11,600 |
She withdraws ₹ 500 per month for personal expenses. She sold her Investments ₹ 16,000 at $5 \%$ premium and introduced the amount into a business.
You are required to prepare a Statement of Profit or Loss for the year ending $31^{\text {st }}$ March 2023.
Give journal entries to rectify the following errors assuming that suspense account had been opened.
- Goods distributed as free sample ₹ 5,000 were not recorded in the books.
- Goods withdrawn for personal use by the proprietor ₹ 2,000 were not recorded in the books.
- Bill receivable received from a debtor ₹ 6,000 was not posted to his account.
- Total of Returns inwards book ₹ 1,200 was posted to Returns outwards account.
- Discount allowed to Reema ₹ 700 on receiving cash from her was recorded in the books as ₹ 70.
Hari maintains his books of account on Single Entry System. His books provide the following information:
His drawings during the year were ₹ 5,000 Depreciate furniture by 10% and provide a reserve for Bad and Doubtful Debts at 10% on Sundry Debtors. Prepare the statement showing the profits for the year.
His drawings during the year were ₹ 5,000 Depreciate furniture by 10% and provide a reserve for Bad and Doubtful Debts at 10% on Sundry Debtors. Prepare the statement showing the profits for the year.
What is the use of Data Base Management?
Briefly state the purpose of functions in SQL environment.
M/s Saniya Sports Equipment does not keep proper records. From the following information find out profit or loss and also prepare balance sheet for the year ended March 31, 2017:
Drawing ₹ 10,000 p.m. for personal use, fresh capital introduce during the year ₹ 2,00,000. A bad debts of ₹ 2,000 and a provision of 5% is to be made on debtors. outstanding salary ₹ 2,400, prepaid insurance ₹ 700, depreciation charged on furniture and machine @ 10% p.a.
Drawing ₹ 10,000 p.m. for personal use, fresh capital introduce during the year ₹ 2,00,000. A bad debts of ₹ 2,000 and a provision of 5% is to be made on debtors. outstanding salary ₹ 2,400, prepaid insurance ₹ 700, depreciation charged on furniture and machine @ 10% p.a.
Following balances are taken from the books of Niranjan. Prepare Trading and Profit and Loss Account and Balance Sheet for the year ended 31st March, 2019:
(iamge)
Adjustments:
(iamge)
Adjustments:
- Closing Stock ₹ 7,50,000.
- Depreciate Machinery by 10% and Furniture by 20%.
- Wages ₹ 50,000 and salaries ₹ 20,000 are outstanding.
- Write off ₹ 50,000 as further Bad Debts and create 5% Provision for Doubtful Debts. Also, create a reserve for discount on Debtors @ 2%.
- Investments were made on 1st July, 2018 and no interest has been received so far.