#1
| |||
| |||
![]() Can someone please send me ,last five years ignou MCA question paper? For MCA Semestar 1 Thanks in avance, Aswathy Indira Gandhi National Open University (IGNOU) is the prestigious Open University of India. Sample Questions: ![]() ![]() ![]() ![]() ![]() ![]() Last edited by Aakashd; May 28th, 2019 at 12:43 PM. |
#3
| |||
| |||
![]()
plz send me question paper of mca sem 1 of ignou .... last 5 year my email id is :- madhveshbhalodia@ymail.com |
#5
| |||
| |||
![]()
Please Send me Last Five Years IGNOU Question Paper In my email id parekh.hiren1982@gmail.com Thanking Yours, |
#7
| ||||
| ||||
![]()
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 |
#8
| |||
| |||
![]()
i need mca 1st semesster last 5 years solved question papers plz frd send me fast on my email-kuldeep.bharwaj2224@gmail.com |