Structuring Database for Accounting Account - Structuring Database for Accounting

What is meant by NULL value? What are the reasons that lead to their occurrence in database relations?

Why are duplicate tuples not allowed in a relation?

What do you understand by relationship type? How is it different from relationship instance and relationship set?

How are computers useful in processing the accounting data?

What is the need for database normalisation?

Discuss the basic concepts of Entity Relationship (ER) Model. Illustrate as to how an ER model is diagrammed.

Give journal entries to rectify the following errors assuming that suspense account had been opened.

1. Goods distributed as free sample ₹ 5,000 were not recorded in the books.
2. Goods withdrawn for personal use by the proprietor ₹ 2,000 were not recorded in the books.
3. Bill receivable received from a debtor ₹ 6,000 was not posted to his account.
4. Total of Returns inwards book ₹ 1,200 was posted to Returns outwards account.
5. Discount allowed to Reema ₹ 700 on receiving cash from her was recorded in the books as ₹ 70.

As an accountant of a company, you are disappointed to learn that the totals in your new trial balance are not equal. After going through a careful analysis, you have discovered only one error. Specifically, the balance of the Office Equipment account has a debit balance of ₹ 15,600 on the trial balance. However, you have figured out that a correctly recorded credit purchase of pendrive for ₹ 3,500 was posted from the journal to the ledger with a ₹ 3,500 debit to Office Equipment and another ₹ 3,500 debit to creditors accounts. Answer each of the following questions and present the amount of any misstatement:

1. Is the balance of the office equipment account overstated, understated, or correctly stated in the trial balance?
2. Is the balance of the creditors account overstated, understated, or correctly stated in the trial balance?
3. Is the debit column total of the trial balance overstated, understated, or correclty stated?
4. Is the credit column total of the trial balance overstated, understated, or correctly stated?
5. If the debit column total of the trial balance is ₹ 2,40,000 before correcting the error, what is the total of credit column.

What do you understand by database. How does it differ from DBMS?

Discuss the different types of update operations in relation to the integrity constraints which must be satisfied in a relational database model.