Plus One Accountancy Chapter Wise Previous Questions Chapter 11 Structuring Database for Accounting

Kerala State Board New Syllabus Plus One Accountancy Chapter Wise Previous Questions and Answers Chapter 11 Structuring Database for Accounting.

Kerala Plus One Accountancy Chapter Wise Previous Questions and Answers Chapter 11 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)

1. Here, ‘Voucher’ stands for _______
2. ‘Voucher Name’ is termed as _________

Answer:

1. Entity
2. 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:

1. Data Entry
2. Validation
3. Processing
4. 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.