NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level

Introduction to Database Management System

Assignment 2

Create an E R diagram and relational schema to hold information about the situation inmany institutions affiliated to some University, many teachers of different disciplines areteaching to many students enrolled in many courses offered by the university to thestudents through the institutions. Use concept of keys, aggregation, generalisation,cardinality etc. in a proper way.Say the schema of respective entities is:Teacher( T#, Tname, Tqual, Tsubject, Tcourse, Prog)

NIELIT A Level Introduction to Database Management System Assignment

NIELIT A Level

Introduction to Database Management System

Assignment 1

The following tables form part of a database held in a relational DBMS:

•  Hotel (Hotel_No , Name, Address) 
• Room (Room_No, Hotel_No, Type, Price)
•  Booking (Hotel_No, Guest_No, Date_From, Date_To, Room_No) 
• Guest (Guest_No, Name, Address) 

where Hotel contains hotel details and Hotel_No is the primary key. Room contains room details for each hotel and (Hotel_No, Room_No) forms the primary key. Booking contains details of the bookings and the primary key comprises (Hotel_No, Guest_No, Date From) and Guest contains guest details and Guest_No is the primary key.

Syllabus A7-R4 Introduction to Database Management System (NIELIT A Level)

Objective of the Course

This course will allow students to develop background knowledge as well as core expertise in

Database Management Systems. The students will learn Database concept, Data Structure,

Data Models, various approaches to Database design, strengths of relational model,
Normalization.

At the end of the course the student will be able to
• Understand Database design and normalisation techniques.
• Use Standard Query Language and its various versions.
• Understand Importance of backup and recovery techniques.
• Develop Database system to handle the real world problem.

NIELIT A Level July, 2010 A6-R4: DATA STRUCTURE THROUGH C++

NIELIT A Level  July, 2010

A6-R4: DATA STRUCTURE THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Given two sorted list of size ‘m’ and ‘n’ respectively. The number of comparisons needed
in the worst case by the merge sort algorithm will be
A) m*n
B) maximum of m, n
C) minimum of m, n
D) m + n –1
1.2 The postfix equivalent of the prefix * + ab – cd is
A) ab + cd – *
B) abcd + – *
C) ab + cd* –
D) ab + – cd*

NIELIT A Level January, 2011 A6-R4: DATA STRUCTURE THROUGH C++

NIELIT A Level January, 2011

A6-R4: DATA STRUCTURE THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 For linear search in an array of n elements the time complexity for best case is.
A)
2
n
O
B) O(n)
C) O(1)
D)
 −
2

NIELIT A Level July, 2011 A6-R4: DATA STRUCTURE THROUGH C++

NIELIT A Level July, 2011

A6-R4: DATA STRUCTURE THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Identify the incorrect statement.
A) The resources most relevant in relation to efficiency are CPU time and internal memory.
B) An algorithm cannot have same Big-O measure for the worst case and the best case.
C) Worst case complexity of an algorithm can be determined by choosing a set of input conditions
that force the algorithm to make the least possible progress towards its final goal at each step.
D) Algorithms having exponential complexity can be practically solved only for very small values
of n.
1.2 The correct ADT of pop operation of a stack is
A) Function: Adds newItem to the top of stack
Precondition: Stack has been initialized
Postcondition: If (stack is full), exception fullStack is thrown,
else newItem is at the top of the stack
B) Function: Adds newItem to the top of stack
Precondition: Stack has been initialized
Postcondition: If (stack is empty), exception emptyStack is thrown,
else top element is removed from the stack
C) Function: Removes top element from the stack
Precondition: Stack has been initialized
Postcondition: If (stack is empty), exception emptyStack is thrown,
else top element is removed from the stack
D) Function: Removes top element from the stack
Precondition: Stack has been initialized
Postcondition: If (stack is full), exception FullStack is thrown,
else newItem is at the top of the stack

NIELIT A Level January, 2012 A6-R4: DATA STRUCTURES THROUGH C++

NIELIT A Level January, 2012

