DATA PROCESSING SYSTEM
Time allowed: 3 Hours
Max. Marks: 90
ATTEMPT FIVE QUESTIONS IN ALL,SELECTING TWO QUESTIONS EACH FROM SECTION - A AND SECTION – B .SECTION C IS COMPULSORY.
SECTION - A
1. (a) Discuss the relationship, if any, among characters, records, data-items, files and databases with the help of an example. (4)
(b) Explain the differences between business and scientific data processing in brief. (4)
(c) Explain the characteristics of software requirements specifications. Also explain its role in the software development cycle. (10)
2. (a) What is data dictionary? What is dat6a floe diagram? Explain with the example. (8)
(b) Discuss the various activities at the design phase in detail.
3. (a) Why do we test system? How important is testing? A variety of tests are used to test systems. Discuss these tests in brief. (10)
(b) What do you mean by software maintenance? Explain the different types of software maintenance in detail.(8)
4. Write short note on following:
(a) Various methods of software implementation
(b) Integrated Case Tools
(c) Characteristics of a good programming
(d) Debugging.
SECTION – B
5. What do you understand by MIS? Explain the structure and classification of MIS. Also explain the role and importance of MIS in management function and decision making in any organization. (18)
6. (a) Explain the three schema architecture of a DBMS wit6h the help of diagram. Why do need mappings between the different schema levels? Also explain the advantages and disadvantages of DBMS. (12)
(b) What is RDBMS? Why relational data model is better than other data Models? Explain. (6)
7. (a) What is Normalization? Explain all types of normal forms with the help of suitable examples. (10)
(b) What do you mean by E-R diagram? Draw an E-R diagram by taking your own example (8)
8.(a) Explain the various data types in FoxPro with example.(6)
(b) Explain the various facilities available in FoxPro with examples for querying a database. (6)
(c) Define Table and Indexes with examples in FoxPro. (6)
SECTION – C (COMPULSORY QUESTION)
9. Explain the following in brief: (18)
(a) Various data processing operations.
(b) Compilers ,Linkers and Editors
(c) Responsibilities of DBA.
(d) Difference between Top down and Bottom up approach of designing a software.
(e) Full/partial/transitive dependencies
(f) Difference between logical and physical data independence
(g) Editing a database in FoxPro.
(h) What is Data Redundancy?
(i) Documentation tools.
Time allowed: 3 Hours
Max. Marks: 90
ATTEMPT FIVE QUESTIONS IN ALL,SELECTING TWO QUESTIONS EACH FROM SECTION - A AND SECTION – B .SECTION C IS COMPULSORY.
SECTION - A
1. (a) Discuss the relationship, if any, among characters, records, data-items, files and databases with the help of an example. (4)
(b) Explain the differences between business and scientific data processing in brief. (4)
(c) Explain the characteristics of software requirements specifications. Also explain its role in the software development cycle. (10)
2. (a) What is data dictionary? What is dat6a floe diagram? Explain with the example. (8)
(b) Discuss the various activities at the design phase in detail.
3. (a) Why do we test system? How important is testing? A variety of tests are used to test systems. Discuss these tests in brief. (10)
(b) What do you mean by software maintenance? Explain the different types of software maintenance in detail.(8)
4. Write short note on following:
(a) Various methods of software implementation
(b) Integrated Case Tools
(c) Characteristics of a good programming
(d) Debugging.
SECTION – B
5. What do you understand by MIS? Explain the structure and classification of MIS. Also explain the role and importance of MIS in management function and decision making in any organization. (18)
6. (a) Explain the three schema architecture of a DBMS wit6h the help of diagram. Why do need mappings between the different schema levels? Also explain the advantages and disadvantages of DBMS. (12)
(b) What is RDBMS? Why relational data model is better than other data Models? Explain. (6)
7. (a) What is Normalization? Explain all types of normal forms with the help of suitable examples. (10)
(b) What do you mean by E-R diagram? Draw an E-R diagram by taking your own example (8)
8.(a) Explain the various data types in FoxPro with example.(6)
(b) Explain the various facilities available in FoxPro with examples for querying a database. (6)
(c) Define Table and Indexes with examples in FoxPro. (6)
SECTION – C (COMPULSORY QUESTION)
9. Explain the following in brief: (18)
(a) Various data processing operations.
(b) Compilers ,Linkers and Editors
(c) Responsibilities of DBA.
(d) Difference between Top down and Bottom up approach of designing a software.
(e) Full/partial/transitive dependencies
(f) Difference between logical and physical data independence
(g) Editing a database in FoxPro.
(h) What is Data Redundancy?
(i) Documentation tools.
Hey!Nice to meet you!Make my friend
ReplyDelete