Amity Campus
Uttar Pradesh
India 201303
ASSIGNMENTS
PROGRAM: BSc IT
SEMESTER-II
Subject Name
Study COUNTRY
Roll Number (Reg.No.)
Student Name
:
:
:
:
INSTRUCTIONS
a) Students are required to submit all three assignment sets.
ASSIGNMENT
Assignment A
Assignment B
Assignment C
DETAILS
Five Subjective Questions
Three Subjective Questions + Case Study
Objective or one line Questions
MARKS
10
10
10
b) Total weightage given to these assignments is 30%. OR 30 Marks
c) All assignments are to be completed as typed in word/pdf.
d) All questions are required to be attempted.
e) All the three assignments are to be completed by due dates and need to be submitted for evaluation by Amity University.
f) The students have to attached a scan signature in the form.
Signature :
Date
:
_________________________________
_________________________________
Page 1
Business System
( √ ) Tick mark in front of the assignments submitted
Assignment
Assignment ‘B’
Assignment ‘C’
‘A’
Assignment A
Q1 What are the two standard methods used in data processing systems for organizing data? Explain their relative advantages and disadvantages.
Q2 Explain relational database and advantages of relational database. Explain different types of relationship.
Q3 a) Give any four- application areas of databases
b) What is business computing? What role does the database play in business computing?
.
Q4 a) Write short notes on:
i)
Inventory Control System ii) Payroll System
b) Differentiate between Master file and Transaction File (With examples)
Q5 a) Write a program to find the factorial of a number
b) Write a program to print the Fibonacci series
0 1 1 2 3 5 8-------20
Q6 Write the output for the following:
(i) What will be the result of the following commands?
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