image

Solution of Assignment Synopsis & Project Dissertation Report


Note: ⇩    Fill the Name, Email and Mobile to get unlock the priclist...!!!!

PRODUCT DETAILS

Online-Typing-and-Filling

Title Name Amity Solved Assignment B.SC IT 2nd Sem for Business Systems
University AMITY
Service Type Assignment
Course B.Sc-(IT)
Semester Semester-II Course: B.Sc-(IT)
Short Name or Subject Code Business Systems
Commerce line item Type Semester-II Course: B.Sc-(IT)
Product Assignment of B.Sc-(IT) Semester-II (AMITY)
Price

PRICE INR

Click to View Price

Solved Assignment


  Questions :-

                                                                                                                                         SUB- Business Systems

Assignment A

  1. What are Visual Basic forms? List out the features that may be incorporated into form to facilitate easier data entry.
  2. How sequential files are different from Indexed files?
  3. Write the output for the following:

    (i) What will be the result of the following commands?

    1. a) BETWEEN(5,10,20) displays

    b)?MOD(8,3) displays

    ii) What is the difference between a keyword and a variable? Can keywords be used as variables? Which of these are valid variable names? Why / why not?
  4. a) Write a program to find the factorial of a number.

 b) Write a program to print the Fibonacci series

5. a) Write short notes on:

 b) Differentiate between Master file and Transaction File (With examples)

6. a) Give any four- application areas of databases.

 b) What is business computing? What role does the database play in business computing?

7. Explain relational database and advantages of relational database. Explain different types of relationship

8. What are the two standard methods used in data processing systems for organizing data? Explain their relative advantages and disadvantages.

 

Assignment B

  1. Explain the following:

i) SUBSTRING() function

ii) TRIM() function

iii) DATE () function

iv) CEIL() function

v) FLOOR() function

2. Difference between

i) Edit and Change

ii) Zap and Pack

iii) Delete and Recall

iv) Display and List

v) Sort and Index

3. A database table called PERSON contains the fields NAME, BASIC and HRA. Write a computer program to print a report with employee name and total salary for those employees whose total salary is more than 10,000. Total Salary = BASIC + HRA. At the end, the program should also print the total number of employees whose total salary is more than 10,000.

 

 

 

Assignment C

Question No: 1

In the data processing system, if the input data are processed, as the transaction occurs, it is called

  1. a) Parallel Processing
  2. b) Real Time Processing
  3. c) Batch Processing
  4. d) Virtual Processing

 

 

Question No: 2

A file management system can typically access records from

  1. a) Only one files at a time
  2. b) Many files at a time
  3. c) Only two files at a time
  4. d) None of the above

 

 

Question No: 3

Which A sequential file organization is most suited for

  1. a) Airline Reservation system
  2. b) A library
  3. c) A Payroll system
  4. d) None of the above

 

 

Question No: 4

A suite of programs that handle an organization’s database responsibilities is called a

  1. a) DBMS
  2. b) Database Processing System(DBPS)
  3. c) DMS
  4. d) All of the above

 

 

Question No: 5

Coding and Testing are carried out

  1. a) Top down
  2. b) Bottom up
  3. c) Ad hoc
  4. d) None of the above

 

 

Question No: 6

The operation carried out on an input data for examining its acceptability is termed

  1. a) Validation
  2. b) Verification
  3. c) Moderation
  4. d) None of the above

 

 

Question No: 7

A program is made up of

  1. a) Constants
  2. b) Buffers
  3. c) Instructions
  4. d) All of the above

 

 

Question No: 8

Which of the following is a flowchart symbol?

  1. a) Decision
  2. b) Flow Lines
  3. c) Both a and b
  4. d) None of the above

 

 

Question No: 9

Which of the following is a valid command?

  1. a) INPUT “enter your name” Name
  2. b) INPUT “enter your name”, Name
  3. c) INPUT “enter your name” Get Name
  4. d) INPUT enter your name to Name

 

 

Question No: 10

IN which of the following cases, the output will be 220?

  1. a) ?ROUND(219.89,0)
  2. b) ?CEILING(219.89,0)
  3. c) Both a and b
  4. d) None

 

 

Question No: 11

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

  1. a) Material issue file
  2. b) Material reciept file
  3. c) Purchase orders file
  4. d) All of the above

 

 

Question No: 12

Which of the following is true about a disk file where WRITE statement will always place a record in the next physical position?

  1. a) Sequential file
  2. b) Relative file
  3. c) Indexed file
  4. d) None of the above

 

 

Question No: 13

The command used to add a new field to an active table file is

  1. a) Modify command
  2. b) Modify Structure
  3. c) Both a and b
  4. d) None of the above

 

 

Question No: 14

A field that uniquely identifies records in the table wizard is known as

  1. a) Primary Key
  2. b) Special Key
  3. c) Unique Key
  4. d) None of the above

 

 

Question No: 15

To remove all records from the current table, the most appropriate command is

  1. a) Pack
  2. b) Delete all
  3. c) Zap all
  4. d) delete file

 

 

Question No: 16

The purpose of EXIT command is to

  1. a) Get out of condition loop
  2. b) Get out of Fox Pro
  3. c) Transfer the control to a different procedure
  4. d) None of the above

 

 

Question No: 17

The lowest level of management concerns with

  1. a) Operational information
  2. b) tactical information
  3. c) long term planning
  4. d) Strategic information

 

 

