DOWNLAD IGNOU STUDY MATERIAL

IGNOU STUDY MATERIAL

Study Materiel Dispatch status - IGNOU

Night view of Vijayawada - Photo by sivasyam

qutub minar - Photo by sivasyam

qutub minar - Photo by sivasyam 

qutub minar - Photo by sivasyam

qutub minar - Photo by sivasyam

qutub minar - Photo by sivasyam

Lotus Temple Delhi - Photo by sivasyam

Shimla - Manali Road - Photos By SivaSyam

Sony Ericsson Spiro Walkman phone

Sony Ericsson has also announced the Spiro Walkman phone. Sony Ericsson Spiro is a dual-band GSM/GPRS/EDGE phone.

Sony Ericsson Spiro comes with a 2.2 inch QVGA display, a 2 megapixel camera and microSD cards up to 16GB and support for MP3 and AAC files. It measures 92 x 48 x 16.75 mm and weighs 90 grams. Sony Ericsson Spiro also features a 3.5mm handsfree socket, Bluetooth 2.1, EDGE, microUSB connectivity, FM radio and social networking integration with Facebook, Twitter. It will be available in Contrast Black, Sunset Pink, Spring Green and Stealth Black colors.

Samsung NB30 Touchscreen Netbook launched

Samsung has introduced another netbook dubbed the Samsung NB30 TouchscreenNetbook. The Samsung NB30 Touchscreen netbook comes with Intel Atom N450 1.66GHz processor, 160GB or 250GB HDD, 1GB RAM and Intel GMA 3150 graphics.

The Samsung NB30 Touchscreen netbook has a 10.1-inch WSVGA touchscreen display with resolution of 1024 x 768 pixels. The Samsung NB30 Touchscreen netbook also features a spill resistant keyoard, 802.11b/g/n Wi-Fi, Bluetooth 2.1, webcam, 6 cell battery, 3-in-1 card reader, three USB 2.0 ports and VGA output and Windows 7 Starter OS.

source: http://www.technologynews.co.in/

Countdown begins for rocket launch with Indian cryo-engine

The countdown to launch a heavy rocket with an Indian cryogenic engine to inject an advanced communication satellite in the geo-synchronous Orbit began on Wednesday at the Sriharikota spaceport in Andhrapradesh, a space agency official said.

"The countdown began at 11.27 a.m. at our Satish Dhawan Space Centre in Sriharikota. All preparations for launching the geo-synchornous satellite launch vehicle (GSLV-D3) carrying the geo-stationary experimental satellite (GSAT-4) on Thursday at 16.27 IST are progressing satisfactorily," ISRO Director S. Satish told the sources.

The spaceport is located on a small island off the Bay of Bengal, about 80 km north-east of Chennai.

The preparations during the 29-hour countdown includes filling up the second stage and four strap-ons of the 416-tonne rocket with about 200 tonnes of liquid propellants.

"In the run up to lift-off, the cryogenic upper stage will also be filled with propellants. Certain mandatory checks and charging of batteries on the 50-meter tall rocket and the 2.2-tonne satellite onboard will be carried during the countdown," Satish said.

Readiness of the ground stations at Sriharikota, Biak in Indonesia and the master control facility at Hasan in Karnataka, about 180 km from here, will also be tested by the space scientists and engineers simultaneously.

India to send two astronauts in space - ISRO

New Delhi: India will send two astronauts into space using an indigenous rocket and an announcement for this is likely to be made within a couple of months, the Indian Space Research Organization (ISRO) said on Tuesday.

In an interview to a private channel, ISRO chairman K. Radhakrishnan said that in the next few weeks, the government may announce approval of India's most expensive scientific programme - that of putting two Indian astronauts in space.

With this, India is set to join the select club of the US, Russia and china that have human space flight capabilities. The announcement has come two days before ISRO's test for an indigenous Geosynchronous Satellite Launch Vehicle (GSLV) rocket.

Radhakrishnan told NDTV that India has technical capabilities for sending astronauts into the space. He said that the government approval for this Rs. 124 billion venture may come in a couple of months.

On being asked if it will be announced in the Prime Minister's Independence Day speech, the ISRO chief confirmed that "the approval and announcement could happen even before that."

Radhakrishnan says ISRO is ready to launch Indian astronauts by 2017. "As of now what we have is a pre-project study," he said, adding that the astronaut programme will be implemented in phases.

The first phase is to test the unmanned crew module and a service module in space four years from now. After that the Geosynchronous Satellite Launch Vehicle (GSLV) will be used to launch the Indian astronauts.

Target to enroll 30 percent of eligible students in colleges by 2020 - Sibal

New Delhi: Human Resource Development (HRD) Minister Kapil Sibal on Tuesday told Parliament thatthe government has set a target of ensuring that 30 percent of eligible students should attend college by 2020.

At present, 220 million students go to schools across the country and only 12.4 percent of them are eligible to go to colleges. By the year 2020, the gross involvement ratio has to be increased up to 30 percent, he said while replying to a debate in Lok Sabha on the Central Universities (Amendment) Bill, 2009.

The bill, moved by the minister on Monday aiming to set up two central universities in Jammu and Kashmir, was later passed by voice vote.

Sibal stressed the need to exponentially expand theuniversity education system and called for a national effort to achieve this goal. "The house should think in terms of next generation," he said.

He said the government has not meted out any discrimination towards any states on allotting 12 central universities, which the government plans to set up across the country.

Asking each state government to identify four or five sites with 500 acres of land to set up the central universities, Sibal said an expert committee would decide the place where the institution could be set up.

The minister, however, opposed the idea of setting up central universities in remote areas where there is no connectivity.

He said the government has already allocated central universities to Karnataka,Orissa, Punjab and Tamil Nadu - states being ruled by non-Congress governments - and the Congress-ruled state of Haryana.

