Code-DC17                             Subject: MANAGEMENT INFORMATION SYSTEMS

Time: 3Hr.                                                                                                 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 command that lets you change one of more fields in a record is

(A)  Insert                                            (B)  Modify

(C)  Look-up                                       (D)  None of the above

      b.   A Database Management system

(A) allows simultaneous access to multiple files.                                   

(B) can do more than a record management system.

(C) is a collection of programs for managing data in a single file.           

(D) Both (A) and (B) above.

      c.   Data security threats include

(A)  privacy invasion.                            (B)  hardware failure.

(C)  fraudulent manipulation of data.      (D)  All the above.

      d.   A decision table is

(A) a way to get an accurate picture of the system.                  

(B) a way of representing the information flow.

(C) a way of representing multiple conditions.              

(D) all of the above.    

      e.   The starting point for development of an MIS is

(A)  identification of business processes that are the essence of business.

(B)  a distributed database management.

(C)  the system has large number of PC’s and a LAN.

(D)  purchase of mini computers.

      f.    Which of the following tools is not used in modeling the new system

(A)  decision tables                               (B)  data dictionary

(C)  data flow diagrams                        (D)  all of the above

      g.   Data integrity refers to the

(A)  simplicity of data                            (B)  privacy of data

(C)  validity of data                               (D)  security of data

      h.   Quantitative techniques used to solve business problems are called

(A)  operations management.                (B)  operations science.

(C)  operations research.                      (D)  management operations.

      i.    Benefits from a computerized MIS include

(A) higher returns on short term investments.                                       

(B) less frequent and smaller short term loans.

(C) lower rates of interest.                              

(D) all of the above.

      j.    The major responsibilities of the database administrator are all of the following except

(A)  analyzing application system.          (B)  advising programmers.

(C)  designing database.                        (D)  developing data dictionaries.

Answer any FIVE questions out of EIGHT questions

Each question carries 16 marks

Q.2     a.   Discuss the three primary levels of decisions in business  list the examples of functional areas in business where in such decision are required to be taken.                                                                 (8)

             b.   What is the purpose of re-engineering?                                                                    (4)

             c.    List the basic advantages of specialization and division of labor in manufacturing.       (4)

Q.3     a.    Differentiate DBMS and RDBMS and explain advantages of DBMS.                       (8)

             b.   How do you perform computations with SQL and QBE?                                         (8)

Q.4     a.    What is meant by work group integration?  Explain key components of groupware.  (6)

             b.   What are the limitations of GDSS?                                                                           (6)

c.    Discuss the limitations of data warehouse.                                                                (4)

Q.5     a.    List the major steps involved in building or using a model to solve a problem.            (8)

             b.   Explain the limitations of expert systems.                                                                  (8)

Q.6     a.    What are switching costs?  Explain how can they give a company a competitive advantage. (8)

             b.   What are enternal agents?                                                                                        (8)

Q.7     a.    What is the need of system development life cycle?                                                  (8)

             b.   Write strengths and weakness of SDLC?                                                                 (8)

Q.8     a.    Write about Event-Driven systems?                                                                         (8)

             b.   Explain potential advantages of outsourcing computer facilities?                                (8)

Q.9     a.    Define centralization and decentralization?  Explain what are the advantages of centralizing computer software.                                                                                                                               (8)

b.   Write about computer security controls?                                                                  (4)

c.    Discuss the various objects that are used to create data flow diagrams.                     (4)