IGNOU MCS-43 - Advanced Database Management Systems

Bought By: 3624

Rating: 3.7

Advanced Database Management Systems

#1 Best Selling IGNOU MCS-43 Help-Book & Study-Guide in IGNOU Marketplaces.

Get Good Marks in your MCA Computer Application Programme in the Term-End Exams even if you are busy in your job or profession.

We've sold over 15,681,052 Help Books and Delivered 17,015,187 Assignments Since 2002.
As our customers will tell you...yes, it really result-oriented.

IGNOU MCS-43 Code Details

  • University IGNOU (Indira Gandhi National Open University)
  • Title Advanced Database Management Systems
  • Language(s) English
  • Code MCS-43
  • Subject Computer Application
  • Degree(s) MCA
  • Course Core Courses (CC)

IGNOU MCS-43 English Topics Covered

Block 1 - Database Design and Implementation

  • Unit 1 - Relational Database Design
  • Unit 2 - Database Implementation and Tools
  • Unit 3 - Advanced SQL
  • Unit 4 - Database System Catalogue

Block 2 - DBMS Advanced Features and Distributed Database

  • Unit 1 - Query Processing and Evaluation
  • Unit 2 - Transaction Management and Recovery
  • Unit 3 - Database Security and Authorisation
  • Unit 4 - Distributed Databases

Block 3 - Enhanced Database Models

  • Unit 1 - Object Oriented Database
  • Unit 2 - Database and XML
  • Unit 3 - Introduction to Data Warehousing
  • Unit 4 - Introduction to Data Mining

Block 4 - Emerging Trends and Example DBMS Architectures

  • Unit 1 - Emerging Database Models, Technologies and Applications-I
  • Unit 2 - Emerging Database Models, Technologies and Applications-II
  • Unit 3 - PostgreSQL
  • Unit 4 - Oracle
Buy MCS-43 Help Book

IGNOU MCS-43 (July 2019 - January 2020) Assignment Questions

  1. 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. Draw the appropriate tables and relationship among the tables for the above diagram and normalize the tables up to 3NF. Include generalization and aggregation features in the diagram and draw their tabular representations and explain. 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? Identify multivalued dependency in the above diagram if any. Justify. 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.
  2. What is the fundamental difference between XML document and relational database? How is XML data stored in RDBMS? Explain.
  3. Write an algorithm that checks whether to the concurrent transactions are in deadlock or not?
  4. 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)
  5. Discuss the algorithm and the related cost of performing Selection operation.
  6. What is a timestamp? What is the use of timestamp protocols in distributed database? How does timestamp generation take place in distributed database?
  7. How are implementations of triggers in Oracle different from the standard implementations?
  8. Explain multiple granularities with the help of an example. How is locking done in such a case?
  9. What are the characteristics of multimedia & mobile databases? Explain the design challenges of these database?
  10. What is assertion rule mining? Write apriority algorithm for finding frequency item set. Discuss it with suitable examples.
  11. Draw a simple Use case and a class diagram for a university’s examination system.
Buy MCS-43 Assignment

Related Codes