Last five years ignou MCA question paper

Hi All,


Can someone please send me ,last five years ignou MCA question paper?

For MCA Semestar 1

Thanks in avance,
Aswathy

I am preparing for the upcoming MCA examination of the Indira Gandhi National Open University and now I need Last Five Years MCA Question Paper. Please help me…

plz send me question paper of mca sem 1 of ignou .... last 5 year
my email id is :- madhveshbhalodia@ymail.com

am preparing for the upcoming MCA examination of the Indira Gandhi National Open University and now I need Last Five Years MCA Question Paper. Please help me…

Please Send me Last Five Years IGNOU Question Paper In my email id
parekh.hiren1982@gmail.com


Thanking Yours,

plz send me question paper of mca sem 1 of ignou .... last 5 year
my email id is :-jessi.beena@gmail.com

Here is IGNOU-MCA-question-papers are as follows:

1. (a) Assume the following requirements for a 10
bank database :
A large bank named "KBC" is an
international bank having 28 branches
overseas and around 182 branches in the
country at different cities. Each branch
offers services like banking, Loan services,
Insurance and Trading. Further, Customer
can select saving account/current account
with single or join options in the banking.
Bank offers Loan services like car loan, home
loan, Education loan, etc. Similarly Bank
provide different services in insurance and
trading. Each Branch maintains the account
details of the customers keep record of each
transaction in each service by the customer
to his/her account. All branches have

employees like staff, executive and
managers. On the basis of the above
specifications answer the following
questions:
Design an ER diagram indicating all entities,
attributers with keys and cardinality ratios.
(b) Find BCNF decomposition of the following 10
relation scheme; R (Faculty, Dean,
Department, Chairperson, Professor, Rank,
Student). The relation satisfies the following
functional dependencies.
Faculty —> Dean
Dean —> Faculty
Department —> Chairperson
Professor —> Rank, Chair person
Department -4 Faculty
Student —> Department,
Faculty, Dean
Professor, Rank —> Department,
Faculty
(c) What are the deficiencies of relational 6
database management systems that are
overcome by object database management
systems ?
(d) With the help of an example, explain the 4
inverted file organisation.

2. (a) What is client/server based Database? 5
Discuss the components of client/ server
computing.
(b) Explain the use of any three aggregate 6
functions of SQL with an example for each.
(c) What are integrity constraints? Explain any 4
two types of integrity contraints which can
be imposed on relational databases.

3. (a) What are the different types of anomalies
5
which a relational database can encounter.
How normalisation helps in avoiding these
anomalies.
(b) Consider the following relations (where
primary keys are underlined):
Project (Project - code, Project - Name,
Project - leader)
Employee (Emp - code, Emp - Name, Emp -
Salary, Emp - Department)
Assinged - To ( Project - code, Emp - code)
Write SQL queries for the following:
(i) List the Name of employees those are 3
assigned to project code "A4532".
Increase the salary of employees by
4
5000/- Rupees those are working on
project - code "B2316".

(iii) Insert a new Project named "HNS", 3
Project - code "C 1479" under the
project leader "Ramesh Singh"

4. (a) Explain the difference between Relational 5
Model and other models of storage of data.
Explain with an example, the process of
conversion of hierarchical structure into
Relation.
(b) How the views in databases are defined ? 5
Give the advantages and disadvantages of
views.
(c) What is a join operation? How is it different 5
from cartesian product in relational
algebra? Explain with an example.

5. Write a short note (150 words) on the following :
(a) Distributed DBMS 5x3=15
(b) Index sequential File Organisation
(c) Difference between knowledge Base system
and Database system.

1. (a) What is SDLC ? Explain briefly all the 8
phases of SDLC.
(b) What is Quality Assurance ? Explain the 5
different levels of Quality Assurance.
(c) What is Prototyping ? Explain underlying 7
principles of Prototyping. Explain briefly
steps involved in prototyping process.
(d) What is Ergonomics ? Justify need of 5
ergonomics in system. Design.
(e) Explain why aspect of HCI is very important 5
in System Design. Explain various factors,
which need to be considered for providing
good and efficient HCI.

2. (a) What is Systems Analysis ? Explain various 10
elements of Systems Analysis.
(b) What is input data ? Explain importance 5
of input data design with the help of an
example.

3. (a) What is MIS ? Explain functions of a typical 5
MIS.
(b) What is SRS ? Is it necessary to have a SRS 10
for System Development ? Justify your
answer. Also write SRS for Hospital
Management System.

4. (a) What are different methods of fact 10
finding ? Discuss Interviewing as a method
for fact finding with an example.
(b) What is a Form ? Explain four factors to be 5
considered in form design.

5. (a) What is decision table ? Describe its 5
structure. Explain application of decision
table with an example.
(b) Write short note on the following : 10
(i) Transaction Processing System
(ii) GUI design
(iii) VTOC
(iv) Software Piracy
(v) Software Maintenance

__________________
Answered By StudyChaCha Member

Indira Gandhi National Open University (IGNOU) is the prestigious Open University of India.

Sample Questions:

__________________
Answered By StudyChaCha Member

i need mca 1st semesster last 5 years solved question papers plz frd send me fast on my email-kuldeep.bharwaj2224@gmail.com