Question No: 18

Which of the following is an invalid command in DBMS package?

  1. a) RUN
  2. b) CLEAR
  3. c) REPLACE
  4. d) None

 

 

Question No: 19

A typical commercial application file would have

  1. a) A master file and a transaction file
  2. b) A master file but may not have a transaction file
  3. c) A transaction file but may not have a master file
  4. d) None of the above

 

 

Question No: 20

Which of the following appropriately explains the desirable characterstic of good system design

  1. Modular approach
  2. Proper documentation
  3. Either a and b
  4. Both a and b

 

 

Question No: 21

A flowchart is a

  1. a) Method of programming
  2. b) Usually difficult to understand
  3. c) A method of displaying the solution to a problem in simple steps
  4. d) None of the above

 

 

Question No: 22

The Modify command is use to

  1. a) Modify Label
  2. b) Modify Command
  3. c) Modify Structure
  4. d) Modify Report

 

 

Question No: 23

The function to remove the leading and trailing spaces from a character expression is

  1. a) TRIM()
  2. b) LTRIM()
  3. c) RTRIM()
  4. d) ALLTRIM()

 

 

Question No: 24

The command CLEAR will

  1. a) Close all open databases
  2. b) Release all memory variables
  3. c) Erase the screen contents and reposition the cursor to the upper left corner
  4. d) All of the above

 

 

Question No: 25

Trial Balance is a term used in

  1. a) Payroll
  2. b) Inventory Control
  3. c) Financial Accounting
  4. d) Sales Management

 

 

Question No: 26

The ??? indicates

  1. a) Print text to output screen
  2. b) print text directly to printer
  3. c) Comment
  4. d) Logical operation

 

 

Question No: 27

Input: A=”11/05/1983” Choose the right function to get Output: 198

  1. a) ?SUBSTR(A,7,2)
  2. b) ?STUFF(A,7,3)
  3. c) ?SUBSTR(A,8,3)
  4. d) ?SUBSTR(A,7,3)

 

 

Question No: 28

Decision Table is a

  1. a) Tabular representation of a program logic
  2. b) Symbolic representation of a program logic
  3. c) Graphical representation of a program logic
  4. d) All of the above

 

 

Question No: 29

The command to create a new database file based on two open database files is

  1. a) SET RELATION
  2. b) UPDATE
  3. c) JOIN
  4. d) None of the above

 

 

Question No: 30

Edit Checks and Controls are built into a computer based system to

  1. a) Ensure that transcription errors do not corrupt the result
  2. b) Duplicate date does not enter into the computer system
  3. c) Avoid transposition errors
  4. d) All of the above

 

 

Question No: 31

Which one is not a function of Management?

  1. a) Staffing
  2. b) Controlling
  3. c) Planning
  4. d) Co-operating

 

 

Question No: 32

Which one correct for display a record with the value 2000 in the field phone and ‘false’ in the logical field paid.

  1. a) Display for phone=2000 .AND. .NOT. paid
  2. b) Display for phone=2000 AND paid =’false’
  3. c) Display for phone=2000 AND. paid=’false’
  4. d) Display for phone=2000 .AND.NOT.paid

 

 

Question No: 33

What is output of expression: A=CEILING(5.4)?

  1. a) 5
  2. b) 4
  3. c) 6
  4. d) none of the Above

 

 

Question No: 34

Identify which of the following is not a database maintenance task

  1. a) Renaming database
  2. b) Copying database
  3. c) Combining database
  4. d) Viewing database

 

 

Question No: 35

Payroll is integrated with financial accounts through

  1. a) A month and journal voucher
  2. b) Online up-dation
  3. c) Maintaining each employee record in a subsidiary ledger
  4. d) All of the above

 

 

Question No: 36

A file management system can typically access records from

  1. a) File management
  2. b) File listing
  3. c) File recovery
  4. d) Disk management

 

 

Question No: 37

The means by which an operating system or any other program interacts with the user is called.

  1. a) Only one file at a time
  2. b) Many files at a time
  3. c) Only two files at a time
  4. d) None of the above

 

 

Question No: 38

How many style options are available in Form Wizard?

  1. a) Six
  2. b) Five
  3. c) Three
  4. d) None

 

 

Question No: 39

Which one correct for display a record with the value 2000 in the field phone and ‘false’ in the logical field paid?

  1. a) Display for phone=2000 .AND. .NOT. paid
  2. b) Display for phone=2000 AND paid =’false’
  3. c) Display for phone=2000 AND. paid=’false’
  4. d) Display for phone=2000 .AND.NOT.paid

 

 

Question No: 40

The command to create a new database file based on two open database files is

  1. a) SET RELATION
  2. b) UPDATE
  3. c) JOIN
  4. d) None of the above

  Answers :-

Only after macking the payment you would be able to see the answer...!!!

Review

Average user rating

4.8 / 5

Rating breakdown

5
80% Complete (danger)
1
4
80% Complete (danger)
1
3
80% Complete (danger)
0
2
80% Complete (danger)
0
1
80% Complete (danger)
0

January 29, 2015
This was nice in buy
Assignment from solve zone is probably one of the first preference of students.

October 09, 2016
This was nice in buy
I recommend a website that was really helpful throughout your session.

March 19, 2017
Some day ago
This was nice in buy
This was good in buy . I found all the answer correct and meaningful and had scored good marks
Back to top