Tag: concept of entity and relationship

Quizzes (0) Questions (43)

Questions Related to concept of entity and relationship

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

A process of refining a database design through which the possibility of duplicate or redundant data items are reduced or eliminated is _______.

  1. ER design

  2. Refinement

  3. Reality

  4. Normalisation
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Normalisation is a process of refining a database design through which the possibility of duplicate or redundant data items are reduced or eliminated.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

The steps required in data processing cycle, when thought of in the context of accounting are _____________________.

  1. Data capturing, Source documents, Data storage, Generating and Input of data.

  2. Source documents, Input of data, Data storage, Manipulation of data and Output of data.

  3. Source documents, Data capturing, Collecting, Manipulation of data and Interpreting.

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data processing cycle, when thought of in the context of accounting, requires a series of steps that are source documents, input of data, data storage, manipulation of data and output of data.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

Accounting transactions of an organisation are documented using a _________.

  1. Bill

  2. Invoice

  3. Voucher

  4. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The first step to capture accounting data from transaction(s) so as to prepare a document, is called voucher that expresses and document an accounting transaction.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

Which one of the following is a DataBase Management System?

  1. MS Access

  2. MS Excel

  3. MS Outlook

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. 

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

Which of the following has RDBMS?
i. Access
ii. Excel

  1. (i) and (ii)

  2. Only (i)

  3. Only (ii)

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Microsoft  Excel and Access are Microsoft's two different application software. They both handle tabular data, but there are still many differences between them. Excel is a spreadsheet application program, but Access is a database program. 

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

A representational data model through which ER design is transformed into inter-related data tables along with the restriction of rules specified to ensure the consistency and integrity of stored data is _________.

  1. Reality

  2. Relational Data Model

  3. ER design

  4. Refinement
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Relational Data Model is a representational data model through which ER design is transformed into inter-related data tables along with the restriction on the form of rules specified to ensure the consistency and integrity of stored data.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

To manage a business well is to manage it's future and to manage the future is to manage information is termed as____________.

  1. Management information system

  2. Marketing information system

  3. Future information system

  4. General information system
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

MIS is the acronym for Management Information Systems. In a nutshell, MIS is a collection of systems, hardware, procedures and people that all work together to process, store, and produce information that is useful to the organization.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

The process of designing a database for accounting is best described through a ________.

  1. Tree diagram

  2. Flow chart

  3. Pictorial presentation

  4. None of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The process of designing a database for accounting is best described through a flow chart.

 A flowchart can also be defined as a diagrammatic representation of an algorithm, a step-by-step approach to solving a task.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

_____________ is a formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality.

  1. ER Design

  2. Relational Data Model

  3. Reality

  4. Refinement
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality is known as ER Design.