A6-R4: DATA STRUCTURES THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Array M[5,6] is stored in memory in row-major order and base address of M =200. If there are
4 words per memory cell then address of M[2,3] is
A) 250
B) 252
C) 254
D) 256
1.2 Sparse matrices are the matrices with
A) Less proportion of zeros
B) High proportion of zeros
C) No zeros
D) None of the above

NIELIT A Level July, 2012 A6-R4: DATA STRUCTURES THROUGH C++

NIELIT A Level July, 2012

A6-R4: DATA STRUCTURES THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Krushkal's algorithm is used for finding
A) Sorting
B) Searching
C) Critical Path
D) Minimum Spanning Tree
1.2 Which of the method belong to external sorting?
A) Bucket Sort
B) Multi way Merge
C) Selection Sort
D) Insertion Sort

NIELIT A Level January, 2013 A6-R4: DATA STRUCTURES THROUGH C++

NIELIT A Level  January, 2013

A6-R4: DATA STRUCTURES THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 If the address of A[1,1] and A[2][1] are 1000 and 1010 respectively and each element
occupies 2 byte of memory, then the array has been stored in
A) row major order
B) column major order
C) matrix major order
D) None of the above
1.2 One difference between a queue and a stack is:
A) Queues require dynamic memory, but stacks do not.
B) Stacks require dynamic memory, but queues do not.
C) Queues use two ends of the structure; stacks use only one.
D) Stacks use two ends of the structure, queues use only one

Algorithm Infix to postfix conversation

Postfix expression evolution is task for computer not for human. We deal with infix expression in our daily life.  Where we take care about operator priority etc which untimely need some more consideration for solve an expression if computer will follow infix expression as calculation then it need more time for getting priority operation.

So postfix is a solution where all bracket are removed.  One advantage that postfix has over infix is that it is very easily implemented and does not have overhead of parentheses. Evaluating an expression in postfix notation requires scanning from left to right so you know what to do as soon as you encounter an operator in the expression string. Also, with postfix there is no complication of precedence of one operator over the other.

In any language, arithmetic operation is support is needed which is same as mathematical expression. But writing data structure for understanding arithmetic expression has so many complications. Like scanning direction, operations priority and after that how to decide the priority if any parenthesis is coming. So designing compiler for any language has a need to take care of these complications. But support of arithmetic expressions one of basic requirement of any language. Let us take an arithmetic expression 

a+b/3

Suppose a=0 and b=6. suppose we are diving operation first then add. So the resultant value will be

NIELIT A Level July, 2013 A6-R4: DATA STRUCTURES THROUGH ‘C++’

NIELIT A Level July, 2013

A6-R4: DATA STRUCTURES THROUGH ‘C++’

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Given the sequence of numbers: 13, 52, 95, 26, 38
The sequence after the 3rd iteration of insertion sort is:
A) 13, 26, 52, 95, 38
B) 13, 52, 95, 26, 38
C) 13, 26, 38, 52, 95
D) 13, 26, 52, 95, 38
1.2 Given the following unbalanced tree:
Q
M
N
P
O
R

NIELIT A Level January, 2014 A6-R4: DATA STRUCTURE THROUGH C++

NIELIT A Level January, 2014

A6-R4: DATA STRUCTURE THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 If given data is already in sorted then it will be a worst case of

A) Bubble sort

B) Selection sort

C) Insertion sort

D) Quick sort

1.2 Advantage of doubly linked list over singly linked list is in

A) Addition at head

B) Addition at tail

C) Deletion at head

D) Deletion at tail

NIELIT A Level July, 2014 A6-R4: DATA STRUCTURES THROUGH C++

NIELIT A Level July, 2014

A6-R4: DATA STRUCTURES THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate

one and enter in the “OMR” answer sheet supplied with the question paper, following

instructions therein. (1x10)

1.1 If h is any hashing function and is used to hash n keys in to a table of size m, where n<=m, the

expected number of collisions involving a particular key x is :

A) less than 1

B) less than n

C) less than m x n

