Hall Ticket December-2012, Term End Examination

BCA/MCA/MBA  

Click here:-Hall Ticket December-2012, Term End Examination


All the Best....................(SPC-RAJAT SHARMA)

IGNOU MCA SOLVED ASSIGNMENT 2012-2013

How to download:-
1 click on link.
2 then click on print option.then press escape button
3 then assignment download.(ctrl+s).

IGNOU MCA FIRST SEMESTER SOLVED ASSIGNMENTS 2012-2013

Mcs-011  | Mcs-012  | Mcs-013  | Mcs-014  | Mcs-015  | Mcsl-016  | Mcsl-017 

Mcsl-016 (Session Lab)

Mcsl-017 (Session Lab)

IGNOU MCA SECOND SEMESTER SOLVED ASSIGNMENTS 2012-2013

Mcs-021  | Mcs-022  | Mcs-023  | Mcs-024  | Mcsl-025

IGNOU MCA THIRD SEMESTER SOLVED ASSIGNMENTS 2012-2013

Mcs-031  | Mcs-032  | Mcs-033  | Mcs-034  | Mcs-035  | Mcsl-036

IGNOU MCA FOURTH SEMESTER SOLVED ASSIGNMENTS 2012-2013

Mcs-041  | Mcs-042  | Mcs-043  | Mcs-044  | Mcsl-045

IGNOU MCA FIFTH SEMESTER SOLVED ASSIGNMENTS 2012-2013

Mcs-051 |  Mcs-052  | Mcs-053  | Mcsl-054  | Mcse-003 | Mcse-004 | Mcse-011 

IGNOU SOLVED ASSIGNMENT'S FOR BCA MCA 2012-2013

IGNOU BCA SOLVED ASSIGNMENT'S 2012-2013

IGNOU MCA SOLVED ASSIGNMENT'S 2012-2013

IGNOU MCA -mcs-045 solved assignments 2012 -2013

Course Code : MCSL-045

Course Title : UNIX and DBMS LAB
Assignment Number : MCA (4)/L045/Assign/12
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 31st October, 2012 (For July 2012 Session)
30th April, 2013 (For January 2013 Session)
The assignment has two parts A and B. Answer all the questions. Each part is for 20 marks. UNIX and DBMS lab record carries 40 Marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the MCA Programme Guide for the format of presentation. If any assumptions made, please state them.

                                 PART-I: MCS-041

Question 1:
Write the UNIX commands for the following:
(a) To print the calendar for the current month.
(b) To append the contents of file2 after the contents of the file1 and redirect them to a new file3.
(c) To print the first difference between any two given files.
(d) To change the command prompt from $ to ~.
(e) To grant the permissions of r w x to the user and execute only permission to the group and others for all the files in a current directory.
(f) To direct a standard output to any of the line printer.
(g) To list all the files in the current directory whose file names starts with f.
(h) To execute some command even after logout.
(i) To split a file splittest, which is containing 20 lines into 5 lines each which are directed to four various files.
(j) To display the first 2 lines in a given file.
(5 Marks)
Question 2:
(a) Write a shell program to count no. of other symbols in a given file by the user.
(5 Marks)
(b) Write a shell script to find the difference between any two given dates.
(5 Marks)
(c) Write a shell script to display the smallest element in a given 2X2 matrix.
(5 Marks)


                                                        PART-II: MCS-043
Question 1:
(a) Create an appropriate database using Oracle for a study centre management system. (Perform Normalization till the required levels)
(10 Marks)
(b) Perform following queries using SQL:
(5 Marks)
(i) Find the name of the programmes those are been activated in the given study centre.
(ii) Find the no of students in BCA programme for the current year.
(iii) Display the corresponding Regional Centre Code if the study centre code is given.
(iv) Display the list of all the academic counsellors of MCA programme.
(v) Display the total no. of assignments received in the current session for the MCSL-045 course.
(c) Write appropriate triggers, exceptions and functions for the above study centre management system database schema and describe them briefly.
(5 marks)
 IGNOU Coaching for BCA, MCA, MBA in Jaipur  