The minister said if the government had political consideration, it would not have allocated central universities to the states being ruled by non-Congress governments.

Sibal, who urged the MPs to set aside political differences, also called for "quality" in the field of university education.

"We need to set up a benchmark (through the central universities)," said the minister, adding that the state universities should also follow suit.

"This is not a quantitative exercise. This is a qualitative exercise," the minister said.

Justifying the government's decision to set up two central universities in Jammu and Kashmir, the minister said it was "for the sake of the people and for the sake of peace and unity".

source: indiaedunews.net

12 lakh new learners at IGNOU in 2010

New Delhi: Indira Gandhi National Open University (IGNOU) recently signed a Memorandum of Understanding (MoU) with the Indian Army for establishment of IGNOU-Army Community Colleges, which will lead to an exponential increase in its total student enrolment.

The student enrolment is expected to rise from 25 lakh in 2009 to 37 lakh in January 2010.

IGNOU's Vice-Chancellor, Professor V. N. Rajasekharan Pillai made the announcement in order to emulate the initiatives taken by the university to celebrate its silver jubilee year starting November 19.

Today, learners enrolled for the university range from as low as 18 years to as high as 90 years of age including school drop-outs, factory workers, farmers, prisoners in Tihar Jail, and sex workers.

Track your lost mobile phone

Got an interesting fact to share.. Nowadays each one of us carry Hi Fi Mobile devices and always fear that it may be stolen.

Each mobile carries a unique IMEI i.e International Mobile Identity No which can be used to track your mobile anywhere in the world.

This is how it works!!!!!!

1. Dial *#06# from your mobile.

2.Your mobile shows a unique 15 digit .

3.Note down this no anywhere but except your mobile as this is the no which will help trace your mobile in case of a theft.

4.Once stolen you just have to mail this 15 digit IMEI no. to cop@vsnl.net

5.No need to go to police.

6.Your Mobile will be traced within next 24 hrs via a complex system of GPRS and internet.

7.You will find where your hand set is being operated even in case your no is being changed.

Indian Institutes Of Technology - Joint Entrance Examination 2010 (IIT - JEE-2010)

Joint Entrance Examination 2010 (JEE-2010)

For admission to undergraduate courses at all IITs, IT-BHU, Varanasi and ISMU, Dhanbad

Examination Schedule:

Date of Examination: 11th April, 2010 (SUNDAY)

Paper 1: 9.00 am to 12.00 Noon

Paper 2: 2.00 pm to 5.00 pm.

Paper-1 and Paper—2 will each have separate sections in Chemistry, Mathematics and Physics. Both papers will be of objective type, designed to test comprehension, reasoning and analytical ability of candidates.

• Syllabus for this examination will be available on the websites

of all llTs.

•The candidate will have the option of submitting the application form either on-line or off –line.

• important dates regarding Application Form and Brochure;

On-line application process: From Sun. Nov. 01, 2009 to Mon. Dec. 07,2009

Off-line application process: From Mon. Nov. 16, 2009 to Tue. Dec. 15, 2009

Last date for receipt of completed hard copy of application forms at IITs: Sat. Dec. 19, 2009

Further details regarding the application process will be published in leading National Dailies and Employment News / Rozgar Samachar on Sat. Oct. 31, 2009.

Organizing Chairman

ANTI-RAGGING HELPLINE

Anti-Ragging helpline has become operational since 20.06.2009.

The Toll-free 'Anti-Ragging helpline Number' is

1800-180-5522

The helpline is operated in the following languages:

1. Hindi

2. English

3. Tamil

4. Telugu

5. Malayalam

6. Kannada

7. Oriya

8. Bengali

9. Marathi

10. Punjabi

Source: http://education.nic.in/UHE/Antiragging.asp

Abdul Kalam to visit Mumbai engineering college

Dr. A.P.J Abdul Kalam - the ex-president of India, will grace the closing ceremony of the Silver Jubilee Celebrations of K.J. Somaiya College of Engineering (KJSCE) on September 26, 2009.

Young engineers at KJSCE will be displaying their innovative projects on this occasion. Dr. Kalam's interaction with the young minds will provide them with insights and unleash their potential which will help them flourish and reach greater heights.

A major highlight of the year was the accreditation of all the five courses in the college by the National Board of Accreditation. The college also acquired permanent affiliation to the University of Mumbai in the silver jubilee year.

Dr. R.A. Mashelkar, the ex-Director General of Council of Scientific and Industrial Research (CSIR), at the opening ceremony of the 25th year of KJSCE on 12th September, 2008 emphasized the fact that technology is in concurrence with society and humanitarian causes.

He echoed the theme of the college for the 25th year - The Human Face of Technology; sensitizing the budding engineers with their environment and urging them to take technology to the masses; an idea reflected every October at Abhiyantriki, the technical festival of KJSCE.

Last October had robots abound, classrooms turned into gaming arenas, debates on nuclear technology over canteen tables and project intricacies as the latest gossip.

"The silver jubilee year has lent a golden sheen to the students' technical abilities at KJSCE. It would be interesting to hear Dr.Kalam's views on the theme during the 25th year closing ceremony celebrations", an institute official told NNE.

Prakalp, the platform for young technicians of Mumbai, saw engineers competing and innovating on their pet fields in form of futuristic project models.

The National conference on 'Emerging Trends on Computers, Communication and Information Technology' conducted in March 2009, jointly by the Information Technology, Computer Engineering department together with IEEE Bombay Section, IETE Mumbai Centre, ISTE KJSCE Chapter, CSI Mumbai Chapter and University of Mumbai definitely set the ball rolling.

It saw some of the best ideas come up. It was followed by another National Conference on 'Global Challenges for Deemed universities in Indian Education by 2020' on 4th April 2009.