D) less than 2xn

1.2 Let A be an adjacency matrix of a graph G. The ijth entry in the matrix AK , gives

A) The number of paths of length K from vertex Vi to vertex Vj

B) Shortest path of K edges from vertex Vi to vertex Vj

C) Length of a Hamiltonian cycle from vertex Vi to vertex Vj

D) Length of a Eulerian path from vertex Vi to vertex Vj

NIELIT A Level January, 2015 A6-R4: DATA STRUCTURES THROUGH ‘C++’

NIELIT A Level January, 2015

A6-R4: DATA STRUCTURES THROUGH ‘C++’

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Suppose a queue is implemented by a circular array QUEUE [0..11].The number of elements
in the queue ,if FRONT =10 and REAR =3,will be
A) 3
B) 4
C) 5
D) 6
1.2 +/-MNP^+QR-UV is the prefix equivalent of
A) M-N/P+Q+R^U-V
B) MN-P/QR+UV-^+
C) MNP/-Q+R^UV-+
D) None of the above

NIELIT A Level July, 2015 A6-R4: DATA STRUCTURES THROUGH C++

NIELIT A Level July, 2015

A6-R4: DATA STRUCTURES THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 +/-ABC^+DE-FG is the prefix equivalent of
A) A-B/C+D+E^F-G
B) AB-C/DE+FG-^+
C) ABC/-D+E^FG-+
D) None of the above
1.2 The most efficient search technique used in an ordered array is
A) Sequential search
B) Binary search
C) Interpolation search
D) None of the above
1.3 What does the following code segment do?
void fn( )
{
char c;
cin.get(c);
if (c != ‘\n’)
{
fn( );
cout.put(c);
}
}
A) The string entered is printed as it is.
B) The string entered is printed in reverse order.
C) It will go in an infinite loop.
D) It will print an empty line.

NIELIT A Level January, 2016 A6-R4: DATA STRUCTURE THROUGH C++

NIELIT A Level January, 2016

A6-R4: DATA STRUCTURE THROUGH C++

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 A graph has M vertices and N edges. How many edges does a Minimum Spanning Tree
has?
A) (N + M) – 1
B) N – 1
C) M – 1
D) N × M
1.2 A sequence of operations performed on the stack of the size 4 is as follows:
push(5), push(3), pop, push(4), push(6), push(7), pop, push(8), pop, push(1)
What is the condition of the stack after all these operations?
A) Stack overflow message is displayed.
B) Stack finally contains: 5, 3, 4, 6, 7, 8, 1
C) Stack finally contains: 5, 4, 6, 1
D) Stack finally contains: 5, 4, 8, 1

NIELIT A Level Data Structure through C++ Assignment

Assignment 21

Prepare a decision tree that defines the following course grading scheme: A student may

receive a final course grade of S,A, B, C or F. In deriving the student’s final course grade,

the instructor first determines an initial grade for the first test of student. The initial course

grade is determined in the following manner.

a) A student who has scored a total of not less than 90 percent on the first test , quiz,

class performance and received a score not less than 75 percent in the final test will

receive an initial grade of ‘S’ for the course.

NIELIT A Level Data Structure through C++ Assignment

Assignment 20

Simplify the following decision table:

Rules

1 2 3 4 5 6 7 8 9 10 11 12

C1

N Y N Y N Y N Y N Y N Y

C2

N N Y Y N Y Y N N Y Y

C3

A A A A B B B B C C C C

A1

X X X

A2

NIELIT A Level Data Structure through C++ Assignment

Assignment 19

Identify the possible actions to be taken for the decision or policy for constructing decision

table:

a) Pay no interest

b) Pay 5.75% quarterly interest on entire amount

c) Pay 6% quarterly interest on entire amount

d) Pay 6% monthly interest on amount up to Rs.25000

e) Pay 6.55% monthly interest on amount between Rs.25000 and Rs.50000

NIELIT A Level Data Structure through C++ Assignment

Assignment 18

Prepare a limited entry decision table for the following case:

A wholesaler has three commodities to sell and has three types of customers. Discount is

given as per the following procedure:

a) For VIP’S orders, 10% discount is given irrespective of the value of the order.

b) For orders more than Rs. 50,000/- agent gets a discount of 15% and the

retailer gets a discount of 10%.

NIELIT A Level Data Structure through C++ Assignment

Assignment 17

The sales staff of a Jewellery shop is divided into commissioned salesman and salaried

salesman. A commissioned sales man receives 10% commission on every sale greater

than or equal to Rs.10, 000.00; receives 5% commission on every sale greater than or

equal to Rs.1, 000.00 and less than Rs. 10, 000.00 and receives 2% commission on every

sale less than Rs.1, 000.00. A salaried salesperson receives a Rs.700.00 bonus for

NIELIT A Level Data Structure through C++ Assignment

Assignment 16

In Accounts Receivable systems printing of the monthly account statement is the main

feature. Because of the frequency of accounts receivable invoices, customers generally

expect certain information to be included on the statement. Name, address and account

number details are essential as are the previous and current account balances.

NIELIT A Level Data Structure through C++ Assignment

Assignment 15

Given a file whose record consists of following attributes:

Roll No.

Name

Sex code                         ‘M’ for males

                                     ‘F’ for females

Marks in English

Marks in Biology

Marks in Maths

The scheme for selection and allotment of departments is as follows:

a) Reject the candidate, if aggregate marks are less than 180.

b) Allot ‘ENGINEERING ‘ department if the candidate has maximum marks in maths

and sex code is ‘M’.

NIELIT A Level Data Structure through C++ Assignment

Assignment 14

Given is a data file of School Education Board for compilation of result of middle standard

examination. Draw a decision table to compute the result of candidates. The pass formula

is:

a) Candidate is to be declared ‘PASS’ if he gets 40 or more than 40 marks in all three

subjects.

NIELIT A Level Data Structure through C++ Assignment

Assignment 13

Draw a mixed entry decision table for calculating income tax according to the following

conditions:

Income Slab                                                                Rate

Upto Rs. 18,000                                                          Nil

Greater than Rs.18000 but less than 25000                     25%

Greater than Rs.25000 but less than 50000                     30%

Greater than Rs.50000 but less than 1,00,000                 40%

NIELIT A Level Data Structure through C++ Assignment

Assignment 12

If a candidate is sharp and disciplined, take him as trainee systems analyst.

a) If a candidate is only sharp, take him as trainee programmer

b) If a candidate is only disciplined, take him as Trainee console operator.

c) If a candidate is neither sharp nor disciplined, reject him.

NIELIT A Level Data Structure through C++ Assignment

Assignment-11

The candidate is to be allotted the department, given the conditions

a) If a male secures maximum marks in mathematics, allot Engineering department.

b) if a female secures maximum marks in biology, she is allotted medical department.

c) If a candidate secures maximum marks in English, allot English department.

d) If a candidate secures less than 180 marks in aggregate, he/she is rejected.

e) Rest all cases are allotted psychology department.

NIELIT A Level Data Structure through C++ Assignment

Assignment-10

In a ABC Limited company, if the invoice paid is <5000, then no discount is offered. If the

payment is made within 10 days and the payment is above 5000 but less than 10,000 , 2%

discount is given. If the payment is made within 10 days and it is above 10,000, 3%

NIELIT A Level Data Structure through C++ Assignment

Assignment-9

Design a structured chart using following information:

Calling Module:

• Calculate Word Counting

Called Module:

• Get Sorted Word List
• Count Number of Different Words
• Output Count

NIELIT A Level Data Structure through C++ Assignment

Assignment-8

Design a structured chart using following information:

Calling module :

• Calculate student grade
• Called module:
• Get student’s academic information
• Get valid grade
• Find out errors
• Check for probation Period
• Check for director’s list

NIELIT A Level Data Structure through C++ Assignment

Assignment-7

Design a system for the Warehouse Inventory System and illustrate the solution with a Structure Chart that will take in customer orders, select the item from inventory, and

