Code: DC-07                                                                                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 random file organisation is best suited for

(A)  Airline enquiry.                             (B)  Payroll System.

(C)   Library System.                           (D)  Hospital Information System.

b. Which of the following language uses the concept of structured programming

(A) BASIC                                        (B)  COBOL

(C)  FORTRAN                                  (D)  C

             c.   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.

             d.   In indexed sequential file organization the data is stored in the following area

(A)  Prime area.                                 (B) Overflow area.

(C)  Index area.                                  (D)  all of the above.         

             e.   The function of upper management is to :

(A) establish the policies                    

(B) make day to day, relatively structured control decisions

(C) make daily reports                       

(D) all of the above

             f.    Which of the following does not constitute a master file in a store system.

(A) Material issues file.                       (B)  Materials receipt file.

(C)  Purchase orders file.                     (D)  All of these.

g.   “Nanosecond “ is

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

(C)  10⁹                                                              (D)  10⁶

             h.   Which of the following is not the data type used in Foxpro

(A) Character                                     (B) Real

(C) Numeric                                        (D) Date

             i.    The ZAP command in Foxpro is used to

(A) to mark the records for deletion.  

(B)  to delete all the records.

(C) to undelete the selected records.   

(D) to delete the selected records only.

             j.    The clock speed of computer is measured in :

(A)  Seconds                                       (B)  Milliseconds

(C)  Megahertz                                    (D) Nanoseconds

Answer any FIVE Questions out of EIGHT Questions.

Each question carries 16 marks.

Q.2     a.   Describe functioning of management in brief. Discuss the objectives and goals of organisation in a management process.                           (7)

             b.   Define the term ‘System’? Explain briefly the characteristics of a system.             (9)

Q.3     a.   What are the tools for structured analysis? Briefly review the tools used.              (8)

             b.   What are the features of top down approach in programming? What are its advantages?                 (8)

Q.4     a.   Explain the difference between :

(i) Logical record & Physical record.

(ii) System security and System Integrity.                                     (4+4)

b.   What are the functions of Database Administrator (DBA)?                                  (8)

Q.5     a.   What are the major issues w.r.t. to Software, Hardware in distributed data processing.                   (8)

     b.   Write short notes in

(i) System Audit.

(ii) Necessity of file access controls.                                        (4x2=8)

  Q.6           Explain the difference between following terms :

(i) Schema and Sub-schema.

(ii) Entity and Attribute.

(iii) DDL & DML.                                                                               (5+5+6)

Q.7     a.   Draw a flowchart to find the greatest number from the given numbers.                 (8)

b.   Explain the use of the following functions in Foxpro with the help of an example :

(i) TRANSFORM()

(ii) SUBSTR()

(iii) LEFT()

(iv) MAX()                                                                                                  (8)

Q.8           Write a program in Foxpro to calculate the Net Salary and display the salary slip of the employees. The following details are given :

Employee Code                        Numeric                       3

                        Employee Name                       Character                     7

                        Basic Salary                             Numeric                       5

                        Allowances

                        DA.=   60% of Basic Salary

                        HRA    =15 % of Basic Salary

                        Deductions

                        PF        = 20% of Basic Salary

                       Net Salary = Basic Salary +Allowances – Deductions                                  (16)

Q.9     a.   Define the following terms:

(i) Backup

(ii) Confidentiality.

(iii) Privacy.

(iv) Flow chart.                                                                                    (4x2=8)

b.   What are the major objectives for implementing a computerized inventory control in an organization?                                                                      (8)