SpyNetHub

2013-08-10T01:23:00.001+05:30

DOWNLAD IGNOU STUDY MATERIAL

IGNOU STUDY MATERIAL

2013-08-10T01:16:00.002+05:30

Study Materiel Dispatch status - IGNOU

2013-08-10T01:08:00.001+05:30

Night view of Vijayawada - 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

2010-04-16T15:09:00.000+05:30

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

2010-04-16T15:06:00.000+05:30

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

2010-04-14T15:13:00.002+05:30

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

2010-04-14T15:13:00.001+05:30

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

2009-12-02T15:13:00.000+05:30

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

2009-11-03T10:17:00.000+05:30

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

2009-10-12T10:32:00.000+05:30

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)

2009-09-26T12:32:00.000+05:30

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

2009-09-24T10:49:00.000+05:30

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

2009-09-23T10:34:00.000+05:30

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

2009-09-16T10:31:00.000+05:30

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

2009-09-10T18:02:00.000+05:30

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

2009-09-09T14:43:00.000+05:30

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

2009-08-28T14:19:00.000+05:30

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

2009-08-24T15:59:00.000+05:30

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

Download IGNOU Assignments from www.spynethub.com for free

2009-08-24T15:47:00.000+05:30

Hi all,

Downalod IGNOU assignmetns from www.spynethub.com for free.Just logon to ur account and click on ignou assigments download your assignments.

Link : www.spynethub.com

Regards,

SNH Team.

IGNOU MCA 1st sem Jan 2009 Assignments

2009-08-21T10:01:00.000+05:30

Course Code : MCS-011
Course Title : Problem Solving and Programming
Assignment Number : MCA(1)/011/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th April, 2009 (For January Session)
15th October, 2009 (For July Session)

There are five questions in this assignment, which carries 80 marks. Rest 20 marks are for viva-voce. Answer all the questions. 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.

Q1:
(a) Write a simple program to find out how many of the numbers from 1 to 10 is greater than 4.

(b) Write a program in C that prompts the user with the following lines:
a) Add two integers
c) Compare two integers for the larger
t) Test an integer for odd or even
q) Quit

(c) Write a function celsius() to convert degrees Fahrenheit to degrees Celsius.
Note: The conversion formula is °C = 5/9 * (°F - 32) (5 X 3 =15 Marks)
Q2:
(a) Write a program to print this triangle:
*
***
*****
*******
*********
************
(b) Write a program to compute the average of the ten numbers 1, 4, 9, ..., 81, 100 (i.e., the average of the squares of the numbers from 1 to 10). (2 X 10 = 20 Marks)

Q3:
Write a chequebook balancing program of an user’s account. It will use getline() to read a line, which will contain either the word “withdrawl” or “deposit”. The next line will contain the amount of the withdrawl or deposit. After reading each pair of lines, the program should compute and print the new balance. You can declare the variable to hold the running balance to be datatype float, and you can use the function atof() to convert an amount string read by getline() into a floating-point number. When the program reaches end-of-file, it should exit.

For example, given the input
1. deposit
2. 100
3. withdrawl
4. 12.34
5. withdrawl
6. 49.00
7. deposit
8. 7.01
the program should print something like
balance: 100.00
balance: 87.66
balance: 38.66
balance: 45.67 (15 Marks)

Q4:
Using Pointers,
a.Write a line-reversing function.
b.Write the character-counting function.
c.Write the string-concatenation program
d.Write the string-replacing function. (4 X 5 =20 Marks)

Q5:

Write a program which has the following seven functions. The functions should be:

main() this calls the other 6 functions
fget_long() a function which returns a long data type from a file
fget_short() a function which returns a short integer variable from a file
fget_float() a function which returns a floating point variable from a file
fprt_long() a function which prints its single, long argument into a file
fprt_short() a function which prints its single, short argument into a file
fprt_float() a function which prints its single, floating point argument into a file.

You should use fscanf() to get the values of the variables from the input (the file) and fprintf() to print the values to the other file. Pay attention to using the correct format for each of the data types.
(10 Marks)

Course Code : MCS-012
Course Title : Computer Organisation and Assembly
Language Programming
Assignment Number : MCA(1)/012/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th April, 2009 (For January Session)
15th October, 2009 (For July Session)