Adding a feather to the cap was the Orion Racing India - a team of engineers from KJSCE. The team is into automobile design and fabrication for the past three years. Orion Racing India is the most successful Indian team to participate in an international engineering design event.

Orion Racing India participates in Formula Student Germany, an international car designing event held at the Hockenheim ring, a renowned Formula 1 racing circuit.

Symphony, the annual cultural festival was literally a 'symphony' of different elements-of culture, of young enthusiasm, of budding talent; each lending its own individualistic beat. With seventy-five institutes from all over Mumbai getting in above five thousand students, the celebrations scaled new heights.

Well, if technology is human, then culture is the force that binds it into a society. At Somaiya, traditions which are both centuries old or young are cherished. At 'Garba Nite', Somaiyaites donned their traditional outfits, picked up their dance sticks and threw in some traditional beats on the dance floor. If Garba had Somaiya on its feet, then the Dahi Handi celebrations had its own pomp and fervor.

IIT Delhi helping Ethiopia become tech-savvy

New Delhi: Many students in Ethiopia are studyingengineering and technology in virtual classrooms, some of their teachers seating in the Indian Institute of Technology, Delhi (IIT-D) which is helping that country become tech-savvy.

The idea to empower Ethiopia's university students was mooted by its ambassador to India and even its prime minister was eager to have an association with IIT Delhi.

"The Ethiopian government is making a rapid expansions in education but it doesn't have the required infrastructure. The ambassador talked to us and then the process moved. Even their prime minister was very eager for this association," M. Balakrishnan, dean of post-graduate studies at IIT Delhi, told sources on Sunday.

"They want to churn out tech-savvy students and here we are playing a role. We have designed four courses for the Addis Ababa University," said Balakrishnan, who is the key official in this project.

He said two courses - construction technology andmanagement, and chemical engineering - have been taught for a semester. The other two courses - computer engineering and manufacturingengineering - will complete their first semester in a couple of months.

"Initially, we have a four-year agreement with Ethiopia. Our job is to develop curriculum, set up a laboratory, give teachings both through virtual classroom and face-to-face mode. We are also responsible for students' evaluation. But the degree will be awarded by the Addis Ababa University," said Balakrishnan, a senior professor in the school of computer science at the IIT.

He said that Ehtiopia has set a target of producing 10,000 science and engineeringstudents at the higher education level in next five years or so, and for this it has availed of the expertise of the IIT-Delhi as one of the partners. It wants to become technology-savvy and "we are facilitating that".

The elite institute is delivering the courses via a two-way video/audio link. "This helps make interaction two-way and participatory. Students ask questions and we answer them while sitting in our institute," explained Balakrishnan.

At least 46 faculty members are involved in the project and the IIT-Delhi offers up to 70 hours per week of instructions. There are around 50 students in each semester in each course.

"During every semester, the chief instructors of all subjects go to Ethiopia once to teach students in person. The whole idea is to make the learning process better and smoother. We are happy with the outcome so far," he added.

Source: indiaedunews.net

No board exam for Class X in CBSE from 2011

NEW DELHI: Beginning 2011, Class X board examinations will become a thing of the past. Instead, students will be promoted to senior secondary through an internal assessment. This was announced here on Monday by Union Human Resource Development Minister Kapil Sibal as a major stress buster for students.

Grading for 2010 boards

Since the decision has been taken in the middle of the academic year, students in Class X this year will have to appear for the board examination as scheduled, but will be graded instead, Central Board of Secondary Education (CBSE) chairman Vineet Joshi said. Students will be graded into nine categories, from exceptional to unsatisfactory.

Though initially there were indications that students changing schools after Class X would have to appear for the board examination, Mr. Joshi said that instead they would appear for an online/offline/on-demand assessment and would be issued certificates on pre-printed stationery supplied by the CBSE and attested by the regional offices of the Board.

Students who may need certification of the Board at a later stage to change schools can also appear for same assessment.

It will also be available to students who want an independent assessment of their academic skills.

Source: Hindu

IIMC to have four more branches

New Delhi: The Indian Institute of Mass Communication (IIMC) will have four more branches - one each in Jammu & Kashmir, Mizoram as also one each in the Southern and Western India.

Minister for Information and Broadcasting, Mrs. Ambika Soni announced this at the 42nd Convocation function held at IIMC, New Delhitoday.

The Minister said that these Institutes would be set up in a phased manner and proposals will be firmed up soon in consultation with the concerned agencies and the State Governments. The Minister also said that IIMC will be upgraded as an International Media University.

The Ministry is working out the modalities to develop this Institute into a world class media education, training and research University. After upgradation to an InternationalMedia University, IIMC will be able to award degrees in addition to the Post Graduate Diplomas it currently awards.

IIMC will also be able to start courses at the Under-Graduate and Post Graduate level and award M.Phil and PhD degrees, Soni elaborated.

The Guest of Honour, Shekhar Gupta congratulated the class of 2009 and urged them to keep intact the essential skill of ‘curiosity’ to succeed in journalism. He also advised the budding journalists to ensure credibility in all their future assignments.

The Chairman IIMC and Secretary I&B, Raghu Menon conferred the Diplomas on 243 students of Post-graduate Diploma course in Advertising and Public Relations, English and Hindi Journalism, Radio & TV Journalism including the 58 students of English and Oriya Journalism of Dhenkanal Branch of IIMC, based on the reports of the respective course Directors.

The Director IIMC and Additional Secretary I & B, Stuti Kacker presented the Director’s Report on the occasion of the 42nd convocation. The Director informed that most of the successful Diploma course graduates have already been absorbed by major media organizations despite the slowdown. Ambika Soni presented the awards to the meritorious students.

