Master’s Degree Programme (MCA) – Advanced Database Management Systems Solved Assignment Answer | MCS 043 | 2021-2022

Free MCS 043 Solved Assignment Answer | Advanced Database Management Systems | For July 2021 – October 2022

IGNOU MCS 043 Solved Assignment, This assignment is the curriculum of the Master of Computer Applications (MCA) program. For other courses, students check our website categories section to find their courses and assignments over there.

MCS 043 Advanced Database Management Systems Solved Assignment 2021-2022

IGNOU MCS 043 Advanced Database Management Systems assignment are 100 marks. There is only two sections – A & B. Students have to answer all the questions. Download IGNOU MCS 227 Assignment free without any registration, Students can easily download the IGNOU assignment question paper from the official website of the university. They are not required to pay any fees or charges for this.

How to get Advanced Database Management Systems, MCS 043 Solved Assignment?

It is always good to solve the assignment by yourself. Because it helps the students in the whole study. It also helps them in preparing for the exam. So that the question that comes in the exam can be solved easily.

If someone is unable to solve the assignment, so don’t worry we have solved this assignment for you, you only need to click the link one by one and get all the answers to this assignment sequence-wise. And if not, then our team is working on it and you will be available soon.

The answer of MCS 043 | Advanced Database Management Systems | Solved Assignment 2021-2022:

Important Notes:

1. Submit your assignments to the Coordinator of your Study Centre on or before the due date.
2. Assignment submission before due dates is compulsory to become eligible for appearing in corresponding Term End Examinations. For further details, please refer to Programme Guide of Master of Computer Applications (MCA _NEW).
3. 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 Programme Guide of Master of Computer Applications (MCA _NEW).
4. 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.

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.

Question 1: Design a generalization /specialization hierarchy for a motor vehicle sales company. The company sells motorcycles, autos, cars, and buses. Justify your placement of attributes at each level of the hierarchy. Convert the diagram into tables with integrity constraints for each table.

Question 2: Consider the following relations.
Student (Std id, name, year of study, basic stipend, dept_no)
dept ( dept_name, academic_block)
Write SQL queries for the followings:
(a) Select names, year of study, and dept_name of all students whose names start with A and their basic stipend is not less than 15000.00
(b) Increase the basic stipend of the 3rd-year computer science department by 5000.00 per month.

Question 3: How does embedded SQL differ from Dynamic SQL. Describe the implementation of cursors and triggers with the help of examples. How are triggers different from the stored procedures?

Question 4: Define the third NF.Justify whether the following student relationship is in the third NF or not?

Student (Rollno, S_name, Department, Year, Hostel_name)
Year → Hostel_name
IF it is not in the third NF, convert it into the third NF

Question 5: Define the terms: Serializable and Conflict Serializable. Determine whether the following schedule A is serializable and conflict serializable or not?

Schedule A:

Question 6: What is concurrent transaction? What is the condition for occurrence of conflicting operations in transactions? Give an example illustrating conflicting operations of concurrent transaction.

Question 7: How does Time Stamp based protocols manage concurrent transactions? Write the complete procedure of execution of the protocol.

Question 8: Define deadlock. How it can be presented? Write an algorithm that checks whether the concurrently executing transactions are in deadlock.

Question 9: Write an algorithm for Hash-join. Show cost calculation for sample Hash-join with the help of an example.

Question 10: Answer the following questions with represent to advanced databases.
(i) Horizontal and vertical fragmentation in distributed database.
(ii) Challenges in designing multimedia database
(iii) Important features of semantic database.

Question 11: How does Oracle manage database security?

Question 12: What is classification in context of data mining?

Wrapped Up

• For More BSCG Assignments – BSCG Solved Assignment
• For More Master Assignments – Master’s Solved Assignment 2022
• For Hand Written Assignments – Click here

For more Updates join our Telegram Group and also for your inquiry you may comment here or mail us –info@ignouassignmentssolutions.in
Telegram Group – Click Here