There are four 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. Answer to each part of the question should be confined to about 300 words.

Q1(Based on Block 1):
(a)Perform the following arithmetic operations using 8-bit binary signed 2’s complement representation for integers. (Please note that the numbers given here are in decimal notation) (3 Marks)

(i)Add – 56 and 38
(ii)Subtract 28 from –100
(iii)Add 69 and 75
Please indicate the overflow if it occurs.
(b)Convert the hexadecimal number ABCDEF into binary and octal. (1 Mark)
(c)Convert the following string into equivalent ASCII code – “Have a nice day”. Include spaces between words in the resultant ASCII. (2 Marks)

(d)Design a logic circuit that converts a four digit binary input to equivalent Binary Coded Decimal value. You need to first create the truth table (please note this circuit should have four input bits, but five output bits; for example, for an input 1001 (decimal 9) the suggested output will be 0 1001 (the BCD value 0 9); and for an input 1010 (decimal 10) the suggested output should be 1 0000 (the BCD value 1 0 )). After creating the truth table design the Boolean expressions for each of the five output bits. Draw the resulting circuit diagram using AND – OR – NOT gates. (5 Marks)

(e)A sequential circuit has two D flip flops A and B, two inputs x and y and one output z. Flip flops input equations and the circuit output are as follows:
DA = xy’ + xA
DB = yB + xA
z = B
(i)Draw the logic diagram of the table.
(ii)Tabulate the state table. (5 Marks)
(f)Represent the number (55.5) 10 using a 32 bit floating point representation format. You may assume that the mantissa is normalised; the exponent is of 8 bits having a bias of 127; and one bit is used for the sign bit. (4 Marks)

Q2 (Based on Block 2):
(a)A RAM has a capacity of 64K × 16. (2 Marks)
(i)How many data input and data output lines does this RAM need to have?
(ii)How many address lines will be needed for this RAM?
(iii)What is the capacity of RAM in bytes?

(b)Consider a RAM of 64 words with a word size of 16 bits. Assume that this memory have a cache memory of 8 Blocks with block size of 32 bits. Draw a diagram to show the address mapping of RAM and Cache, if 4-way set associative memory scheme is used. (4 Marks)

(c)Explain at least three main differences between the Programmed Input/ Output Scheme and Direct Memory Access scheme for data transfer. Also suggest one situation where programmed Input/ output will be preferable over Direct Memory Access. (4 Marks)

(d)Assume that the average seek time for a disk is 50 ms; the disk rotates at 12000 rpm; and each track of the disk have 300 sectors. Calculate the access time for the disk? (2 Marks)
(e)Explain with help of an example, how FAT is different from Inode. (2 Marks)
(Word limit for the answer is 100 words ONLY)
(f)Define each of the following term. Explain the main purpose / use / advantage of the term. (Word Limit for answer of each part is 50 words ONLY) (6 Marks)
(i)Colour Depth of a video card
(ii)Refresh rate
(iii)Shadow mask
(iv)Active Matrix Technology
(v)RAID level 5
(vi)Constant liner velocity disks
Q3 (Based on Block 3):
(a)A new embedded machine is to be designed having limited processing power and memory capacity. The designers decided that the programming languages on this machine should NOT have pointers and recursion but must have subroutine call and return with at most one parameter. The machine also supports arrays. They decided to include only 4 addressing modes. Suggest four best addressing modes for this machine. Give justification of selection of each of the addressing modes. (4 Marks)
(b)Assume a hypothetical machine has a simple addition instruction - ADD A, B. Assume that this machine have only AC, MAR, IR and DR registers. Show the steps for fetch and execute operations of the instructions using suitable micro-operations. Make and state suitable assumptions, if any.
(5 Marks)
(c)Explain with the help of an example, how the following arithmetic and logic micro-operation may be performed in a computer: (2+2+1 = 5 marks)
(i) Add with carry
(ii) Decrement
(iii)Exclusive OR
(d) Explain the purpose of control memory with the help of a suitable diagram. (3 Marks)
(Word limit except diagram is 150 words)
(e) Explain the advantages of using large register file in RISC machine with the help of suitable diagram. (3 Marks)
(Word limit except diagram is 150 words)