4th SEMESTER ASSIGNMENTS JULY 2009 & JANUARY 2010

4th SEMESTERASSIGNMENTS JULY 2009 & JANUARY 2010

(MCS-041, MCS-042, MCS-043, MCS-044, MCSL-045)

Course Code : MCS-041
Course Title : Operating Systems
Assignment Number : MCA(4)/041/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2009 (for July, 2009 session)
15th April, 2010 (for January, 2010 session)

This assignment has six questions which total carries 80 marks. Answer all questions. 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 for the format of presentation. Answer to each part of the question should be confined to about 300 words.

Question 1:

State the Readers and Writers problem and write its semaphore based solution. Also describe the algorithm. Can the producer consumer problem be considered as a special case of Reader/Writer problem with a single Writer (the producer) and a single Reader (consumer)?. Explain. (20 Marks)

Question 2:

Describe different schemes for deadlock prevention, avoidance and detection with major advantages and disadvantages of each scheme.(10 Marks)

Question 3:

What is thrashing? How does it happen? When are the two mechanisms to prevent thrashing? Describe them.(10 Marks)

Question 4:

What are the factors important for selection of a file organisation? Discuss three important file organisations mechanisms and their relative performance.(10 Marks)

Question 5:

How do you differentiate between pre-emptive and non pre-emptive scheduling? Briefly describe round robin and shortest process next scheduling with examples for each. (10 Marks)

Question 6:

i) What are the main differences between capabilities lists and access lists? Explain through examples. (10 Marks)

ii) What is the Kernel of an operating system? What functions are normally performed by the Kernel? Gives several reasons why it is effective to design micro Kernel. (10 Marks)

Course Code : MCS-042
Course Title : Data Communication and Computer Networks
Assignment Number : MCA(4)/042/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2009 (for July,2009 session)
15th April, 2010 (for January, 2010 session)

This assignment has five questions, which carries 80 marks. Answer all questions. 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 for the format of presentation. Answer to each part of the question should be confined to about 300 words.

Question 1:

i) What are the Nyquist and the Shannon limits on the channel capacity? Elaborate through examples. (8 Marks)
ii) Differentiate between the followings:

a)FDM and TDM
b)Circuit switching and packet switching
c)Virtual circuit and diagram
d)Stop and wait protocol and sliding window protocol (12 Marks)

Question 2:

i) Compare the features of different 10 Mbps, 100 Mbps and 1000 Mbps Ethernet technologies.(5 Marks)
ii) Explain the basic operation of collision detection in Ethernet.(5 Marks)
iii) Compare the advantages of fibre optics over copper wire and coaxial cable. (5 Marks)


Question 3:

i) Describe how is the TCP/IP protocol stack organised compared to the ISI/OSI protocol stack. (5 Marks)

ii) Describe the relationship between IP addresses and MAC address.(5 Marks)

Question 4:

i) Why use FTP to transfer files rather than e-mail ? (5 Marks)
ii) What is the purpose of time to live field of the IP datagram header?(5 Marks)

iii) How does the 3-way handshake mechanism for creating a TCP connection work?(7 Marks)
iv) What is the difference between a port and a socket?(3 Marks)

Question 5:

i) Explain the difference between distance vector and link state routing protocol through examples. (9 Marks)

ii) Why is the security of web very important today? Also outline the design goals and features of SSL 3.0.(6 Marks)

Course Code : MCS-043
Course Title : Introduction to Database Management Systems
Assignment Number : MCA(4)/043/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2009 (For July, 2009 Session)
15th April, 2010 (For January, 2010 Session)

This assignment has four 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.

Question 1:

Consider a University like IITs having different Engineering departments. The University offers PhD, Master of Technology and Bachelor of Technology programmes in various Engineering disciplines. Each department has a number of full time faculty members - Professors, Associate Professors and Assistant Professors. Several Guest faculties can also be visiting the University. A student may take up only one programme at a time from the University.

(a)Draw the EER diagram for the hospital showing all entities, relationship, aggregation, generalisation and specialisation. (5 Marks)

(b)Create the normalised tables till 5 NF, highlighting all 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 related to any University). (5 Marks)

(c)Draw the class diagram for the University above and relate it to database design as done in part (b). (5 Marks)

(d)Create an embedded SQL query to find out the list of faculties who have been involved with UG, PG and doctoral programmes. (2 Marks)

(e)List the contents of the catalogue considering that the system has been developed using a commercial database management system? (3 Marks)

Question 2

(a)Consider the following relations: (6 Marks)
Faculty (fa_id, fa-name, f-designation)
Student(st_ id, st_name, st_address, st_programme, st_programmeRegistrationdate)
Project_Consultation (fa_id, pa_id, pc_consultationDate, pc_hours)


You may assuming that pc_hours represents the number of hours of consultation on a particular day.

Write the SQL commands to find the total number of hours spent by each faculty on each student.

Now, assume that there are 100 faculty records, 5000 student records and 50000 project consultation records. Also assume that in a block of data 10 faculty records or 5 student records or 50 project consultation records can be accommodated. Find the minimum cost for the query given above, if Block Nested- Loop join is performed. Also find the query evaluation plan for the given query.

(b) What is a timestamp? Explain a timestamp based protocol that ensures serialisability during concurrent transactions with the help of an example involving at least two concurrent transactions that are trying to modify the same data items. List the differences between timestamp based protocols and locking protocols. (4 Marks)

(b)Consider the relations given in part (a) of this question. Design two types of users – faculty and the student. The faculty is allowed to view and change the data in Project consultation relation, but not allowed to change any thing in the Faculty and Student relations. The student users can only view the data about her/him. Design the suitable access control and use SQL to grant the desired access rights to the users. Make suitable assumptions, if any. (3 Marks)

