Tag: application of electronic spreadsheet in accounting

Questions Related to application of electronic spreadsheet in accounting

A relation is given an identity by its ___and description by its ____.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. schema,name

  2. name ,schema

  3. both of the above

  4. none of the above

Show answer
Correct Option: B

 In relational data model each row of a table is called as ______________.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. attribute

  2. domain

  3. data record

  4. relation

Show answer
Correct Option: C

In relational data model column header is called as_________.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. domain

  2. tuple

  3. relation

  4. None of the above

Show answer
Correct Option: D

Code is known as ________of account.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. category

  2. names

  3. identity

  4. none of the above

Show answer
Correct Option: C

A column header is called an __________, in relational data model.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. Domain

  2. Tuple

  3. Attribute

  4. Relation

Show answer
Correct Option: C
Explanation:

In relational data model, the table name and column names are used to help in interpreting the meaning of values in each row. All values in a column, which belong to a particular domain, are of same data type. A column header is called an attribute.

In database, the ___________ implies that distinct tables have been logically organised and the purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. Shared property

  2. Integrated property

  3. Intellectual property

  4. Both B and C

Show answer
Correct Option: B
Explanation:

Database has two important properties (or characteristics): one is integrated and second is shared. Integrated property implies that distinct data tables have been logically organised. The purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access.

The ________ represents the database as collection of relations, which resembles a table of values (or data table).

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. Relational data model

  2. ER model

  3. Data model

  4. Both A and B

Show answer
Correct Option: A
Explanation:

A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables.

A row is called a _________, in relational data model.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. Domain

  2. Tuple

  3. Attribute

  4. Relation

Show answer
Correct Option: B
Explanation:

The relational data model represents a table of values (or data table). Each row of the table, therefore, represents a collection of related data values and hence typically corresponds to real world entity or relationship. Formally, a row is called a tuple.

In database, __________ means that all those who are authorised to use data/information have access to relevant data.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. Shared property

  2. Integrated property

  3. Intellectual property

  4. Both A and B

Show answer
Correct Option: A
Explanation:

Database has two important properties (or characteristics): one is integrated and second is shared. The shared property means that all those who are authorised to use data/information have access to relevant data.

__________ refers to data that have been processed and organised in a form, which is suitable for decision-making.

accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

  1. Data

  2. Database

  3. Information

  4. Reality

Show answer
Correct Option: C
Explanation:

Information refers to data that have been processed and organised in a form, which is suitable for decision-making, The raw data processed in accordance with decision usefulness of a decision-maker becomes information.