MCSL 045 Solved Assignment 2021-22

 

MCSL 045 Solved Assignment 2021-22

UNIX and DBMS Lab

MCSL 045 Solved Assignment 2021-22 : All assignments are in PDF format which would be send on email/WhatsApp (9958676204) just after payment.

Course Code : MCSL 045

Course Title : UNIX and DBMS Lab

Assignment Number : MCA(IV)/L045/Assignment/2021-22

Maximum Marks : 100

Weightage : 25%

The assignment has two parts A and B. Answer all the questions. Each part is for 20 marks. UNIX and DBMS lab record carries 40 Marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the MCA Programme Guide for the format of presentation. If any assumptions made, please state them.

PART-I: MCS 041

Question 1:

Write the UNIX commands for the following:

(a) Use the more command, and a pipe to send the contents of your .profile and .shrc files to the screen.

(b) Use head and tail in a pipeline to display lines 10 through 20 of a file1?

(c) To search the /etc/passwd file for the lines containing any input string given by the user.

(d) To see the lines in /etc/passwd that begins with the character “b”.

(e) List all the files in the /tmp directory owned by the user root.

(f) To see a complete listing of all the processes currently scheduled.

(g) Use the ps command, and the grep command, in a pipeline to find all the processes owned by you.

(h) To force termination of a job whose process ID is given.

(i) Sort the /etc/passwd file, place the results in a file called paswd, and trap any errors in a file called err with the command.

(j) To sort a text file containing the names of 10 students in alphabetical order and place the results in a file called sortedfile.

Question 2:

5

(a) Write a shell program to count the number of words, number of characters, number of vowels, number of special symbols, end of line characters and blank-spaces present in a text file. Redirect the output to a file called as op1.

5

(a) Write a shell program to count the number of words, number of characters, number of vowels, number of special symbols, end of line characters and blank-spaces present in a text file. Redirect the output to a file called as op1.

5

(c) Write a shell script to display the number of files and their details in the current directory, whose filenames are starting with the alphabet given as an argument.

5

PART-II: MCS 043

Question 1:

Design a database for maintaining the details of shows and ticketing for the shows of a Multiplex. Now perform the following activities for the system above:

(a) Create the database for the Multiplex.

2

(b) Write the following queries using SQL:

4

(i) Find the details of the movies whose shows are full.

(ii) Find the details of the movies that had been screened at least one year earlier too.

(iii) Find the names of those movies that have an overall sale of 50% of capacity on all days of screening.

(iv) Create a view of the movie for the manager showing overall performance of the day for each movie.

(c) Create the procedures for the queries (i) to (iii) above

3

(d) Perform the following activities:

(i) Create a trigger that prints the daily catalog on change of a movie.

2

(ii) Create a trigger that increases the price of a specific movie by a certain percentage on a specific weekend.

2

(e) Use the movie poster (picture) as one of the fields in the movie table. Use appropriate data-type for storing it.

1

(f) Create a transaction that finds the total of each movie and prints the overall revenue.

3

(g) Create two different types of users: the first user – a manager who can see reports and change the movie and its timing; and second user who sells tickets.

3

Related Links :

MCS 044 Solved Assignment 2021-22

MPYE 015 Solved Assignment 2021-22

MCS 034 Solved Assignment 2021-22

MPYE 013 Solved Assignment 2021-22

MCSL 045 Solved Assignment 2021-22 : All assignments are in PDF format which would be send on email/WhatsApp (9958676204) just after payment.

POST GRADUATE DIPLOMA IN AUDIO PROGRAMME PRODUCTION Master’s Degree Programmes (MCA) ASSIGNMENTS

Dear Learner,

You have to submit one assignment in each course, i.e. MCSL 045, MCSL 045. All these are Tutor Marked Assignments (TMAs). Before attempting the assignments, please read the instructions provided in the Programme Guide carefully.

Kindly note, you have to submit these assignments to the Coordinator of your Study Centre within the stipulated time for being eligible to appear in the term-end examination. You must mention your Enrolment Number, Name, Address, Assignment Code and Study Centre Code on the first page of the assignment. You must obtain a receipt from the Study Centre for the assignments submitted and retain it. Keep photocopies of the assignments with you.

After evaluation, the assignments have to be returned to you by the Study Centre. Please insist on this and keep a record with you. The marks obtained by you will be sent by the Study Centre to the Student Evaluation Division at IGNOU, New Delhi.

Guidelines for Doing Assignments

There are five questions in each assignment, all carry equal marks. Attempt all the questions in not more than 500 words (each). You will find it useful to keep the following points in mind:

Planning: Read the assignments carefully. Go through the units on which they are based, make some points regarding each question and then rearrange them in a logical order

Organization and Presentation: Be analytical in your selection of the information for your answer. Give adequate attention to the introduction and the conclusion. Make sure that your answer is logical and coherent; has a proper flow of information.

For IGNOU Solved Assignment PDF & Hand Written

Subscribe YOUTUBE : ASSIGNMENT SOLUTION

WhatsApp Contact : 9958676204