(c)Describe the process of distributed deadlock detection with the help of an example. (3 Marks)

(d)Explain the 2 phase commit protocol with the help of an example. (2 Marks)

(e)Explain the log based recovery scheme with deferred database modification approach with the help of an example. (2 Marks)

Question 3:

(a)A University like IGNOU maintain a list of published blocks and its sales in its store management system. A block is a part of a course. All these publications have an ISBN number, block title, price and the course code this block belongs to. A student can purchase one or more blocks from the store. Design a suitable object oriented database management system with the help of ODL. Also write a query that finds the price that is to be paid by one student on purchase of some blocks. (5 Marks)

(b) Create a semi structured data using XML for a software company employee (assume a maximum of 5 employees). You may include the fields – ID, Name, contact phones, address – home, office and emergency. Create a suitable DTD for this document. What kind of support is build by commercial DBMS for XML? (5 Marks)

(b) Consider a data warehouse of a departmental store that contains three dimension tables and one fact tables – Dimension table of Year, Product and Branch and fact table of Sales. Create the star schema for the data warehouse with some sample data. Explain the process of ETL for the data warehouse so designed. (5 Marks)

(c)What are classification, clustering and association rule mining? Explain the Apriori algorithm for association rule mining with the help of an example. (5 Marks)

Question 4:

(a) Explain the following with appropriate examples.
(i)Multimedia Database
(ii)Geographic Information Systems
(iii)Web Database
(iv)Data Grid
(10 Marks)

(b) Explain the following in the context of PostgreSQL
a.oid and tableoid
b.R-Tree and Hash indexes
c.Isolation levels supported by PostgreSQL
d.Postmaster process
e.Query processing
(5 Marks)

(c) Explain the following in the context of Oracle
a.Integrity constraints
b.Tablespace
c.Branch and leaf index blocks
d.Locking mechanism
e.Commit and savepoints (5 Marks)


Course Code : MCS-044
Course Title : Mini Project
Assignment Number : MCA (4)/044/Assign/09
Assignment Marks : 100
Maximum Marks : 25%
Last Date of Submission : 15th October, 2009 (For July, 2009 Session)
15th April, 2010 (For January, 2010 Session)


There are eight questions in this assignment, which carries 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 Programme Guide for the format of presentation. Assumptions made if any, should be stated.

Background and Project Specifications:

ABC University has different course on offer. It wants to provide web support to their students mainly in Course Registration and Examination. In Online course registration, student can register for different available courses of the University after he/she filled up online registration form with details of DD/Cheque no. etc. The filled up students form will stored in a database and will be send to the administration section. Administration after checking the eligibility criteria, fee details and payments will provide the user name, enrollment number, and password to the students. The goal of second module Online Examination is to develop a system for testing a student’s knowledge of different available courses. Once student is eligible for examination based on duration, fees payments, attendance etc, student can fix up the time for examination of a course. After authentication using user name and password of the student. The system will generate questions at random from a database. Some questions will be factual, multi-choice questions. Some will require an exact answer. For example, the computer may generate a random 8-bit binary integer and the student will be asked to convert it into a decimal value. The examination system should be diagnostic and locate the student’s problems. For example, if students perform well in one area, further questions at the same level in the same area will not be asked.

Question 1:

Describe the Systems Development Life Cycle (SDLC) that suits the above specifications. Also, evaluate the systems requirements. (10 Marks)

Question 2:

Perform and evaluate feasibility studies like cost-benefit analysis, technical feasibility, time feasibility and operational feasibility for the project. Project Scheduling should be made using both GANTT and PERT charts. (10 Marks)

Question 3:

Design and draw the data flow diagrams (DFD’s) up to the required levels, entity-relationship (ER) diagram and also produce a data dictionary. (20 Marks)

Question 4:

Create the systems flow chart and state transition diagrams. (10 Marks)

Question 5:

Decide the S/W requirement specifications and H/W requirement specifications. (5 Marks)

Question 6:

Plan the systems design phase and distinguish between logical and physical design requirements.
(5 Marks)

Question 7:

Perform normalization to the required normal forms for the unnormalized tables. (10 Marks)

Question 8:

Design various test cases for different testing techniques/strategies. (10 Marks)