generate a packing slip and invoice.

INPUTS:

a) Customer Order from the Sales Department.

b) Shipments of Finished Goods to be put in Inventory.

OUTPUTS:

a) Plant Order for more Finished Goods.

b) Shipments of Finished Goods to the Customer.

c) Invoice and Packing Slip for items shipped to Customer.

d) Notice to Sales that items are Back Ordered.

NIELIT A Level Data Structure through C++ Assignment

Assignment-6

“In many organizations, raw material inventory consumes a major portion of the assets of he business. Management of inventory is therefore an important computer application. An integrated inventory system includes an inventory subsystem,a purchase subsystem, receiving subsystem. An inventory master file is usually maintained which is updated by all the subsystems. This file is also used to create a number of outputs for each of the subsystems.”

NIELIT A Level Data Structure through C++ Assignment

Assignment-5

Below are some statements about order processing in an organization? You are required to construct an ER diagram from these statements.

• Tax entry
• Bill entry
• Amount receiving entry
• Print both entries 
• Edit all entry when required  

Next Assignment 

NIELIT A Level Data Structure through C++ Assignment

Assignment 4

The office of Department of Computer Science organizes and handles seminars / workshops.

When a person wants to register for a seminar, he / she sends a request.

The office clerk notes the person’s name, address, telephone number and organization name on a registration form. Copy of the form is placed in the master file, an acknowledgement letter prepared and sent to the registrant. Another copy is sent to the billing clerk who creates an invoice record for the registrant in another central file and sends a copy of the invoice to the registrant.One month before the seminar, the clerk prepares name tags and seminar material for each participant. The registrants are expected to pay in advance of the seminar.

NIELIT A Level Data Structure through C++ Assignment

Assignment 3

A company stores all the purchase orders placed by it on its vendors in a purchase order file (POFILE). When it receives delivery of goods against a purchase order the details are  entered

in a file called RECDPOFILE (assume that partial deliveries do not exist, and that a purchase order corresponds to only one product). When an invoice is received from a vendor t is

stored in the INVCEFILE. At the end of each day, a program retrieves each invoice in the

INVCEFILE, checks it for the following:

Monday, 12 September 2016 NIELIT A Level Data Structure through C++ Assignment

Assignment 1

Activities of a school Office during admission time are as follows

Applications are received from students and they are checked for eligibility for admission Eligible candidates are called for an admission test. The teachers set the question papers for the test. The candidates take up the test. The teachers evaluate the test papers.

Based on the marks obtained by the candidate in the test and other criteria specified by the school, the teachers prepare a provisional admission list. The candidates in the admission list are called for an interview. Normally, this list contains about 10% more than the number of seats available in the school.

NIELIT A Level Data Structure through C++ Assignment

Assignment 1

The City College has a large library consisting of books of different categories. Few are listed below:

A. Fiction           B. Biography           C. Economics            D. Mathematics

E. Sports             F. Management       G. Computers and Communication

H. Taxation         I. Law                     J. Travel

Students and teachers borrow the library books. The students can take at time two books on subjects related to studies and one book from general interest.The teachers can take at time three books on subjects related to studies and two books from general interest. The college decides to provide an online facility to inquire on the availability of books in the library. Entering any of the following

can search the books available in the library:

NIELIT A Level DATA STRUCTURE THROUGH C++ Syllabus

Objective of the Course

The objective of the course is to introduce the fundamentals of Data Structures, Abstract concepts and how these concepts are useful in problem solving.

After completion of this course student will be able to -

• To Understand and the concepts of object oriented language such as c++
• Analyze step by step and develop algorithms to solve real world problems.
• Implementing various data structures viz. Stacks, Queues, Linked Lists, Trees and Graphs.
• Understanding various searching & sorting techniques.

frame collage effect

This is effect is pretty simple, you can also make collage effect.  It is not any new or advance feature of photo shop it’s just a trick with combination of rectangle and selection tool follow the steps

Website selection text background color change

