DipIETE – CS (OLD SCHEME)

 

Flowchart: Alternate Process: JUNE 2009Code: DC07                                                                                 Subject: BUSINESS SYSTEMS

Time: 3 Hours                                                                                                     Max. Marks: 100

 

NOTE: There are 9 Questions in all.

·      Question 1 is compulsory and carries 20 marks. Answer to Q. 1. must be written in the space provided for it in the answer book supplied and nowhere else.

·      Out of the remaining EIGHT Questions answer any FIVE Questions. Each question carries 16 marks.

·      Any required data not explicitly given, may be suitably assumed and stated.

 

 

Q.1       Choose the correct or the best alternative in the following:                                  (210)

                

a.           ASCII is known as

 

(A) American National Standard Code for Information Interchange

(B) American Notation Standard Code for International Information

(C) American Standard Code of Interactive Information   

(D) All Standard Code for Information Interchange

                                                          

b.      A device, such as VDU, which is linked to the computer and does not incorporate any of its own processing capability is known as

 

(A) Main Frame computer                   (B) Dumb-Terminal

(C) Microprocessor                            (D) Super computer

 

             c.   Operating System is a kind of

                                    

(A)    Application Software                    (B) Firmware

(C) Utility Program                              (D) System Software

 

             d.   A computer programming language designed to facilitate the output of reports of business data is known as

 

(A)    RPG                                           (B)  FORTRAN

(C)  COBOL                                      (D)  JAVA

      

             e.   Typing mistake done by programmer is a kind of

                                      

(A)     Syntax error                                 (B) Semantic error

(C)  Logical error                                (D) Exception

 

             f.    Term DBA in database is known as

 

(A)     Data Base Assistant                     (B) Data Basis Associate

(C)  Data Base Administrator               (D) Dynamic Base Arrangement

 

             g.   Command used to add new records after the last record in the current database file is

 

(A)     ALTER                                        (B) APPEND

(C)  MODIFICATION                       (D) ADDITION

 

             h.   In FoxPro commands FLOOR(189.99) and CEILING(189.99) will returns

 

(A)    189 and 190                                (B)  190 and 190

(C)  189 and 189                                (D)  190 and 189

 

             i.    RQBE saves the query in a file. This file is given an extension name

 

(A)   RQB                                           (B)  RQBE

(C)  QPR                                            (D)  PRQ

 

             j.    A person who defines problems and develops algorithms and procedures for their solutions on a computer is known as

 

(A)    Tester                                          (B)  Programmer

(C)  Data Processing Operator            (D)  Analyst

 

 

Answer any FIVE Questions out of EIGHT Questions.

Each question carries 16 marks.

 

 

  Q.2     a.   Define the terms data, data structure and database.                                            (4)

 

             b.   What are the advantages of processing data of a business enterprise by using computer?     (6)                   

 

             c.   Discuss the advantages of application of computers for data processing in Accounting.                    (6)

                                                                                                                                                           

  Q.3     a.   What do you mean by terms System, System Model and System Analysis?         (4)

 

b.      Differentiate between Sequential and Indexed sequential file organization.            (6)          

 

c.       Briefly explain following                                                                                      (6)                                  

(i)                        Master File

(ii)                      File Security

(iii)                     File Updation 

 

  Q.4     a.   Distinguish between the following:

                   (i)   System Software and Application Software.

                   (ii)  Compiler and Interpreter.                                                                         (4+4)

 

b.   What are the main functions of Database Management System (DBMS)? How will you differentiate it from File Management System?                   (8)

 

  Q.5     a.   What do you mean by flow chart? Briefly discuss the different types of flowchart.               (4)

 

             b.   Draw the flow chart for the sum of squares of first 20 odd numbers. Odd numbers are numbers which are not divisible by 2.                                 (6)

 

             c.   Draw a flowchart for finding the minimum number and maximum number among given three number (X1, X2, and X3) and store them in variable ‘L’ and ‘H’ respectively.                                               (6)

 

  Q.6     a.   What is FoxPro? Name the two versions of FoxPro for the DOS environment.                   (4)

 

b.   What do you mean by Sorting and Indexing? Briefly explain the SORT and INDEX command in FoxPro using suitable example.                         (6)

 

c.   Explain the FoxPro report generation steps with suitable example.                       (6)

 

  Q.7     a.   Write steps to create a keyboard macro to enter “TARA” using “Ctrl + T”.         (4)  

 

             b.   Briefly explain the following mathematical function with suitable example.

                   (i)   SQRT( )                                       (ii)   INT( )

                   (iii) MAX( )                                         (iv)  MOD( )

                   (v)  EXP( )                                          (vi)  LEN( )                                            (6)

 

             c.   Explain the difference between SCATTER and GATHER command in FoxPro using suitable example.                                                                  (6)                                                             

 

  Q.8     a.   What is a Program file in FoxPro? Discuss its advantages.                                   (4)

 

             b.   How linking of databases is possible with SET RELATION in FoxPro? Use suitable example.                                                                   (6)

             c.  Write the purposes of @ command in FoxPro with an example.                           (6)

  Q.9          a.                                                                                                                                       Discuss in brief the term System Documentation?                                                                        (4)

             b.   Explain why Input Controls are essential in an E.D.P. system? Give three examples of input controls.                                                                      (6)

 

             c.   What is System Audit? Write the objectives of auditing a computerized system.                  (6)