Course Code : MCSL-045
Course Title : UNIX and DBMS Lab
Assignment Number : MCA(4)/045/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2009 (For July, 2009 Session)
15th April, 2010 (For January, 2010 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-A: MCS-041

Question 1:

Write and demonstrate the UNIX commands for the following:

(a) Find the number of users currently logged in.
(b) Find the number of lines in a specified file.
(c) Kill a background process.
(d) Display the current environment variables.
(e) Change the file permissions to Read only for everyone on a data file created by you.
(f) Find the lines in a file that contains the string like b or ab or aab or aaab or aaaa…b
(g) Transfer the names of all the files in a directory to a file.
(h) Display a file such that only 10 lines get displayed at one time.
(i) Create a file containing 10 lines, split it into two files containing 5 lines each.
(j) Display only those lines that are common in two different files.
(5 Marks)

Question 2:

(a) Create a text file containing name, ID and addresses of students. Write a shell program that displays only the name and ID of the students. (5 Marks)

(b) Write a shell script that counts the number of occurrences of the word “IGNOU” in a file. (5 Marks)

(c) Write a shell script that displays the smaller of the two values given as arguments to it. (5 Marks)

PART-B: MCS-043

Question 1:
A database Management system is to be created for a Study Centre to keep track of the students and the assignment records of the students. The database records the date of submission of assignment, the date of evaluation, the date of viva, the date of declaration of results, who evaluated the assignment, and the mark list description in which the assignment marks were sent to Regional Office. The database also maintains the details of the evaluators. Please perform the following activities for the description as given above.

(a) Design the database with suitable integrity constraints and create the database. (3 Marks)
(b)Write the following queries using SQL:
(i)Find the List of the students who have not submitted even a single assignment.
(ii)Find the details of the evaluators by whom average marks awarded are more than 70%.
(iii)Find the students who have passed more than 5 assignments.
(iv) Find the list of students who have not appeared in viva. Make and state suitable assumptions, if any.
(2 Marks)
(c) Assume two views for the above table. The first view is for the data entry person who is only allowed to enter new data in all the three tables, however, once he/she enters the data he/she is not allowed to modify it. Second for the students who can see only the marks that he/she has obtained in his/her submitted assignments. Create the two views and one user of the each view. Give the suitable access rights to the views/users. (4 Marks)
(d) Write a procedure that creates a mark list for the specified subject and evaluator. The mark list at the top displays the subject code (course code) and title and the name of the evaluator. The details shown in the mark list are – student ID, student name, student marks and equivalent grades. Please note that Grades are to be calculated from marks by this procedure as per the following scheme –
>=75% and above A
>=60% and <>=50% and <60% C
<50% F
(4 Marks)

(e) Perform the following activities:
(i) Create a trigger that prints the assignment result of the student if he fails in that assignment.
(ii) Create a trigger that automatically gives a grace of a maximum of 2%, if a student gets 48% marks in the assignment. For example, if an assignment marks are entered as 48%, then the trigger will automatically convert the marks to 50%, so is the case of student who gets 49% marks. His/her marks will be updated to 50% by the trigger.
(4 Marks)
(f) Create a transaction to enter the mark list obtained from an evaluator of a specific assignment. (3 Marks)

for solved assignments solutions please logon towww.spynethub.com

IGNOU MCA 2nd sem ASSIGNMENTS JULY 2009 & JANUARY 2010

2nd SEMESTER

MCS-021, MCS-022, MCS-023, MCS-024, MCSL-025

Course Code : MCS-021
Course Title : Data and File Structures
Assignment Number : MCA(2)/021/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th October, 2009 (for July, 2009 session)
15th April, 2010 (for January, 2010 session)

This assignment has four questions which carry 80 marks. Answer all the questions. Each question carries 20 marks. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide. Ensure that you don’t copy the program from course material or any other source. All the implementations should be in C language.


Question 1:

How can the following operations implemented on an array so that the time taken for each of the operations does not depend on the size of the array ‘n’:

(i)Delete the ith element of an array (1 < = i < = n) (ii)Delete the ith element of a sorted array. The remaining array has to stay sorted. Question 2: Map the operations on Stacks and Queues to operations on a Deque. Explain the merits of using a Deque to implement a Stack. Also, explain the merits of using a Deque to implement a Queue. Question 3: Implement a modified version of Dijkstra’s algorithm such that it finds the shortest paths from a given vertex to all other vertices in a network. Question 4: Show the effect of making the following insertions into an initially empty red-black tree: 30,40,20,90,10,50,70,60,80 Course Code : MCS-022
Course Title : Operating System Concepts and Networking
Management
Assignment Number : MCA(2)/022/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2009 (for July, 2009 session)
15th April, 2010 (for January, 2010 session)

This assignment has five questions. Answer all questions. 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 for the format of presentation. Answer each part of the question should be confined to about 300 words.

Question 1:
a) Describe the structure of 5 classes of IP address. Also draw the network configuration of your study centre/organisation showings IP addresses assigned your organization by ISP. How do these classes differ? How do you identify a particular classes?
(5 Marks)
b) How does DNS improve the name resolution?
(5 Marks)
c) What is real time OS? How it is different from the traditional OS.
(5 Marks)
Question 2:

a) Write the Linux command for the followings :

i) to display the information about LS command

ii) to sort all the files in ascending order in IGNOU directory

iii) to kill a particular process

iv) to run any process in a background

v) to list the users currently logged on to the system (5 Marks)

b) What are the different kinds of file systems available to Linux operating system ? Discuss.
(5 Marks)
c) How would you set the IP address of a LAN card in Linux ?
(5 Marks)




Question 3:

(i) How do you share files, folders and drive in Window XP? Why is sharing an entire drive is not recommended ?
(5 Marks)
(ii) Describe the role of the primary and backup domain controller in enhancing security in windows 2000. (5 Marks)

(iii) What are the shared folders in windows and why are they used?
(5 Marks)

(iv) Write the purpose of VPN and name some VPN protocols supported in windows 2000.
(5 Marks)

Question 4:
(i) What is a Instruction Detection system (IDS)? (5 Marks)

(ii) What are the two general methods of implementing network security by firewalls?
(5 Marks)

(iii) Distinguish between Symmetric and Asymmetric Cryptography? (5 Marks)

(iv) List different types of malicious codes and describe their features.
(5 Marks)

Question 5:
i) Write a Linux Shall Script to shift all characters in a file forwarding five characters i.e. ‘a’ become ‘f’. (5 Marks)
ii) How does information flow from the top layer to the bottom layer in the OSI model.
(5 Marks)



Course Code : MCS-023
Course Title : Introduction to Database Management Systems
Assignment Number : MCA(2)/023/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2009 (For July, 2009 Session)
15th April, 2010 (For January, 2010 Session)


This assignment has four questions. Answer all questions of total 80 marks. 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.

Question 1: (20 Marks)

(i)List at least 8 advantages of Database Management System. Explain each of the advantage with the help of an example each.

(ii)What are the functions of a Database Manager in a Database Management System? Explain each of these functions with the help of an example.

(iii)Define the following term in the context of Relational Model with the help of an example each:

a.Domain
b.Tuple
c.Relational Instance
d.Super Key and Candidate keys
e.Domain constraints
f.Entity integrity constraints
g.Key Constraint
h.Referential integrity constraints