IGNOU JAIPUR

Regional Director,
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043

IGNOU MCA -mcs-042 solved assignments 2012 -2013

Course Code : MCS-042

Course Title : Data Communication and Computer Network
Assignment Number : MCA (4)/042/Assign/12
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th October, 2012 (For July 2012 Session)
15th April, 2013 (For January 2013 Session)
This assignment has eight questions. Answer all questions. Rest 20 marks are for viva voce. You may use illustration and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Q 1: Assume a data stream is made of “000010” Encode this stream using the
following encoding schemes. (10 marks)
(i) Manchester
(ii) Differential Manchester
(iii) UNI polar
(iv) Polar NR Z-1
(v) RZ
Also discuss the usefulness of each scheme.
Q 2: (i) Illustrate constellation diagram of 8- PSK and 8- QAM. (5 marks)
(ii) Given a 10 bit sequence frame: 1001111001 and a divisor (polynomial)
of 1011, Find the CRC. (5 marks)
Q 3: How are problems of Hidden Station and Exposed Station resolved in
wireless LAN? Explain in detail. (10 marks)
Q 4: Explain the 3-way handshake method. How is it different from 2-way
handshake method? (10 marks)
Q 5: How does BGP work? How does it solve the Count to Infinity problem? (10 marks)
Q 6: Explain Diffie Hellman algorithm-with the help of an example. (10 marks)
Q 7: What is the utility of digital certificate? How are these signatures
created? (10 marks)
Q 8: Differentiate between the following: (10 marks)
(i) Leaky Bucket Traffic Shaper and Token bucket Traffic Shaper
(ii) Distance vector routing and Link state routing

 IGNOU Coaching for BCA, MCA, MBA in Jaipur  

IGNOU JAIPUR

Regional Director,
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043

IGNOU MCA -mcs-044 solved assignments 2012 -2013

Course Code : MCS-044

Course Title : Mini Project
Assignment Number : MCA (4)/044/Assign/12
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th October, 2012 (For July 2012 Session)
15th April, 2013 (For January 2013 Session)
There are five questions in this assignment carrying 80 marks. Rest 20 marks are for viva-voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Program Guide for the format of presentation. Assumptions made if any, should be stated.
Background and Project Specifications:
A University like IGNOU wants to design and implement a web-based centralised system for Synopsis submission for the Project Courses. A Synopsis is created by a student under the supervision of a Project Guide. A person can be an eligible project guide if he has a MCA or B. Tech Computer Science degree and at least two years of experience at the Industry. An eligible project guide can guide maximum of 6 students in a semester. The synopsis submission requires a student to fill the relevant synopsis information and submit it. An incomplete synopsis or the synopsis submitted by ineligible students may be rejected. Once a synopsis is duly submitted, it is evaluated. A number of synopses are evaluated by an evaluator. Synopsis may be sent to them electronically and comments for improvement, status (Approved or Not Approved) is updated by the evaluator. A bill for evaluator may automatically be generated when all the synopsis sent to him/her are evaluated. An evaluator is allotted a maximum of 50 synopses. If an evaluator does not complete the task of evaluating synopsis in two weeks time then the synopses returns to the administrator, who sends them to a different evaluator. The system needs to maintain data of valid students, their synopsis, project guides, evaluator and the evaluation status of synopsis.
You may study such manual system at your Regional Centre.
Q 1: Which Systems Development Life Cycle (SDLC) will you
propose for the specification given above? Justify you selection by
evaluating suitability of at least two SDLCs. (10 Marks)
Q 2: What would be major costs of installing the system? What are going to
be the benefits in terms of finances? Perform a cost-benefit analysis for the proposed software. List the major tasks and milestones of the Project and
make a project schedule. You schedule must include both GANTT and
PERT charts. Explain the two charts drawn by you. (10 Marks)
9
Q 3: Study the system and create a software requirement specification. You
must identify either the processes or objects while analyzing. During
the analysis give consideration to possible input and output of the processes.
After identifying the requirements, create Analysis Models. You may
either use the classical approach and draw Entity relationship model and
data flow diagrams (DFD’s) up to level 2-3; or you may take object oriented analysis approach and create class diagram, use case diagram, use cases etc.
(10+15 Marks)
Q 4: Think of system architecture and then perform data design. You must
perform normalization on tables up to 3rd normal form. The table design
must include Primary and Foreign keys and constrains. Create the systems
flow chart or detailed process design and state transition diagrams.
Also design the user input screens and output report formats. (15+10 Marks)
Q 5: Design various unit test cases for different testing techniques/
strategies. (10 Marks)

 IGNOU Coaching for BCA, MCA, MBA in Jaipur  