When you select a text from a website then you will notice that selected text background color will be blue because this is default setting. You can change selection background color for enhance your website user experience . CSS3 include selection style which enable us to accomplish this. Use following code..

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Girfa Student Help </title>
<style type="text/css">
::selection {
  background: #ffb7b7; /* Global Selection Color */
 
}
.yellow::selection
{
background:#FF0;
}
.green::selection
{
background:#0C0;
}

NIELIT A Level July, 2010 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level July, 2010

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Which step of SDLC performs cost-benefit analysis?
A) Feasibility Study
B) Analysis
C) Design
D) None of the above
1.2 The relationships among elements within a module is called
A) Modular Coupling
B) Modularization
C) Modular Cohesion
D) None of the above

NIELIT A Level January, 2011 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level January, 2011

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 SDLC is
A) Software Development Life Cycle
B) System Development Life Cycle
C) System Design, Link and Code
D) None of the above
1.2 Software design involves
A) writing algorithms
B) creating flowcharts
C) creating ERD
D) all of the above

NIELIT A Level July, 2011 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level July, 2011

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Backup and Recovery procedures are necessary to
A) Reorganize the disk
B) Control the DBA
C) Handle contingencies like files getting corrupt or becoming irretrievable
D) None of the above
1.2 The basic objective of system analysis is to
A) Understand computer hardware by opening the System Unit
B) Train managers in mathematical analysis
C) Run simulation programs
D) Understand a complex system and modify it in some way

NIELIT A Level January, 2012 A5-R4: STRUCTURED SYSTEM ANALYSIS AND DESIGN

NIELIT A Level January, 2012

A5-R4: STRUCTURED SYSTEM ANALYSIS AND DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Running the system under a live environment using Live data in order to find errors is known
as
A) Beta Testing
B) Alpha Testing
C) Acceptance Testing
D) System Testing
1.2 The components that make up any system is known as system
A) Boundary
B) Environment
C) Description
D) None of the above

NIELIT A Level July, 2012

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 Information is gathered by a system analyst in order to
A) find out whether a computer based system is required
B) find out how the organization works.
C) find out how the current system works and what is expected from a new computer based
system
D) find out who will use the system
1.2 A physical DFD specifies
A) what processes will be used
B) who generates data and who processes it
C) what each portion in an organization does
D) what data will be generated

NIELIT A Level January, 2013 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level January, 2013

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 A cost-benefit analysis is performed to assess
A) economic feasibility
B) operational feasibility
C) technical feasibility
D) all of the above
1.2 Information is gathered by a system analyst in order to
A) find out whether a computer based system is required
B) find out how the organization works
C) find out how the current system works and what is expected from a new computer based
system

Comment in Excel

Add Comment 

Comment box in word provides further descriptive information about what is user is going to insert in cell is for. Adding comment is dreadfully    simple follow the steps

• Review TAB
• Select Cell where comment has to insert
• Click new comment and add your comment title and text

Change Shape of comment

Microsoft Access Tutorial

• How to delete record from Ms Access in Java
• Save Image In Access and Retrieve in Datagridview Using VB.net
• How to connect word document to MS Access database
• Save Image in Ms-Access 2003 and 2007 Using VB6.0
• Connect Ms Access 2003 with Java (jdk1.3)
• Save and Retrieve an image in Ms Access Using VB.Net
• Import Microsoft Access Database table to PHP mysql database table
• MS Access MCQ Question/Answer

Home

On Line Institute Complete Management C# (ASP.Net)

On Line Institute Complete Management C#  (ASP.Net)

Online institute management is my DOEACC ‘A’ Level Project which I had made approx in one year of time span. It is a complete ASP.net web which covers all the requirements of any computer institution operations like fees management, student entry and all related operation and most important and key feature of this project is an online exam with magnificent controlling facility. Owner of institute can view the performance of faculty and student can also view their performance. You can use this project in any type computer program’s main project.

Key Feature

