Kerala Plus One Accountancy Chapter Wise Previous Questions and Answers Chapter 12 Structuring Database for Accounting
Question 1.
The formal blueprint or pictorial representation of accounting reality using the entity-relationship model concept is called ________ (March 2015)
a) E R design
b) Voucher
c) Entity
d) Database structure
Answer:
a) E R design
Question 2.
The most suitable ‘data-type’ for storing ‘name’ in a database is a _________ (March 2015)
a) number
b) text
c) date
d) memo
Answer:
b) Text
Question 3.
Consider the following fields of MS-Access and answer the questions. (March 2015)
- Here, ‘Voucher’ stands for _______
- ‘Voucher Name’ is termed as _________
Answer:
- Entity
- Attribute
Question 4.
State the entity and its attributes for the given information wherever you find a question mark. Entity:? (Say 2015)
(Hint: The above information is taken from the payroll records of a company.)
Answer:
Entity → Employee
Attributes → ID, Name, Age, Designation
Question 5.
________ are some properties or characteristics that give more description of an entity. (March 2016)
a) Objects
b) Attributes
c) Entity types
d) Values
Answer:
b) Attributes
Question 6.
Observe the following table. (March 2016)
a) Give a suitable entity name.
b) Write the relevant attributes relating to the entity.
Answer:
Entity → Employee/student
Attribute → Job ID, Name, Sex, Date of Birth
Question 7.
Arrange the following items given in the brackets into their order of occurrence in the transaction processing cycle. (Say 2016)
(Storage, Data Entry, Processing, validation)
Answer:
- Data Entry
- Validation
- Processing
- Storage
Question 8.
a) Write a suitable entity for the attributes given below. (March 2017)
Account Code, Account Name
b) Also identify the key attribute to that entity.
Answer:
a) Entity – Accounts
b) Key attributes – Account code, Account name.