(iv)Consider the following relations:
Student (st_ID, st_name, st_programme)
Faculty (fa_ID, fa_name, fa_programme)
Mark (st_ID, ma_subject, ma_marks)

You may assume that a student can take only one programme and a faculty is associated with only one programme. The Mark relation represents marks of the students in various subjects. Enter some meaningful data in the relations as above and demonstrate the use of following relational algebraic operations. Please note that you must write the equivalent query in English also. For example, the Union operation can be demonstrated using the following English Query – Find a complete list of student and the faculty.





You may use more that one operator in a query.

a.UNION
b.INTERSECTION
c.SET DIFFERENCE
d.
e.CARTESIAN PRODUCT
f.SELECTION
g.PROJECTION
h.JOIN
i.DIVISION


(v)A Book store manages inventory of Books in its warehouse. The orders are given by the store to the suppliers of books. On receipt of books the receipt challan is verified against the orders. A supplier may supply part order also, however, they are expected to supply the all the items in a specified period. Any sale of the book is also recorded in the system and the books are reordered as per the need. A book is identified by its ISBN Number and their can be many copies of the books available in the store at a time. An order has unique order number. An order may be for more than one book. A supplier is identified by a unique supplier number. List all the entities, attributes of each entities and relationships among entities. Draw the E-R diagram for the Book store. You may use the concept of keys, cardinality etc. in a proper way. Make and state suitable assumptions, if any.

Question 2: (20 Marks)

(i)You have explained the concept of Referential Integrity in Question 1. Database Modifications may also result in loss of referential integrity. How can you preserve database integrity when database modification results in loss of Integrity? Explain it with the help of examples. Some of the integrity problems may be caused by data redundancy. However, many people claim redundancy is beneficial too. “ Redundancy of data is many times beneficial” Justify the statement, also describe the situation when redundancy will mess up the current data base status, at that instance of time what actions you will prefer to take.

(ii)Consider the following relation for a University:
Student_Record ( ID, Name, date of birth, age, address, programme, subject code, subject name, subject credits, teacher ID, teacher name (who taught that subject), teacher qualification, date of evaluation of the subject, marks)
A teacher can teach many subjects. A student can enrol only for one programme at a time. A programme may consist of a number of subjects. A student may appear for a subject more than once.
Identify the functional dependencies in the relation given above. Normalise the relational up to BCNF. Make suitable assumptions, if any

(iii)List the features of the following file organisations giving their advantages and disadvantages:
a.Heap Files
b.Sequential file organisation
c.Indexed file organisation
d.Hashed file organisation

(iv)What is the role of secondary indexes? “Secondary Indexes are more useful than the primary Indexes.” Is this statement true? Justify your answer using an example. What is the need of multi-level indexes? Explain why is binary tree not used for implementing Indexes? Explain the purpose of inverted file organisation.

(v)Given the Book Store system in problem 1 (v). Create the suitable relational design for the E-R diagram so created. Identify all the constants on various attributes and tables. The table should be normalised and properly structured along with field names and constraints. You must also identify the set of possible queries and reports for the database. On the basis of the proposed queries and reports identify what indexes would you like to maintain for the database.


Question 3:
(20 Marks)
(i)Consider the following relations:
Teacher (te_ID, te_name, te_address)
Student (st_ID, st_name, st_programme)
Teach (te_ID, st_ID)
Perform the following operations on these tables using SQL
a.Create the three tables giving suitable domains and constraints including referential actions.
b.Add one additional filed st_qual in the teachers table, Create a secondary index on teacher name and drop any constraint that you have created in step (a)
c.Create a view named Student_Teacher that contains the names of student and the teachers.

(ii)Consider the following relations:
Subjects (su_code, su_title, su_fee, su_credit)
Student (st_ID, st_name, st_programme)
Result (st_ID, su_code, dateofresult, marks)
Assume that a student needs to take the subject again if he/she gets less than 40 marks. Now, perform the following queries using SQL:
a.Find the List of Students who has passed the subject whose title is.” Computer Architecture”
b.Find the students of MCA programme who has taken examination of at least one subject.
c.Create a course wise list of the student in the alphabetical order of student names
d.Calculate the total fee that is due on all the students. You may assume here that a student has to pay fee for a course if he fails or passes in the course.

(iii)Explain the ‘ACID’ properties of transaction with the help of an example each. Also explain the problems of concurrent transactions with the help of an example each.

(iv)What is a serialisable schedule? Explain with the help of an example. How does two phase locking protocol endures a serialisable schedule? Discuss with the help of a schedule and its precedence graph.

(v)You have designed the relations, query and reports for the store database in question 2 (v). Now, implement your design using SQL in a suitable RDBMS. Enter meaningful data and test your queries and reports.

Question 4: (20 Marks)

(i)What is the recovery in database system? How can you use logs to recover from a failure? Explain with the help of an example. How can a checkpoint help in the process of recovery? Explain this with the help of an example.

(ii)How does database security differ from database integrity? Explain with the help of an example. Assume the results database of a University as created by you for answering question 2 (ii), create an authorisation matrix for the result relations. Make suitable assumptions, if any.

(iii)Why is data fragmentation needed in distributed databases? Explain the horizontal and vertical fragmentation process with the help of examples.

(iv)What is client server computing? What are its advantages? Explain the two tier model of client server? How is it different from 3 tier model? Explain with the help of an example.

(v)You have designed and implemented the relations, query and reports for the store database in question 2 (v). You need to identify at least two possible transactions for the store database system. Identify two different types of users and create access matrix for them. Propose a suitable recovery mechanism for this database.


Course Code : MCS-024
Course Titlle : Object Oriented Technologies and Java
Programming
Assignment Number : MCA (1)/024/Assign/09
Assignment Marks : 100
Maximum Marks : 25%
Last Date of Submission : 15th October, 2009 (For July, 2009 Session)
15th April, 2010 (For January, 2010 Session)

