Dear students, get fully solved assignments by professionals
Do send your query at :
or call us at :08263069601
MASTER OF COMPUTER
APPLICATIONS
(MCA)
MCA/ASSIGN/SEMESTER-IV
ASSIGNMENTS
(July – 2019 & January – 2020)
MCS-041, MCS-042, MCS-043, MCSP-044, MCSL-045
SCHOOL OF COMPUTER AND INFORMATION SCIENCES INDIRA GANDHI NATIONAL OPEN UNIVERSITY MAIDAN GARHI, NEW DELHI – 110 068
Dear students, get fully solved assignments by professionals
Do send your query at :
or call us at :08263069601
CONTENTS
| Course | Assignment No. | Submission-Schedule | Page | |||||
| Code | No. | |||||||
| For July- | For January-June | |||||||
| December Session | Session | |||||||
| MCS-041 | MCA(4)/041/Assignment/19-20 | 15th | October, 2019 | 15th | April, 2020 | 3 | ||
| MCS-042 | MCA(4)/042/Assignment/19-20 | 15th | October, 2019 | 15th | April, 2020 | 5 | ||
| MCS-043 | MCA(4)/043/Assignment/19-20 | 15th | October, 2019 | 15th April, 2020 | 7 | |||
| MCS-044 | MCA(4)/044/Assignment/19-20 | 15th | October, 2019 | 15th | April, 2020 | 9 | ||
| MCSL-045 | MCA(4)/L-045/Assignment/19-20 | 15th | October, 2019 | 15th | April, 2020 | 11 | ||
Important Notes
- Submit your assignments to the Coordinator of your Study Centre on or before the due date.
- Assignment submission before due dates is compulsory to become eligible for appearing in corresponding Term End Examinations. For further details, please refer to MCA Programme Guide.
- To become eligible for appearing the Term End Practical Examination for the lab courses, it is essential to fulfill the minimum attendance requirements as well as submission of assignments (on or before the due date). For further details, please refer to the MCA Programme Guide.
- The viva voce is compulsory for the assignments. For any course, if a student submitted the assignment and not attended the viva-voce, then the assignment is treated as not successfully completed and would be marked as ZERO.8
2
| Course Code | : | MCS-041 |
| Course Title | : | Operating Systems |
| Assignment Number | : | MCA(IV)/041/Assignment/2019-20 |
| Maximum Marks | : | 100 |
| Weightage | : | 25% |
| Last Date of Submission | : | 15th October, 2019 (for July, 2019 session) |
| 15th April, 2020(for January, 2019 session) |
This assignment has six 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.
Q1. Assume you have the following jobs to execute with one processor:
| Process | Processing Time | Arrival Time |
| P1 | 15 | 00 |
| P2 | 10 | 05 |
| P3 | 07 | 10 |
| P4 | 16 | 12 |
| P5 | 04 | 13 |
| Calculate the turnaround time, waiting time, average turnaround time, average waiting | |||
| time, throughput and processor utilization for the above given set of processes that arrive | |||
| at a given arrive time shown in the table, with the length of processing time given in | |||
| milliseconds using FCFS, SJF, RR (with quantum 2) and SRTN scheduling algorithms. | |||
| Also draw their corresponding Gantt charts. | (20 Marks) | ||
| Q2. | Using C programming, write a semaphore based solution to Dining Philosopher’s | ||
| problem and explain the program. | (10 Marks) | ||
| Q3. | (a) Discuss how fragmentations manifest itself in each of the following types of virtual | ||
| storage system. | (9 Marks) | ||
| i) | Segmentation | ||
| ii) | Paging | ||
| iii) Combined segmentation and paging | |||
| (b) Compare direct file with indexed sequential file organization. | (6 marks) | ||
| Q4. | (a) Explain take-grant model for operating system security with an example. Also explain | ||
| the mechanisms of security in WIN 2000 operating system? | (5 Marks) | ||
| (b) Explain Bell and La-Padula Model for security and protection. Why is security a | |||
| critical issue in a distributed OS environment? | (5 Marks) | ||
| Q5. | Write and explain an algorithm used for ordering of events in a distributed environment. | ||
| Implement the algorithm with an example and explain? | (10 Marks) | ||
| 3 |
Q6. Discuss in detail the Process management, Memory management, I/O management, File management and Security and Protection for the following Operating Systems:
(15 Marks)
(a) WINDOWS 10 (b) ANDROID Version 9.0 (PIE)
Dear students, get fully solved assignments by professionals
Do send your query at :
or call us at :08263069601
4
| Course Code | : | MCS-042 |
| Course Title | : | Data Communication and Computer Network |
| Assignment Number | : | MCA(IV)/042/Assignment/2019-20 |
| Maximum Marks | : | 100 |
| Weightage | : | 25% |
| Last Date of Submission | : | 15th October, 2019 (for July, 2019 session) |
| : | 15th April, 2020(for January, 2020 session) |
Answer all the questions in the assignment which carry 80 marks in total. 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. | (a) What is the need of modulating a signal? Will it be a right approach to send the | |
| information as the signal itself? | (4 Marks) | |
| (b) Explain techniques used in digital to analog modulation with the help of diagram | ||
| (5 Marks) | ||
| Q2. | (a) Discuss the different approaches to circuit switching? Why it is suitable for voice | |
| Transmission? What are its limitations? | (5 Marks) | |
| (b) How does multistage switching overcome these limitations? | (3 Marks) | |
| Q3. | A bit string 011100111110001110 needs to be transmitted at the data link layer. What | |
| is the string actually transmitted after bit stuffing? | (2 Marks) | |
| Q4. | (a) Define checksum and write the algorithm for computing the checksum? | (5 Marks) |
| Q5. | Define flow error control and piggybacking concepts. Show the operation of Stop & | |
| Wait ARQ with the help of an illustration. Also illustrate the outcome of Stop & Wait | ||
| ARQ in the following scenarios. | (6 Marks) | |
| (i) When ACK is lost | ||
| (ii) When Frame is lost | ||
| (iii) When ACK timeout occurs | ||
| Q6. | (a) How does MACAW work? Show diagrammatically. What are the added features | |
| in MACAW compared to MACA ? | (5 Marks) | |
| (b) What are the advantages of frame fragmentation in wireless network? Explain. | ||
| (4 Marks) | ||
| Q7. | How does a bridge operate in different LAN environments? What are the | |
| problems encountered in building a bridge between the various 802 LANs ? Discuss. | ||
| (5 Marks) | ||
| Q8. | Write Dijkstra and Bellman Fords shortest path routing algorithms and make a | |
| comparison between the two algorithms. | (6 Marks) | |
| 5 |
Q9.
(a) Discuss general principle of congestion control and the mechanisms used in congestion control in packet switched network .
(6 Marks)
- Explain the implementation of token bucket traffic shaper with the help of a diagram? (5 Marks)
| Q10. | Explain with the help of an example and a diagram how the congestion controls | ||
| algorithm (slow start algorithm) work at transport layer. | (5 Marks) | ||
| Q11. | (a) | Define digital signature and explain its benefits. | (4 Marks) |
| (b) | What kind of a model is being used in India to provide public key infrastructure | ||
| related services. (I.e. management of public keys). Elaborate. | (5 Marks) | ||
| Q12. | Discuss the implementation of Kerberos mechanism. | (5 Marks) |
6
| Course Code | : | MCS-043 |
| Course Title | : | Advanced Database Management Systems |
| Assignment Number | : | MCA(IV)/043/Assignment/2019-20 |
| Maximum Marks | : | 100 |
| Weightage | : | 25% |
| Last Dates for Submission | : | 15th October, 2019 (For July, 2019 session) |
| 15th April, 2020 (For January, 2020 session) |
Answer all the questions in the assignment which carry 80 marks in total. 20 marks are for viva voce. You may use illustrations. Place go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
Q1. Design a database for a university’s examination division which conducts examination, issue hall tickets to the students for appearing for TEE. It also issue grade cards to the successful candidates. It maintains data about (a) Programs (b) Study center (SC)
(c) Regional center (RC) (d) Students (e) courses within a program
The hall ticket should have student name, SC-code, RC code, Student id, Program code & course code and date of examination.
The grade card should have the following attributes Student id, Student name, program code, Course code and grade in each course.
- Draw the EER (extended ER) diagram for the above problem showing all entities, attributes and relationship. Also identify multivalued and derived attributes. (5 Marks)
- Draw the appropriate tables and relationship among the tables for the above diagram and
normalize the tables up to 3NF.
(5 Marks)
(c) Include generalization and aggregation features in the diagram and draw their tabular
representations and explain.
(6 Marks)
(d) Identify weak entity sets in the above diagram if any. Show how will you convert a weak
entity set to a strong entity set? What is the need of such task?
(3 Marks)
(e) Identify multivalued dependency in the above diagram if any. Justify.
(3 Marks)
- Create an XML schema for the grade card to be issued by the division having details: student id, programme code, course id, grade, consumer name, assignments marks, TEE
| marks and grade. | (3 Marks) | |
| Q2. | What is the fundamental difference between XML document and relational database? | |
| How is XML data stored in RDBMS? Explain. | (5 Marks) | |
| Q3. | Write an algorithm that checks whether to the concurrent transactions are in deadlock or | |
| not? | (6 Marks) | |
| Q4. | What are views? What is their significance in DBMS? How are views created in SQL? | |
| Explain the concept with the help of an example pertaining to the design of University’s | ||
| examination system (refer to Q1) | (6 Marks) | |
| Q5. | Discuss the algorithm and the related cost of performing Selection operation. | (6 Marks) |
| 7 |
| Q6. | What is a timestamp? What is the use of timestamp protocols in distributed database? | |
| How does timestamp generation take place in distributed database? | (6 Marks) | |
| Q7. | How are implementations of triggers in Oracle different from the standard | |
| implementations? | (5 Marks) | |
| Q8. | Explain multiple granularities with the help of an example. How is locking done in such a | |
| case? | (6 Marks) | |
| Q9. | What are the characteristics of multimedia & mobile databases? Explain the design | |
| challenges of these database? | (5 Marks) | |
| Q10. | What is assertion rule mining? Write apriority algorithm for finding frequency item set. | |
| Discuss it with suitable examples. | (5 Marks) | |
| Q11. | Draw a simple Use case and a class diagram for a university’s examination system. | |
| (5 Marks) |
8
| Course Code | : | MCS-044 |
| Course Title | : | Mini Project |
| Assignment Number | : | MCA (IV)/P044/Assignment/2019-20 |
| Assignment Marks | : | 100 |
| Maximum Marks | : | 25% |
| Last Date of Submission | : | 15th October, 2019 (for July, 2019 session) |
| 15th April, 2020 (for January, 2020 session) |
There are five questions in this assignment carrying 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 Program Guide for the format of presentation. Assumptions made if any, should be stated.
Background and Project Specifications:
A bank proposes to develop an information portal for its customers. The portal provides secure login to customer account and online information services. The services include finding the list of all the accounts hold by a logged in customer, balance in his/her accounts, recent transactions, m-passbook and service requests like stopping the payment of a cheque, issue of a new cheque book, and complaint registration. A customer can have more than one accounts with the Bank, however, for online information purposes they all can be linked to a single user name and password. The proposed application can have only read only access to the accounts of the customer. Also the website should be a secure website as this application requires confidential information.
You may study the requirements of this system in more details by experiencing the online services of your own bank. Perform the following tasks for the system proposed above:
Q1. (5+5 = 10 Marks)
- Which Systems Development Life Cycle (SDLC) will you propose for the specification given above?
- Justify you selection by evaluating suitability of at least two SDLCs.
Q2. (2+2+2+4=10 Marks)
- What would be the major costs of the system?
- What may be the financial benefits of installing such a system?
- Perform a cost-benefit analysis for the proposed software and report its findings.
- List the major tasks and milestones of the Project and make a project schedule. You schedule must include both GANTT and PERT charts. Explain the two charts drawn by you.
Q3. (10+15=25 Marks)
- Study the system and create a software requirement specification. You must identify either the processes or objects while analyzing. During the analysis give consideration to possible input and output of the processes.
- After identifying the requirements, create Analysis Models. You may either use the classical approach and draw Entity relationship diagram and data flow diagrams (DFD’s) up to level 2-3; or you may use object oriented analysis approach and create class diagram, use case diagram, use cases etc.
Q4. (15+10=25 Marks)
- Design the system architecture and the database as per the needs of the system. You must perform normalization on tables up to 3rd normal form. The table design must include Primary and Foreign keys and constraints.
9
- (b) Create the system flow chart or detailed process design and state transition diagrams. Also design the user input screens and output report formats.
Q5. Design various unit test cases for the application given above using different testing strategies.
(10 Marks)
10
| Course Code | : | MCSL-045 |
| Course Title | : | UNIX and DBMS Lab |
| Assignment Number | : | MCA(IV)/L045/Assignment/2019-20 |
| Maximum Marks | : | 100 |
| Weightage | : | 25% |
| Last Date of Submission | : | 15th October, 2019 (for July, 2019 session) |
| 15th April, 2020 (for January, 2020 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-I: MCS-041
Q1.
Write the UNIX commands for the following: (5 Marks)
- To search for text using specific regular expressions in file.
- To sort the contents of a file in reverse alphabetical order.
- To count the no. of characters and words in a given text file.
- Create a small text file from your console.
- Change the file permissions to Read, Write and Execute for everyone on a data file created by you.
- To create a physical link between two files f1 and f2.
- Compare two text files and display the first difference.
- To display the disk usage.
- Create a file containing 20 lines, split it into two files containing 10 lines each.
- To change the owner of a file.
Q2.
- Write a shell program to count and print the no. of positive and negative integers in a list
of integers given as input by the user. (5 Marks)
- Given two filenames by the user as the input, write a shell script to append the contents of
file2 to file1. (5 Marks)
- Write a shell script to display the no. of times the given pattern occurs in a .dat file and
display the count. (5 Marks)
11
PART-II: MCS-043
Q1.
Design a database for a Mobile Phones’ Sales and Service Showroom which deals with sales and service of various brands of mobile phones. It also sells various accessories pertaining to mobile phones. You are required to perform the following activities for the maintenance of the above:
| (a) | Draw an enhanced entity relationship (EER) diagram. | (3 Marks) |
| (b) | Create the complete database. | (2 Marks) |
| (c) | Write the following queries using SQL: | (4 Marks) |
- To display the Brand, Model and Price of the all the mobile phones sold on a particular date.
- To find the details of the mobile phones which were purchased in the same shop and were serviced on a particular date.
- To display all the Brands and Models of the mobile phones whose price is more than Rs.15000/-.
- Create a view of the items for the manager showing overall performance of the week for each Brand and Model of the mobile phones.
- Perform the following activities:
- Create a trigger that prints the daily catalogue on change of a price of any mobile
phone or accessory. (2 Marks)
- Create a trigger whenever there is a new entry (of a new model) in the mobile phone table. Also design a trigger whenever there is a deletion of the record.
(3 Marks)
- Create a transaction that finds the total items sold per week and prints the overall revenue
generated. (3 Marks)
- Create two different types of users: the first user – a manager who can see reports and change the items and its price value and second user (a salesperson) who sells these
items. (3 Marks)
Dear students, get fully solved assignments by professionals
Do send your query at :
or call us at :08263069601
12