Q4 (Based on Block 4):
(a) Write an 8086 assembly Language Program to compare if two strings are of the same length. Assume that the end of a string is the character ‘$’. Make suitable assumptions, if any.
(8 Marks)
(b)Write a program in 8086 assembly language that accepts two input digits and creates a packed BCD number in AL register. (6 Marks)

(c)Write a simple subroutine that adds two numbers that are passed as parameters to the subroutine. (6 Marks)

Course Code : MCS-013
Course Title : Discrete Mathematics
Assignment Number : MCA(1)/013/ Assign /09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th April, 2009 (For January Session)
15th October, 2009 (For July Session)

There are eight questions in this assignment. Answer all questions. 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.

Q1:
a)Make truth table for :

i)q→(p ~ r) p q
ii)p→q q p ~ r (4 Marks)

b)Explain with example the use of conditional connectives in the forming of prepositions. (2 Marks)

c)Write down suitable mathematical statement that can be represented by the following symbolic properties.

i)(x) ( y) P

ii) (x) (y) (z) P (4 Marks)
Q2:
a) Explain different methods of proof with the help of one example of each. (6 Marks)

b) Show whether root 17 is rational or irrational.
(4 Marks)

Q3:
a) What is Boolean algebra? Write uses of Boolean algebra. Explain how you can find dual of a theorem about Boolean algebra. (5 Marks)

b) If p and q are statements, show whether the statement [(p→q) (~ q)] → (~p) is a tautology or not. (5 Marks)

Q4:
a) Make logic circuit for the following Boolean expressions:
i). (x.y + z) + (x+z)
ii). x.y′+ y.z′+z′x′ + x .y
(4 Marks)

b) Find Boolean expression for the output of the following logic circuit given in the Figure a:

(3 Marks)

c) Write a superset for the following sets:

A = {1, 2, 3, 4, 9, 19}, B = {1, 2} and C {2, 5, 11}, D = {1, 3, 5}

Also tell whether set B is a subset of set C or not. (3 Marks)

Q5:
a) Draw a Venn diagram to represent followings:

i)(A B) (C~A)
ii)(AB) (BC)
(4 Marks)

b) Give geometric representation for the following:

i){ 3, 1} x R
ii){-1, -1) x ( -2, 3)
(4 Marks)
c) What is principle of strong mathematical induction? In which situation this principle is used.
(2 Marks)

Q6:
a)What is permutation? Explain circular permutation with example. (5 Marks)

b) Find inverse of the following function:

f(x) = (2 Marks)
c) What is a function? Explain the uses of the functions. (3 Marks)

Q7:
a) How many 4 digits number can be formed from 6 digits 1, 2, 3, 4, 5 ,6 if repetitions are not allowed. How many of these numbers are less than 4000? How many are odd?
(5 Marks)

b) What is pigeonhole principle? Explain the applications of pigeonhole principle with example?

(5 Marks)

Q8:
a) How many different 5 persons committees can be formed each containing at least two women and at least one man from a set of 10 women and 15 men. (3 Marks)

b) How many ways are there to distribute or district object into 12 distinct boxes with
i)At least three empty box.
ii)No Empty box. (4 Marks)

c) In a twenty question true false examination a student must achieve eight correct answers to pass. If student answer randomly what is the probability that student will fail. (3 Marks)