• Student Record Entry
• Fee Entry
• Online Test
• Faculty performance meter
• Student Personal portal for exam result and performance report
• Job Application
• Multiple mode of exam (Minus Marking,Without minus marking,timing for each question,without timing,pass-fail percentage setting,Topic wise exam , flexible number of question setting and many more other types of settings)
• School information system for visitors

NIELIT A Level July, 2013 A5-R4: STRUCTURED SYSTEM ANALYSIS AND DESIGN

NIELIT A Level July, 2013

A5-R4: STRUCTURED SYSTEM ANALYSIS AND DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 An update operation in an object instance

A) Updates the class

B) Has no side effects

C) Deletes an instance

D) Alters the state of an object

1.2 Prototyping means–

A) Creating, developing and refining a working Model of the final operational system

B) Testing the computer system

C) Designing the computer system

D) None of the above

NIELIT A Level January, 2014 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level January, 2014

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which of the following is not a tool of data collection?
A) Interview
B) Questionnaires
C) Observation
D) Data Flow Diagram
1.2 Which of the following diagram of Object Oriented Design is used for representation of
behavioral model of the system?
A) State chart
B) Class diagram
C) Object diagram
D) DFD

NIELIT A Level July, 2014 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level July, 2014

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which step of SDLC performs cost-benefit analysis?
A) Coding
B) Testing
C) Design
D) None of the above
1.2 Project planning is done by
A) Gantt
B) State visits
C) Spiral Model
D) COCOMO

Online MCQ Test Project

This is online test software for desktop computer. This software has 50 set object type question. Each set comprise 50 MCQ type question. When user select an answer through radio button then if select option is right then it become green otherwise red, in case of wrong answer then selected radio button remain red and right answer will be green. So this will help to memories answer in a easy way.

Key feature

• MCQ type question
• 10 papers set each set have 50 questions.
• An easy way to memories 500 question
• Red, Green pattern which help to learn in effective way
• This project is suitable for BCA,MCA,PGDCA,O Level,A Level etc

Billing Project VB.Net

This is live project for an architecture business billing system. It is complete project in VB.net with full source code you can use this for project, practice or whatever you wish ….. I just need one thing by you like my FB page right side on this page and share it to your friend. Technical details are following

NIELIT A Level January, 2015 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level January, 2015

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which statement best reflects the role of a systems analyst?
A) Systems analysts focus basically on how a system works.
B) Systems analysts must understand business requirements as well as technical requirements.
C) Systems analysts’ primary job is to manage projects.
D) the most common work performed by a systems analyst is programming.
1.2 Which of the following is a true statement regarding the SDLC phases?
A) The SDLC is not iterative.
B) The life cycle is always a sequentially ordered set of phases.
C) It is not possible to complete some activities in one phase in parallel with those of another
phase.
D) The life cycle may be thought of as a circular process in which the end of the useful life of one
system leads to the beginning of another project to develop a new version of or replace an
existing system.

NIELIT A Level July, 2015 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level July, 2015

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 The next major step before system design and after feasibility study is
A) Analysis
B) Equipment selection
C) Implementation
D) Testing
1.2 ________ is a collection of programs written to service other programs.
A) Application S/W
B) Real Time S/W
C) Business S/W
D) System S/W

NIELIT A Level January, 2016 A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

NIELIT A Level January, 2016

A5-R4: STRUCTURED SYSTEM ANALYSIS & DESIGN

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 The main objective of feasibility study is:
A) To assess whether it is possible to meet the requirements specifications.
B) To assess if it is possible to meet the requirements specified subject to constraints of budget,
human resource and hardware
C) To assist the management in implementing the desired system
D) To remove bottlenecks in implementing the desired system
1.2 Which decision structure you should use when the sequence of conditions and actions is
critical?
A) a decision tree
B) a decision table
C) a structured English
D) all of the above

Syllabus Structured System Analysis and Design

NIELIT A Level 

Structured System Analysis and Design

Syllabus

Objective of the Course

The Objective of the course is to provide the necessary skills, learning and exposure in developing an information system. The student should be able to develop an understanding of the general principles and purpose of systems analysis and design; apply key techniques from a standard methodology. He should have knowledge of information systems and be able to prepare the physical design of an information system

