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
The formal blueprint or pictorial representation of accounting reality using the entity-relationship model concept is called ________ (March 2015)
a) E R design
d) Database structure
a) E R design
The most suitable ‘data-type’ for storing ‘name’ in a database is a _________ (March 2015)
Consider the following fields of MS-Access and answer the questions. (March 2015)
- Here, ‘Voucher’ stands for _______
- ‘Voucher Name’ is termed as _________
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.)
Entity → Employee
Attributes → ID, Name, Age, Designation
________ are some properties or characteristics that give more description of an entity. (March 2016)
c) Entity types
Observe the following table. (March 2016)
a) Give a suitable entity name.
b) Write the relevant attributes relating to the entity.
Entity → Employee/student
Attribute → Job ID, Name, Sex, Date of Birth
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)
- Data Entry
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.
a) Entity – Accounts
b) Key attributes – Account code, Account name.