Course Code : MCS-014
Course Title : Systems Analysis and Design
Assignment Number : MCA(1)/014/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th April, 2009 (For January Session)
15th October, 2009 (For July 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 for the format of presentation.

Q1:
Define the term “Documentation”. Also, write a short note on the following:
System Requirements Specificaion
System Design Specification
Test Document
User Manual (20 Marks)
Q2:

Draw DFD’s upto 3rd level for a Railway Reservation System. Make assumptions wherever necessary. (20 Marks)

Q3:

Draw complete Entity Relationship Diagram (ERD) for a Railway Reservation System. Make assumptions wherever necessary. (20 Marks)

Note: You can draw the entity-relationship diagram by hand.

Q4:

Explain the following kinds of information systems:
Transaction Processing Systems
Management Information Systems
Decision Support Systems
Expert Systems (20 Marks)

Course Code : MCS-015
Course Title : Communication Skills
Assignment Number : MCA(1)/015/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th April, 2009 (For January Session)
15th October, 2009 (For July Session)

This assignment has eight questions. Answer all questions. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Q1:
Read the following passage carefully and answers the questions that follow:

A generation growing up on the Internet may now get their formal education there – from new schools offering kindergarten through 12th grade online. Backers of education technology say the internet can help children isolated from traditional school houses by distance or disabilities. Online education can also benefit children to be schooled at home by their parents.

“Education is what America cares about the most and technology is what we do best,” said former education secretary William Bennett.

As a past critic of education technology, Bennett once gave schools’ efforts to increase the use of computers in teaching an F-minus. Yet, he is joining companies and schools willing, even eager, to sail into uncharted cyber-space, despite sceptical child development experts and the spiralling business failure rate in the dotcom world.

There’s no exact count of public and private elementary and secondary schools that have followed the lead of web-based colleges. The non-profit, Orlando-based Florida Online High School has offered online courses since 1997 for grades 9-12 nationwide. Public charter schools from California to Pennsylvania teach children online. At the state-funded Valley pathways, online school based in Alaska, roughly 300 students take 1-6 courses a semester on the web.

“We wouldn’t do it if we did not think it could produce quality education,” said Pathways teacher Kathi Baldwin. “I know my students online and in detail. They tell you things in writing they would never tell you face to face.”

Classes are held by computers, teachers and staff work from a central office, and students sign in from their home desktop or laptop computers. Standards for teachers ideally are the same as those of traditional schools.

It’s not all reading, writing and arithmetic. In gym class over the web, pupils keep daily logs of their exercises. They learn music theory online and then go to a designated campus for piano or guitar lessons. They can fax, email or bring in art projects completed at home. Parents even dial in for online PTA meetings. Linda Deafenbaugh said online schooling has filled a void of her son, a third-grader with attention deficit/hyperactivity disorder. Each morning, despite his behavioural disorder, Douglas Meikle, 8, signs onto the Western Pennsylvania Cyber Charter School and downloads his reading, science and math assignments himself.

He completes the lessons, working with online teachers, who include a special education expert, to keep him focused. “He definitely had a bad school experience to the point that teachers were not letting him in the door of the classrooms” said Deafenbaugh, a cultural anthropologist who works for the federal government. “Not only was his social life falling apart, but his academics were too.”

The going has been bumpy for some online schools. Teachers have to keep up students’ interest with interactive lessons, guard against student cheating and do without body language or verbal clues to tell them whether students understand lectures.

And in October, one 15 year-old in an online charter school in California hacked into the system, knocking the school offline for two days and destroying homework assignments, lesson plans and attendance records. “There simply is not enough research”, said William Rukeyser, coordinator of the non-profit Woodland-based Learning in the Real World. “Too often, people say let’s spend money and may be the wisdom will miraculously transfer from the computer to the child.”

Schools spent more than $5bn on education technology last year, and a Congressional panel concluded last week that 70 per cent of America’s classrooms are connected to the web. But the marriage of education and technology is needed, say educators who believe teaching is becoming more difficult in today’s environment. Growing enrolment and shrinking budgets are leaving less room for one-on-one, hands-on-learning at the side of an attentive teacher. “We should not be stuck with one model,” Bennett said.

a Answer the following questions briefly
iHow does online education help children? 2 marks
iiHow does online education system work? 2 marks
iiiWhat are the various subjects or assignments offered online? 2 marks
ivWhat are the shortcomings of the system? 2 marks
vDespite the shortcomings, why is online education catching up in USA?
2 marks
viWhich type of student is this system especially useful for? Why? 2 marks
viiGive the passage a suitable title. 2 marks

b Find one word from the passage which means the same as each of the following: 6 marks
idoubting
iifilling in an empty space
iiia person who studies people, society and culture, especially pertaining to the past.
ivnot smooth and easy
vsomething remarkable, contrary to what’s expected
vidwindling
Q2:
Write short notes on the following:
iWhat are the macro functions of communication? Which of these functions are required in your particular context? Give examples from your life to support your answer. 10 marks

iiHow can the barriers to communication be removed? Discuss giving examples from your life. 10 marks

Q3:
Use appropriate modals (Shall I……, Could you please ……, Would you ….., May I …….., etc.) to make sentences in the following situations. You may use any modal you wish. 10 marks

iYou want your assistant to work late.
iiYou want your colleague to help you complete an assignment.
iiiYour office staff is in the habit of arriving late every morning. You want it to stop.
ivSomeone is carrying two heavy cases. You offer help.
vYou want to leave your class early. Ask your teacher.

Q4:
Complete each sentence with a suitable form of the verb given. Use the present simple or continuous, or the past simple or continuous. The first one is done for you. 10 marks

iI remember the day you got engaged. We were having tea in the garden when you came out of the house and told us. (have)
iiI tried to explain the situation to my parents, but they just ……………………….. what I was talking about. (not / understand)
iiiWhat have you put in this sauce? It ………………. absolutely disgusting. (taste)
ivPeter always claimed that he was innocent, but for many years no one ………………… him (believe)
vIt’s a lovely shawl, I know, but unfortunately it ……………. to me. I’m just borrowing it for the party this evening. (not / belong)
viWhy …………….. that thin dress? You’ll freeze to death in this cold wind! (you / wear)
viiRenu’s fed up because she injured her ankle when she …………. this morning, so she can’t dance. (jog)
viiiWhile I was admiring the view, someone stole the bag which …………… all my traveller’s cheques. (contain)
ixLook! ………………. that man standing beside the cash desk? I am sure he’s planning to steal something. (you / see)
xTea or coffee? I’m making both, so just say which you …………(prefer).
xiThe boys didn’t want to come shopping with us because they ……………… the football on television. (watch)

Q5:
Rewrite the sentences replacing the underlined verbs with the correct form of one of the phrasal verbs in the box. Use your dictionary if necessary. 10 marks

carry on
find out
go in for
look back on
own up
put up with
set off
stand up for
think over
turn down

iI’m sure we’ll all remember this holiday with great pleasure.
iiThe fireworks must be stored safely in order to avoid exploding them accidentally.
iiiI didn’t expect to win the competition. I only entered it for a joke.
ivUnless you confess, we shall all be punished.
v Before you accept this offer, please consider it very carefully.
viWe can’t continue if you won’t cooperate.
viiWhen the critics attacked her work, she defended it vigorously.
viiiHe was offered a new job but he refused it because he didn’t want to move house.
ixWe moved house because we couldn’t bear the noise from the motorway any longer.
xHe had to leave when his boss discovered what he had been doing.

Q6:
You have bought office furniture from Matrix Ltd. three years ago. You’d like to buy some more. Phone them and see if they still make it. Also check the prices as they have probably gone up. 10 marks

Q7:
You took delivery of ten telephone handsets today. You have been checking them out and have found that three of them are faulty. Write a letter/email to the supplier complaining about the above. 10 marks

Q8:
You use 3,000 cellphone boxes a month and you need to order some more from your supplier. You can buy enough boxes for several months at once if he/she gives you a large enough discount. Find out what he/she’s offering and negotiate a deal. 10 marks

Course Code : MCSL-016
Course Title : Internet Concepts and Web Design
Assignment Number : MCA(1)/016/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 30th April, 2009 (For January Session)
31st October, 2009 (For July Session)

This assignment has one question. Question carries 40 marks. Your Lab Record will carry 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 Programme Guide for the format of presentation. Submit the screenshots also along with the coding and documentation.

Q1:

Design a website for newspapers and magazine portal which takes subscription order online through a credit card and makes home delivery. It should include the following:

Home page containing pull down menu box for the links using VBScript.

It should display the current date and time.

The home page should have link of the current news, archieve, FAQ, sitemap, weather, business, sports, world news, etc.

It should have also search faculty

The breaking news should appear scrolling on the top form.

The home page should be divided into a number of frames for displaying and each frame should be filled up with different back ground colour.

The logo of the company should be displayed on the top

The middle frame should be used for displaying video/image

The headline should be at the right side of the page

The lowermost frame should be used for showing links of the most popular articles of the month.

Perform validation checks on credit card number.

Course Code : MCSL-017
Course Title : C and Assembly Language Programming
Assignment Number : MCA(1)/017/Assign/09
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 30th April, 2009 (For January Session)
31st October, 2009 (For July Session)

This assignment has two sections. Answer all questions in each section. Each Section is of 20 marks. Your Lab Records will carry 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 programme guide for the format of presentation.

Section 1: C Programming Lab
Q1:
Write an interactive program in C language to manage a Gas Agency with menu options like Enquiry, New Connection, Booking, Change in Address, Billing, Surrender the Gas Connection etc. using the file handling concepts. The application should be designed user-friendly.
(20 marks)

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

Section 2: Assembly Language Programming Lab

Q1:
(a) Write and run an assembly language program that accepts two input values of single ASCII digit each, converts these values to binary and multiplies the two values. The Result is kept in the AL register. (6 Marks) (5 Marks)

(b) Write and run an assembly program that checks if two strings are identical. Assume that the strings are stored one after the other in the memory. In case the two strings are identical the program output should be IDENTICAL, otherwise the output should be NOT IDENTICAL.
(7 Marks)

(c ) Write and run a assembly subroutine that multiplies two numbers passed to it as parameters. You must write and run the appropriate main program that calls the subroutine. (7 Marks)

For assignment solutions logon to www.spynethub.com

Symptoms of swine flu

2009-08-14T15:33:00.000+05:30

The symptoms of the H1N1 flu virus in people are similar to the symptoms of seasonal flu and include fever, cough, sore throat, runny or stuffy nose, body aches, headache, chills and fatigue. A significant number of people who have been infected with novel H1N1 flu virus also have reported diarrhea and vomiting. The high risk groups for novel H1N1 flu are not known at this time, but it's possible that they may be the same as for seasonal influenza.

Emergency Warning Signs

If you become ill and experience any of the following warning signs, seek emergency medical care.

In children, emergency warning signs that need urgent medical attention include:

1.Fast breathing or trouble breathing

2.Bluish or gray skin color

3.Not drinking enough fluids

4.Severe or persistent vomiting

5.Not waking up or not interacting

6.Being so irritable that the child does not want to be held

7.Flu-like symptoms improve but then return with fever and worse cough

In adults, emergency warning signs that need urgent medical attention include:

1.Difficulty breathing or shortness of breath

2.Pain or pressure in the chest or abdomen

3.Sudden dizziness

4.Confusion

5.Severe or persistent vomiting

6.Flu-like symptoms improve but then return with fever and worse cough

Keep Swine Flu Away with Basic Precautions

2009-08-14T14:24:00.000+05:30

Keep Swine Flu Away with Basic Precautions
The deadly Swine Flu has reached the Indian shores following the global outbreak and now, claimed one life. However, Swine Flu is certainly one of those diseased where an ounce of prevention is worth a pound of cure. Here are ten tips for you to keep away from the pandemic.

1. Wash your hands frequently

Use the antibacterial soaps to cleanse your hands. Wash them often, at least 15 seconds and rinse with running water.

2. Get enough sleep

Try to get 8 hours of good sleep every night to keep your immune system in top flu-fighting shape.

3. Drink sufficient water

Drink 8 to10 glasses of water each day to flush toxins from your system and maintain good moisture and mucous production in your sinuses.

4. Boost your immune system

Keeping your body strong, nourished, and ready to fight infection is important in flu prevention. So stick with whole grains, colorful vegetables, and vitamin-rich fruits.

5. Keep informed

The government is taking necessary steps to prevent the pandemic and periodically release guidelines to keep the pandemic away. Please make sure to keep up to date on the information and act in a calm manner.

6. Avoid alcohol

Apart from being a mood depressant, alcohol is an immune suppressant that can actually decrease your resistance to viral infections like swine flu. So stay away from alcoholic drinks so that your immune system may be strong.

7. Be physically active

Moderate exercise can support the immune system by increasing circulation and oxygenating the body. For example brisk walking for 30-40 minutes 3-4 times a week will significantly perk up your immunity.

8. Keep away from sick people

Flu virus spreads when particles dispersed into the air through a cough or sneeze reach someone elseâ€™s nose. So if you have to be around someone who is sick, try to stay a few feet away from them and especially, avoid physical contact.

9. Know when to get help

Consult your doctor if you have a cough and fever and follow their instructions, including taking medicine as prescribed.

10. Avoid crowded areas

Try to avoid unnecessary trips outside.

for more info please visit
www.swinefluindia.com

2009-08-01T01:22:00.000+05:30

Universities
IGNOU
IIT
IIM
NIT
IIIT
IIIT