Business Data Processing 2023-BSc Computer Science Part 2

Total No. of Questions: 10] [Total No. of Printed Pages: 3

Paper code: 13517
1517
B.Sc. (Part-II) Examination, 2023
COMPUTER SCIENCE
Paper No. 3.2
(BUSINESS DATA PROCESSING)

Time: Three Hours] [Maximum Marks: 33

Note: Attempt all sections as directed.

Section-A

1. What do you mean by marketing personnel & finance? Discuss its various aspects in detail.

2. Define the term cost benefit analysis. What annual rate of return is earned on a Rs. 5,00,000 investment when it grow to Rs. 9,75,000 in four year.

Section-B

3. What are the different data types in the COBOL language? What is 15 numeric clause?

4. How the sorting achieved in COBOL program. How can we process two files by comparing key fields?

Section-C

5. What are the object oriented features provided in COBOL? Discuss each with example.

6. Write a COBOL program that allow users to enter the names of students of a class and then display it. Use OCCURS clause to implement it.

Section-D

7. Consider the following database and answer the given question. Primary key is denoted by underline works (person-name, company name, salary) Employee (Person-name, Street, City) company (Company-name, City) construct a Relational database for a car-insurance company whose customer own one or more each each. Each can has associated with it zero to any number of record accident.

8. What are the data models in Database? Differentiate between E.R. Model and Relational model with the help of example.

Section-E

9. What do you mean by SQL? Write some commands of the following SQL language.

(a) DDL

(b) DML

(c) DCL

(d) TCL

10. Write short note on any two :

        (a) Data Recovery

        (b) Hashing

        (c) Searching Techniques

        (d) Addressing Techniques

……End……

Thank You 🙂