IGNOU JAIPUR

Regional Director,
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043

IGNOU MCA -mcs-043 solved assignments 2012 -2013

Course Code : MCS-043

Course Title : Advanced Database Management Systems
Assignment Number : MCA (4)/043/Assign/12
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th October, 2012 (For July 2012 Session)
15th April, 2013 (For January 2013 Session)
This assignment has ten questions, which carries 80 marks. Answer all the questions. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 300 words.
Q 1: The organization called ABC undertakes several kinds of software project related to HR finance, manufacturing projects. Each employee can move on one or more projects. Each project is undertaken on the request of a client. A client can request for several projects. Each project has only one client. A project can use a number of items from different manufacturers and items may be used by several projects. Before delivery of items to a client, it is
tested by testing group in the organization. (5 marks)
(a) Draw the EER diagram for the organization showing all entities, relationship, aggregation, generalisation and specialisation for
the description given above. (5 marks)
(b) Create the normalised tables till 5 NF for the EER diagram created as answer to part (a) of this question, highlighting the different types of dependencies including Multi-Valued and Join dependencies (if your design does not have any such dependency, then you must explain the MVD and JD with the
help of an example situation). (5 marks)
(c) Draw the class diagram for the organization as described above
and relate it to database design as done in part (b). (5 marks)
Q 2: Consider the following relations: (6 marks)
Hotelstaff (S_code, S_name, S_desig, S_pay)
Client (C_id, C_name, C_address, C_phone, C_city)
Room (R_id, R_type, R_rent, R_booked)
Booking (B_id, C_id, R_id, S_code, B_date)
Write the appropriate SQL commands for the following:
i. Find the details of all the staff whose designation is “Dy. Manager” and who have made booking of executive type room to the client from Pune.
7
ii. List the details of all the rooms which have not been allocated to any client.
iii. Find the names of all the clients who are from “Goa and Delhi” for whom the booking was done in the last 15 days.
Q 3: Explain the significance and usage of views in a relational database
system, with the help of suitable example. Explain any four constraints
of updating a tuple in a view. (8 marks)
Q 4: (a) Define indices and their advantages in RDBMS. Explain the concepts
of clustering and hashing indices, using an example of each. (10 marks)
(b) Consider the relations:
GRADE (stud_id, subject_id, grade)
SUBJECT (subject_id, s_name, teacher)
(i) Write the relational algebraic query for the following:
 List the student number, subject names and grades of the student whose id is 100.
 List the grades of all the students in the subjects taught by
teacher “XYZ”. (5 marks)
Q5: Explain the role of checkpoints in log-based recovery with the help
of an example. (5 marks)
Q 6: Discuss the shadow paging recovery scheme. Compare this scheme
with the log based recovery scheme. (6 marks)
Q 7: Discuss how the two-phase locking protocol ensures serial ability but
does not ensure deadlock free situation. (5 marks)
Q 8: How does embedded SQL differ from Dynamic SQL with the help of
an example describe the implementation of cursor and triggers. (5 marks)
Q 9: How does Postgre SQL perform storage and indexing of tables? (5 marks)
Q 10: How OLAP supports query processing in dataware house? (5 marks)

 IGNOU Coaching for BCA, MCA, MBA in Jaipur  

IGNOU JAIPUR

Regional Director,
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043