Showing posts with label MCA. Show all posts
Showing posts with label MCA. Show all posts

Tuesday, May 8, 2012

MCSL-045

MCA (Revised)
Term-End Practical Examination
June, 2011
MCSL-045 : UNIX AND DBMS LAB

Time allowed : 2 hours                                                  Maximum Marks : 50
Note : There are two parts : UNIX and DBMS in this paper. Each part is of 1 hour
duration and carry 20 marks. 5 marks is for Viva - voce of each part
separately. Attempt only that part(s), which is/are not yet clear.

PART-I
UNIX
1. Write and execute UNIX commands for the following:                                                     5
(a)  To display the last 10 lines in a text file.
(b)  To remove a directory.
(c)  To connect to a remote machine.
(d)  To change the permission of a file.
(e)  To quit from a file with no changes.

2. Write a shell script to write the initial of any name given as input.                                       5
   Input VINAY KUMAR
   Output V K

3. Write a shell script program to find out biggest number from the three given
 numbers as input as through command line argument. Display appropriate message if exactly three arguments are not provided through command line.                                                      10

PART-II
DBMS
Note: Answer the following questions:
           
1. Create a relational database with the following relations and insert 10 meaningful
records/data in each table of the relation:                                                                             5
-  TEACHER (T_ID, Name, Designation, Subject)
-  STUDENT (T_ID, Roll_No, Subject, S_Name, Semester)
-  RESULT (Roll_No, S_Name, Subject, E_Marks)
           
2. Perform the following tasks using schema/Table/Relations given in Q.1
(a) Using the schema /Tables of Q.1, write a trigger that fires before any row is
inserted in the table RESULT.                                                                                             5
(b) Using the schema/ tables of Q.1, write a procedure to display the marks of those
students who have studied "Computer Graphics" subject by a Teacher whose
designation is "Professor".                                                                                             10

Saturday, April 21, 2012

IGNOU MCA Programme


IGNOU MCA Programme:
  • Indira Gandhi National Open University conducts IGNOU MCA Programme OPENMAT examination twice a year for admission into the MCA programs offered by the University through its study centers and regional centers all over India.
  • Course Duration 3 Years (Minimum) 6 Years (Maximum) 
  • Eligibility Criteria / Entry Requirements 1. Bachelor of Computer Science / Applications / Information Science / Information Technology from a recognised / deemed university Non-computer Science B.Tech/M.Sc./other graduates (such applicants are required to pursue CIC concurrently with MCA 1st semester) OR 2. Non-Computer Science B.Tech/M.Sc/other graduates (such applicants are required to pursue CIC concurrently with MCA 1st semester) Or 3. Graduate with PGDCA from a recognised / deemed university or its equivalent course of not less than one year from a State Board of Technical Education or its equivalent body established by the Central/State Government Note: (i) The students who haven't studied Maths at 10+2 level are required to do CS-60 in the first semester of MCA. (ii) The students enrolling for the MCA Programme who have completed the DEOACC O-level programme are not required to enroll for CIC. 
Courses Semester Wise

First Semester




CourseCode     Course Name Credits 
 MCS-011  Problem Solving and Programming  3
 MCS-012  Computer Organisation and Assembly Language Programming  4
 MCS-013  Discrete Mathematics  2
 MCS-014  Systems Analysis and Design  3
 MCS-015  Communication Skills  2
 MCSL-016  Internet Concepts and Web design (Lab Course)  2
 MCSL-017  Lab (C and Assembly Language Programming) (Lab Course)  2
Second Semester




CourseCode     Course Name Credits 
 MCS-021  Data and File structures  4
 MCS-022  Operating System concepts  4
 MCS-023  Introduction to Database Management Systems  3
 MCS-024  Object Oriented Technology and Java Programming  3
 MCSL-025  Lab (Data Structures using C, WINDOWS 2000, LINUX / UNIX, Java and MS? ACCESS, My SQL)  4
Third Semester




CourseCode     Course Name Credits 
 MCS-031  Design and Analysis of Algorithms  4
 MCS-032  Object Oriented Analysis and Design  3
 MCS-033  Advanced Discrete Mathematics  2
 MCS-034  Software Engineering  3
 MCS-035  Accountancy and Financial Management  3
 MCSL-036  Laboratory Course (For Object Oriented Analysis and Design, Software Engineering and Accountancy and Financial Management)  3
Fourth Semester




CourseCode     Course Name Credits 
 MCS-041  Operating Systems  4
 MCS-042  Data Communication and Networks  4
 MCS-043  Advanced Database Management Systems  4
 MCS-044  Mini Project  4
 MCSL-045  UNIX and DBMS LAB  2
Fifth Semester




CourseCode     Course Name Credits 
 MCS-051  Advanced Internet Technologies  3
 MCS-052  Principles of Management and Information Systems  2
 MCS-053  Computer Graphics and Multimedia  4
 MCSL-054  Laboratory Course (Advanced Internet Technologies & Computer Graphics and Multimedia)  2
 MCSE-003  Artificial Intelligence and Knowledge Management  3
 MCSE-004  Numerical and Statistical Computing  3
 MCSE-011  Parallel Computing  3
Sixth Semester




CourseCode     Course Name Credits 
 MCSP-060  Project   16
  • IGNOU MCA for Non-Computer Science Graduates Various students from non-Computer Science-core streams (generally streams that does not have Computer Science as a paper through out the course but have Computer Science as a paper during a Semester / Year. Courses such as Arts (B.Com/B.A) with Computer Science come under this category) often ask about how to get admission for IGNOU MCA Program. IGNOU, through its Schematic Presentation of SOCIS Programmes that can be downloaded from IGNOU Website (generally given in the last few pages of the IGNOU Prospectus / MCA Program booklet) clarifies as follows: Students with Maths at 10+2 Level and having done Bachelor in Computer Science/Applications/Information Sciences/Information Technology/PGDCA from a recognized/deemed University can take MCA Ist Semester directly.Students with out Maths at 10+2 Level and having done Bachelor in Computer Science/Applications/Information Sciences/Information Technology/PGDCA from a recognized/deemed University should take CS60 along with MCA Ist Semester. Students with Maths at 10+2 Level and having done other Graduation courses/B.Tech/M.Sc. in Non-Computers stream (including but not limited to Bcom with Computer Science) should take CIC along with MCA Ist Semester (Students are required to do CIC concurrently with MCA first semester and should successfully complete it before registering for the 5th semester of MCA) Students with out Maths at 10+2 Level and having done other Graduation courses/B.Tech/M.Sc. in Non-Computers stream (including but not limited to Bcom with Computer Science) should take CIC, CS60 along with MCA Ist Semester (Students are required to do CIC concurrently with MCA first semester and should successfully complete it before registering for the 5th semester of MCA).
  • Important Note: Please contact your nearest IGNOU Regional Center / Study Center for a complete clarification regarding the admission process before you take admission.
  • AICTE Recognition The All India Council for Technical Education (AICTE) wide its letter F No. AICTE/Academic/MOU-DEC/2005 dt. May 13, 2005 has specified that the Master of Computer Applications (MCA) of IGNOU is recognized by AICTE.
  • Min age as on 1st Jan. of the Academic Year No bar