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. What do you mean by RAID related to file systems?

(A) Random Access Integrated Disks

(B) Redundant Arrays of Inexpensive Disks

(C) Recent Advances in Intrusion Detection

(D) Read array integrated Disk.

b. Which one of the following functional business systems supports the production/operations business function?

(A) Compensation analysis.                  (B) Process control.

(C) Cash management.                        (D) Sales force automation

             c.   What type of errors are undetected by trial balance in financial accounting?

(A)  Errors of omission                       (B)  Errors of principle

(C)  Compensating errors                    (D) All of the above

             d.   The equation used to calculate unused space in each block is Block Size is B Bytes, bfr=blocking factor and R is Fixed Length records

(A)  B-(bfr* R)                                  (B)  B+(bfr- R)

(C)  (bfr* R)-B                                   (D)  (bfr- R)*B     

             e.   STRTRAN(<text>, <a>, <b>) command is used in FOXPRO for

(A) replace characters from position with the character

(B) replace every occurrence

(C) return a text holding the contents of the file named

(D) return the leftmost character

             f.    FOXPRO was developed by

(A) Microsoft                                     (B) Princeton

(C) IBM                                              (D) Stanford University

             g.   RECNO(),USED(<name>), TAGCOUNT(),ALIAS() are

(A) Date Functions                             (B) Creating Functions

(C) Table Functions                             (D) Calculate Functions

             h.   Assembler Creates

(A) byte code                                     (B)  opcode

(C) object code                                   (D)  executable

             i.    Which is a Public Key Encryption System

(A) RSA System                                 (B)  DES Algorithm

(C) Transposition System                     (D)  Substitution System

             j.    Which one of the following functional business systems supports the production/operations business function?

(A) Compensation analysis                  (B)  Process control

(C)  Cash management                        (D)  Sales force automation           

Answer any FIVE Questions out of EIGHT Questions.

Each question carries 16 marks.

Q.2     a.   Explain four low level commands in file handling in Foxpro.                                (8)

b. In a company an employee is paid as under:

                   If his/her basic salary is less than Rs.1500, then HRA=10% of basic salary and DA=90% of basic. If his/her salary is either equal to or above Rs.1500, then HRA= Rs.500 and DA=98%. If the employee’s salary is input through the keyboard draw the DFD to find the gross salary(BS+HRA+DA)  (8)

Q.3     a.   What is MIS? What are the roles of MIS in organizations?                                  (8)

             b.   Discuss the importance of project documentation.                                               (8)          

Q.4     a.   Define the following terms

(i)     CASE tools

(ii) Disaster recovery

(iii) Database Normalization

(iv)   Entity Relation Diagram                                                                             (8)

b.    Write an algorithm to swap two variables without using third variable.                 (8)

Q.5     a.   Explain the following function in Foxpro with the help of an example:

(i) FCOUNT( )

(ii) BITLSHIFT( )

(iii) DOW( )

(iv)    LTRIM( ) (8)

     b.   Explain and Identify the major activities of transaction processing cycle.               (8)

  Q.6     a. What are tangible and intangible benefits of computer based information systems.                (8)

b. Explain typical prototyping based systems development process in business.                       (8)

Q.7     a.   What are major implementations activities to deploy newly developed system? Explain each activity in detail.                                                           (8)

b.   What steps are needed to produce an ad hoc report?                                         (8)

Q.8     a.   Discuss RQBE strengths and weaknesses.                                                          (8)

             b.   What is the difference between technical and end user documentation?                (8)

Q.9     a.  In the following samples I assume that the user name is stored in lcUser and the password in lcPassword. A typical password validation could look like this:

* ASSUME: We located the correct record in USER.DBF

IF NOT ALLTRIM(User.cPassword) == m.lcPassword
* invalid password

ELSE
* password is OK

ENDIF

what happens if lcPassword is NULL? How do I handle it. (8)

             b.  Explain Computer based Financial Information System? What are the various financial information systems?                                                           (8)