Code: 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 best alternative in the following:                                         (2x10)

a. Information is

(A) data.             

(B) processed data.

(C) raw data.

(D) none of these.

b. A flow chart is

(A) a set of logical steps to solve a problem.         

(B) a pictorial representation of an algorithm.

(C) a set of statements.

(D) none of these.

             c.   DBMS stands for

(A) Data Business Manipulation System.  

(B) Data Base Management System.

(C) Data Box Managements System   .

(D) Direct Business Managements System.

             d.   The expansion of ATM is

(A)  Automated Task Machine.          (B)  Automatic Technique Machine.

(C)  Automatic Teller Method.            (D)  Automatic Teller Machine.     

             e.   The software required to run a computer is

(A) system software.

(B) application software.

(C) package.

(D) batch software.

             f.    Nanoseconds is

(A) 10^-9 (B) 10^-6

(C)  10⁹ (D) 10⁶

g.   A pseudo code is

(A) a machine level code.                   (B) one of encoding scheme.

(C) a random number.                         (D) a password.

             h.   The operation carried out on an input data for checking its correctness and acceptability is termed as

(A) validation.                                     (B)  verification.

(C) modification.                                  (D)  none of these.

             i.    The command use to close the data base file is:-

(A) quit data base                               (B)  close file

(C) quit file                                          (D)  close database

             j.    The command which clears the data from the screen is

(A) CLOSE                                       (B)  CLEAR

(C)  DELETE                                      (D)  None of these

Answer any FIVE Questions out of EIGHT Questions.

Each question carries 16 marks.

Q.2     a.   Define Data Gathering. Briefly explain specific aspects of system Analysis.                          (6)

b. Briefly explain the important steps for selecting a Computer system for a medium scale business organization. (6)

             c.   Distinguish between System Analysis, System Design and System Implementation.              (4)

Q.3     a.   Briefly explain Broad categories of data files used in any Information System.                      (6)

             b.   Differentiate between Sequential Access File Organization and Direct or Random Access File Organization.                                                                                                                         (6)          

c.   Briefly explain

(i) Backup Files

(ii) File Security                                                                               (4)

Q.4     a.   Explain different types of programming operations or functions that a computer performs.                (4)

b.   What are the various advantages and disadvantages of low level and high level languages?               (6)

             c.   Discuss the various advantages and disadvantages of DBMS.                             (6)

Q.5     a.   What are the various advantages and limitations of using Flowcharts?                  (4)

     b.   Draw flowchart to print Simple Interest for 5,6,7,8,9 Years at the rate of 6% for annum on investment of Rs. 20,000/-.                                             (6)

     c.   Specify the important features of FoxPro Report.                                                (6)

  Q.6     a. Briefly explain the following FoxPro Commands:-                                                   

(i)    Append                                        (ii)  Create

                   (iii)  Default drive                                 (iv) List

                   (v)   Index                                           (vi) Sort                                                  (6)

b. Name the various types of Index Files supported by FoxPro and briefly explain two types.             (6)

             c.   Create a keyboard macro to enter your name. Assign this macro to Alt +j. Verify it on a database file?                                                                  (4)

Q.7     a.   Briefly explain following mathematical function:-

(i)   SQRT ()                                       (ii)   ABS ()

                   (iii) ROUND ()                                    (iv)  MIN ()                                            (4)

b.   List the various steps in creating a FoxPro program file and how do we run this File.                       (6)

             c.   How two database files can be joined to create a new database file? Briefly explain the process of joining?                                                            (6)

Q.8     a.   How do we design a custom screen with CREATE SCREEN command?           (4)

             b.   What do you mean by “RQBE” window? Write steps to open RQBE window.                  (6)

c.   Briefly explain coding the programme. (6)

Q.9          a.                                                                                                                                       What do you mean by financial accounting? How would you computerize this problem?           (6)

             b.   What are the essential features of an E.D.P. Department in the organisation?                       (4)

c.   Write Short Note

(i) Auditing of Computer System.

(ii) Data Validation.                                                                             (6)