Saturday, September 8, 2012

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-003Mcse-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








Sunday, September 2, 2012

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  

BCA Coaching in Jaipur | MCA Coaching 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  



BCA Coaching in Jaipur | MCA Coaching 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  

BCA Coaching in Jaipur | MCA Coaching 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

IGNOU MCA -mcs-041 solved assignments 2012 -2013


Course Code : MCS-041

Course Title : Operating Systems
Assignment Number : MCA(4)/041/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 four questions. Answer all questions. Each question is of 20 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 Programme Guide.
Question 1:
Consider the following jobs:
Job #   Arrival time  Run time
A            0                 4
B            2                 5
C            3                 2
D            5                 4
a) Using the SJF method, compute the completion times of the above jobs, average turn around time and average waiting time.
b) Using the SRTF (Shortest Remaining Time first) method, compute the completion times of the above jobs, the average turn around time and the average waiting time. Note that SRTF is SJF with preemption. (Hint: Completion time - arrival time = turnaround time).
c) Using the Round Robin method (with Quantum = 2), compute the completion times of the above jobs and the average waiting time. (15 Marks)
Question 2:
a. Explain the Banker’s problem. Consider the following snapshot of a system:
Allocation
A
B
C
D
P0
0
0
1
2
P1
1
0
0
0
P2
1
3
5
4
P3
0
6
3
2
P4
0
0
1
4
Max
A
B
C
D
0
0
1
2
1
7
5
0
2
3
5
6
0
6
5
2
0
6
5
6
Available
A
B
C
D
1
5
2
0
4
Answer the following questions using Banker's algorithm:
i. What is the content of the matrix need?
ii. Is the system in a safe state?
iii. If a request from P1 arrives for (0, 4, 2, 0), can the request be granted
immediately? (15 Marks)
b. Consider the following page-reference string: 1, 2, 3, 4, 2, 1, 3, 4, 6, 2, 1, 2, 3, 7, 6, 3, 2, 1, 2, 3, 4
How many page faults would occur for following replacement algorithms assuming one, two, three, four, five, six or seven frames? Remember that all frames are initially empty, so your first unique pages will all cost one fault each.
i. LRU replacement.
ii. FIFO replacement.
iii. Optimal replacement. (10 Marks)
Question 3:
a. The Linux kernel does not allow paging out kernel memory. What effect does this restriction have on kernel design? What are two advantages and two disadvantages of this design decision? (10 Marks)
b. The Windows 2000 VM manager uses a two-stage process to allocate memory. Identify several ways in which this approach is beneficial. (10 Marks)
Question 4:
a. Discuss in detail the Process management, Memory management, I/O management, File management and Security and Protection in WINDOWS 7 Operating System.
(20 Marks)


 IGNOU Coaching for BCA, MCA, MBA in Jaipur  

Python Training in Jaipur
Python Training Institute in Jaipur
python coaching in jaipur

best python coaching 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
 
Programming Languages Training
c language coaching in jaipur | c language classes in jaipur | c classes in jaipur | c language training in jaipur | c training in jaipur | c language training institute in jaipur | c language coaching institute in jaipur | c training institute in jaipur | c coaching institute in jaipur | c++ coaching in jaipur | c++ classes in jaipur | c++ training in jaipur | c++ training institute in jaipur | c++ coaching institute in jaipur | Java training in jaipur | Java coaching in jaipur | Java coaching institute in jaipur | Java training institute in jaipur | Core Java training in jaipur | Core Java coaching in jaipur | Python Training in Jaipur | Python Training Institute in Jaipur | python coaching in jaipur | best python coaching in jaipur | Data Structures Training Institute in Jaipur | data structures training in jaipur | data structure coaching in jaipur | data structure training in jaipur | data structure coaching in jaipur | Data Structure coaching Institute in Jaipur | data structure algorithm training in jaipur | data structures algorithm training in jaipur | IGNOU MBA project | coaching in jaipur for java | coaching for java in jaipur | training in jaipur for java | training for java in jaipur | coaching institute in jaipur for java | coaching institute for java in jaipur | training institute in jaipur for java | training institute for java in jaipur

For the Math Subjects Coaching
NA-Numerical Analysis | DM-Discrete Mathematics | ADM- Advanced Discrete Mathematics | TOC-Theory of Computation
BCA Coaching in Jaipur | MCA Coaching in Jaipur

Website: www.spcjaipur.com
Mobile: +91-9680422112
Address: D-300, Near World Trade Park, Malviya Nagar, Jaipur (Rajasthan)