Skip to main content

MCSL-045 SOLVED ASSIGNMENT 2017-18 FOR IGNOU MCA 4th SEMESTER

IGNOU MCSL-045 SOLVED ASSIGNMENT 2017-18 FOR MCA 4TH SEMESTER

IGNOU MCA 4th Semester Solved Assignment

MCSl-045 SOLVED ASSIGNMENT

QUESTIONS SOLVED IN ASSIGNMENT

PART-I MCS-041
  1. Write and execute the following UNIX commands:
    1. To change the password.
    2. To search files in the current directory/subdirectory for lines that match a particular string pattern given as input.
    3. To print the first 5 lines of a file.
    4. To print the number of processes run by a particular user.
    5. To kill a process that is running at the background.
    6. To display the count of no. of blank spaces in a given file.
    7. To sort alphabetically, a list of numbers stored ina data file in an ascending order.
    8. To convert the upper case letters to corresponding lower case letters in a text file.
    9. To count the number of users currently logged on.
    10. To display the calendar for a given month and year.
  2. Write shell programs for the following:
    1. To find second largest number among the 5 numbers given.
    2. To find sum of all the alternate digits in a given 7 digit number.
    3. To count number of vowels in a given string.
    4. To take 2 strings as input, concatenate them and display the length of the resultant string.
    5. To display the reverse of a given number.
PART-II MCS-043
    1. Design a database for a Property Dealer who deals in Flat Rentals, including:
      • Apartment data: city, street, house number, apartment number, size (square feet), purchase date and price, rent per month
      • Renter data: name, contact information, which apartments she/he has rent (one renter may have several) and for which time periods, agreed start date, agreed end date (if fixed), check out date
    2. Perform following queries using SQL:
      1. To find the total rent earned during certain time interval (input to be given by the user) for a particular aptID.
      2. To display all the aptIDs if the street ID and City are given.
      3. To display the list of all the renters who have more than one apt.
      4. To display the list of all aptIDs whose rent is equal to or more than Rs.15,000/- per month in a particular street with apt size more than 850sq feet.
      5. To display all the details of the apartment which were bought before year 2000 in a particular city and street.
    3. Write appropriate triggers, exceptions and functions for the above said system database schema and describe them briefly.
IGNOU MCA 4TH SEMESTER SOLVED ASSIGNMENT

Comments

Most Viewed This Month

MCS-013 SOLVED ASSIGNMENT FOR IGNOU BCA AND MCA 2017-18 SESSION

IGNOU BCA MCA SOLVED ASSIGNMENT 2017-18
MCS-013 Discrete Mathematics

QUESTIONS SOLVED IN ASSIGNMENT:
Question 1 (a) Explain different logical connectives with the help of examples.
(b) Make truth table for followings:
i) p→(q ~ r) (~p ~r)   
ii) p→(r ~ q)   (~p ~q) 
(d) Explain logical equivalence with the help of example.

Question 2
(a) Write down suitable mathematical statement that can be represented by the following symbolic properties.
i) ( x) ( y) ( z) P   
ii) ( x) ( y) ( z) P   
(c) What is indirect method of proof? Example with example.
(d) What is relation? Explain equivalence relation with the help of an example.

Question 3
(b) Find dual of Boolean Expression for Q, in the figure given below.
Figure 1: Logic Circuit
(c) Explain De Morgan’s laws in relation to Boolean Algebra.
(d) What is principle of mathematical induction? Explain with the help of an example.

Question 4
(a) How many different committees can be formed of 12 professionals, each cont…

MCS-012 SOLVED ASSIGNMENT 2017-18 FOR IGNOU BCA AND MCA

IGNOU BCA and MCA Solved AssignmentMCS-012 Solved Assignment 2017-18Computer Organization and Assembly Language ProgrammingQUESTIONS SOLVED IN ASSIGNMENT:(Covers Block 1)What are the differences between signed 1’s complement notation and signed 2’s complement notation for representation of negative fixed point numbers? Find the range of numbers that can be represented in both these notation, if the size of the notations is 8 bits (including sign bit). Explain the difference in the range of the two notations. Perform the following arithmetic operations using signed 2’s complement 8-bit representation. (Please note that the numbers given below are in decimal notation) Subtract 30 from –98Add 69 and 59 Please indicate the overflow if it occurs. How have you identified the overflow? Perform the following conversion of numbers: Decimal (9999)10 to binary and hexadecimalHexadecimal (FEDC9410)H into Octal.ASCII string “MCS-012Course” into UTF 8Octal (234567)O into Decimal …

BCS-040 SOLVED ASSIGNMENT FOR IGNOU BCA 4th SEMESTER 2017-18 SESSION

IGNOU BCA SOLVED ASSIGNMENT 2017-18
BCS-040 Statistics Techniques

QUESTIONS SOLVED IN ASSIGNMENT:
1. In a study on the Per capita Income for a particular year in a city, the following weekly
observations were made.
Per Capita Income (Rs.) -(1K=1000)
14K-15K 15K-16K 16K-17K 17K-18K 18K-19K 19K-20K
Number of Weeks 5 10 20 9 6 2
Draw a histogram and a frequency polygon on the same scale
2. Do you find any correlation between ages and playing habits of the students, whose distribution
according to age groups is given in the following table
Age of groups(Years) 15-16 16-17 17-18 18-19 19-20 20-21
Number of Students 200 270 340 360 400 300
Number of Regular players 150 152 170 180 180 120
3. Data are given below shows statistics viz. standard deviation & average marks secured by
students, in the examination of subject A and B
SUBJECT A SUBJECT B
MEAN MARKS 36 85
STANDARD DEVIATION 11 8
Assuming the Coefficient of correlation between A and B = ±0.66
Perform the following tasks:
i) Determi…

IGNOU BCA 4th SEMESTER SOLVED ASSIGNMENTS FOR ALL SUBJECTS 2017-18 SESSION

IGNOU BCA 4th SEMESTER SOLVED ASSIGNMENTS FOR ALL SUBJECTS 2017-18 SESSION

Download IGNOU BCA Solved Assignments For 4th SemesterCOURSE CODECOURSE NAMEDIRECT LINKBCS-040Statistical TechniquesDOWNLOADBCS-041Fundamentals of Computer NetworksDOWNLOADBCS-042Introduction to Algorithm DesignDOWNLOADMCS-024Object Oriented Technologies and Java ProgrammingDOWNLOADBCSL-043Java Programming LabDOWNLOADBCSL-044Statistical Techniques LabDOWNLOADBCSL-045 Algorithm Design Lab DOWNLOADMCSL-016Internet Concepts and Web Design LabDOWNLOAD