There are eight questions in this assignment of total 80 marks. Rest 20 marks are for viva-voce. Answer all the questions. While writing your programs, give appropriate comments to increase understandability. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.

Question 1 :

a) What is Object Oriented Programming? Explain the advantages of Object Oriented Programming over structured programming. (5 Marks)

b) What is encapsulation? Explain the advantages of encapsulation. (5 Marks)

Question 2 :

a) Explain why Java is platform independent. Also explain advantage of platform independence. (5 Marks)
b) What are different relational operators in Java? Write a Java program to
explain the use of relational operators. (5 Marks)

Question 3 :

a) What is variable size array? Write a program to explain the use of variable
size array in Java. (5 Marks)

b) What is need of static method? Explain why main method in Java is always static. (5Marks)

Question 4 :

a) What is inheritance? Why abstract classes are used in inheritance?
Write a program in Java to explain use of abstract class in multilevel inheritance. (5 Marks)

b) Explain the need of package. Also explain different access rules for packages in Java programming. (5 Marks)

Question 5:

a) What is an exception? Explain different types of exceptions in Java.
Also explain haw an exception subclass are created, in Java. (5 Marks)
b) Differentiate between String and String Buffer classes. Also write a
program to append a given string. (5 Marks)

Question 6 :

a) What is multithreading ? Explain how synchronization is achieved in a
multithreaded program in Java. (5 Marks)

b) Explain how files are handled in Java ? Write a program in Java to create a
file and copy the content of an already existing file into it. (5 Marks)

Question 7:

a) What is Layout Manager? Explain different layout available in Java. (5 Marks)

b) What is socket? Explain basic networking features of Java. (5 Marks)

Question 8 :

a) Explain how databases are connected to a Java program. (2 Marks)

b) Explain difference between applets and application programs. (2 Marks)

c) Explain the use of finalize() methods of Java with an example. (2 Marks)

d) Write a program in Java to show the use of checkbox and choice list components. (2 Marks)

e) Explain the use of GET and POST methods in servlet programming.
(2 Marks)


Course Code : MCSL-025
Course Title : Lab Course
Assignment Number : MCA(2)/025/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Date of Submission : 15th October, 2009 (For July, 2009 Session)
15th April, 2010 (For January, 2010 Session)


This assignment has four parts. Answer all questions of each part. Each part is of 10 marks. Lab Records of each part will carry 10 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 for the format of presentation.

PART-I: MCS-021

Question 1:

Sort the following array items using quick sort method.
65 24 56 47 35 10 90 82 31 34 11
Write an algorithm in C to implement this and find its time complexity. (6 Marks)
Question 2:

Write an algorithm for converting an infix expression into a postfix expression using stack. Illustrate the steps for the following expression.
(((a+b)*c) / (d+e)) (4 Marks)

Note: You must execute the program and submit the program logic, sample inputs and outputs along with the necessary documentation for this question. Assumptions can be made wherever necessary.
PART-II: MCS-022

Question 1:

Show a sorted list of files in your home directory those contain the word “computer” inside them.
(2 Marks)

Question 2:

Set the execution time of a job so that it can run automatically after 15inutes.
(2 Marks)

Question 3:

Create two global groups and configure so that users from both groups should be able to access some command folder named “MYDOC”.
(3 Marks)

Question 4:

When you install Modem, set the option to disable call waiting on your computer.
(3 Marks)

PART-III: MCS-023

Question 1:

“HomeCook” Private Ltd. has main products like pressure cookers, cookwares, water purifiers, food processors etc. The company markets its products to wholesalers all over the country and dealers sell them further to customer. The company has eight regional offices and many sales persons are attached to regional offices. Salespersons contact dealers and explain about products, incentives offered, training programs for wholesalers and demonstrations for customers etc. Dealers place orders with the salespersons attached with the regional office of their location. After receiving goods they make payments, which may be in installments. Company would like to develop a system to monitor sales of different products, performance of salespersons and orders from wholesalers. You are asked to create the database of “HomeCook” Private Ltd in MS-Access, which must provide the following functionalities:

Query support
Report generation
Easy input facility for new data
Keep details about Payment, Products, Performances, Sales etc.
Maintain necessary details about Regional offices, Dealers, Salespersons etc.

After creating the database you must perform the following tasks:

(i)Design a report to display the daily, monthly and annual income of each region. Also, show the profit /loss statistics.

(ii)Find out how many dealers placed the orders last year but did not made full payment till now.

(iii)Design a report to display performance of the salespersons with their region and dealer wise in term of sales of products.

(iv)Design a suitable form for storing basic information and salary details of salespersons. Design and implement the necessary tables.

(10 Marks)

PART-IV: MCS-024

Question 1: Create a class Old which contains x and y co-ordinates as int. Define the default constructor, parameterized constructor and void print() to print the co-ordinates. Now reuse this class in New adding a new dimension as z of type int. Define the constructors for the subclass and override the method void print() in the subclass. Implement main() to show dynamic polymorphism.
(4 Marks)

Question 2:
Write a Java program to create a class that contains an array of integers containing numbers 21,22,..29 with member methods print() which prints the elements of array and reverse() method reverses the elements of array using recursion.
(3 Marks)

(i)Write a Java program to implement the following given pattern of the numbers on the screen:

1 2 3 4 5

1 2 3 4

1 2 3

1 2

1 (3 Marks)

Note: You must execute the program and submit the program logic, sample inputs and outputs along with the necessary documentation for this question. Assumptions can be made wherever necessary.

for solved assignments solutions please logon to www.spynethub.com

Regards,

SNH Team,

www.spynethub.com