NIELIT A Level July, 2010 A4-R4: COMPUTER SYSTEM ARCHITECTURE

NIELIT A Level July, 2010

A4-R4: COMPUTER SYSTEM ARCHITECTURE

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following

instructions therein. (1x10)
1.1 Which of the following is NOT the key distinguishing feature of a microprocessor
A) Clock Speed
B) L1 Cache
C) Number of transistors
D) Capacity of the Hard Disk
1.2 The two's complement of binary number 11001 is
A) 00111
B) 00110
C) 11000
D) 11001

Nielit A Level January, 2011 A4-R4: COMPUTER SYSTEM ARCHITECTURE

Nielit A Level January, 2011

A4-R4: COMPUTER SYSTEM ARCHITECTURE

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 An arithmetic shift-right is equivalent to
A) multiplying the number by 2
B) dividing the number by 2
C) changing the sign of the number
D) reversing the number
1.2 The computer can be interrupted if
A) IEN= 0, FGI=0
B) IEN= 0, FGI=1
C) IEN= 1, FGI=0
D) IEN= 1, FGI=1

Nielit A Level July, 2011 A4-R4: COMPUTER SYSTEM ARCHITECTURE

Nielit A Level July, 2011

A4-R4: COMPUTER SYSTEM ARCHITECTURE

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 The hardware which is responsible for executing machine language instructions can be built
using large number of few basic building blocks, which are called
A) Control Unit
B) CPU
C) Logic gates
D) None of the above
1.2 The output depends both on the current inputs as well as on how it got to the current state in
A) Combinational circuits
B) Sequential circuits
C) In both – combinational and sequential circuits
D) None of the above

A Level January, 2012 A4-R4: COMPUTER SYSTEM ARCHITECTURE

A Level  January, 2012

A4-R4: COMPUTER SYSTEM ARCHITECTURE

TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 The circuit given below is

A) Combinational
B) Sequential
C) Hybrid
D) Analog
1.2 Which one of the following is universal gate?
A) AND
B) OR
C) NOR
D) NOT

A Level July, 2012 A4-R4: COMPUTER SYSTEM ARCHITECTURE

A Level July, 2012

A4-R4: COMPUTER SYSTEM ARCHITECTURE

TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 A combinational circuit which performs arithmetic addition of three bits is called
A) Half–adder
B) Full–adder
C) Double–adder
D) None of the above
1.2 Storage capabilities are not provided in
A) ROM
B) RAM
C) Secondary Storage
D) None of the above

A Level January, 2013 A4-R4: COMPUTER SYSTEM ARCHITECTURE

A Level January, 2013

A4-R4: COMPUTER SYSTEM ARCHITECTURE

TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 Conversion of hexadecimal number 6B2 to its binary number equivalent is
A) 111100011011
B) 011011010101
C) 011010110010
D) 011011000010
1.2 Which of the following registers is used to keep track of the address of the next instruction?
A) Memory Address Register
B) Instruction Register
C) Program Counter
D) Memory Data Register

A Level July, 2013 A4-R4: COMPUTER SYSTEM ARCHITECTURE

A Level July, 2013

A4-R4: COMPUTER SYSTEM ARCHITECTURE

TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 Which one among the following 2 Input logic gates can be used to implement any other 2 Input
Logic gates?
A) AND
B) EX-OR
C) OR
D) NOR
1.2 What is the FAN-OUT of any standard TTL Logic Gate?
A) 2
B) 1
C) 10
D) 5

A Level January, 2014 A4-R4: COMPUTER SYSTEM ARCHITECTURE

A Level January, 2014
A4-R4: COMPUTER SYSTEM ARCHITECTURE

TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 The no. of minterms in a truth table of n variables
A) n2
B) 2n
C) 2*n
D) n!
1.2 The algebraic function for XOR logic gate with two inputs A and B is
A) AA’ + BB’
B) A(A+B)
C) AB+A’B’
D) A’B+AB’