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. A group of related data fields is called

(A) data record                                    (B) data base

(C) data file                                          (D) MIS

b. A program is made up of

(A) Constants                                     

(B) Buffers

(C) Instructions                                   

(D) All of the above

             c.   Combining two or more files into a single file so that the resultant file is in the sequence is called

(A) sorting.                                        

(B) merging.

(C) indexing.                                      

(D) summarizing.

             d.   Managers at lower operating levels need information to

(A) support policy decisions.               

(B) to make day to day operating decisions.

(C) support long range planning decisions. 

(D) to take strategic decisions.

             e.   An algorithm is

                   (A) a pictorial representation of program.  

                   (B) a set of logical step to solve the problem.

                   (C) set of instructions.

                   (D) All of the above

             f.    A sequential file organization is most suited for

                   (A) Examination processing                 

(B) Railway reservation system

(C) A bank                                         

(D) A library

             g.   Structured approach to programming is

(A) Top down                                    

(B) One entry – one exit.

(C) Dividing the program into subprogram 

(D) All of the above

             h.   Which of the following is not the data type of FoxPro?

(A) Character                                      (B) Numeric

(C) String                                            (D) Date

             i.    While using RQBE, you can view the SQL SELECT command before executing the query.

(A) True                                              (B) False

             j.    FoxPro can automatically detect error conditions in a program when you save it.

(A) True                                              (B) False

Answer any FIVE Questions out of EIGHT Questions.

Each question carries 16 marks.

  Q.2     a.   Define Data, Information and Data Processing.                                                  (4)

             b.   List and briefly explain the criteria used in deciding whether or not a particular application is suitable for computer processing.                           (6)

             c.   Discuss briefly the various tools and techniques used in system analysis and design.             (6)

Q.3     a.   What are data files? Explain the terms record, field and character in the content of data file.             (4)

             b.   Discuss briefly the various file organization methods that are commonly used in business data processing applications.                                        (6)

             c.   Briefly explain following.                                                                                     (6)

                   (i) Master File                                      (ii) File Security

                   (iii) File Updation                                                                                                   

Q.4     a.   Distinguish Data Base Management System from File Management System.                        (6)

             b.   Define and distinguish between application software and system software.           (5)

             c.   Discuss, in brief, the following terms with reference to computer system and data processing system:          

                   (i) Compiler                                        

                   (ii) Machine Language                                                                                        (5)

Q.5     a.   What do you mean by flow chart? Briefly discuss the different types of flowcharts.              (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.   Discuss briefly the various commands in FoxPro you can use to list

                   (i) database files                                  

                   (ii) other files.                                                                                                    (4)

             b.   What is Indexing? How FoxPro supports Indexing techniques? Explain with a suitable example.                  (6)

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

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

             b.   Briefly explain the following mathematical functions with suitable example.                          (6)

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

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

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

             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.   Write the concept of multiple database file in FoxPro. How multiple database files are opened? Explain using suitable example.                                 (6)

             c.   What do you mean by custom screen in FoxPro? How you will design it using command @?                                                                     (6)

  Q.9     a.   List the functions of Database Administrator (DBA).                                           (4)

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

             c.   Write short notes on:

                   (i) System Audit                                   (ii) Computer Security                            (6)