IGNOU MCS 207 SOLVED ASSIGNMENT 2024 2025

Ques 1.

Explain the three level DBMS architecture with the help of an example. Also, explain the concept of data independence in the context of database systems with the help of an example. 

Ques 2.

Explain the following terms in the context of a relational model with the help of one example of each– Super key, Domain, Cartesian Product, Primary Key, Natural join, Set Intersection, Set Difference operation and referential integrity constraint. 

Ques 3.

A University maintains the list of the books available in its library using a database system. In
addition, this system is used for issue and return of books to its students. This database is used to find
the following details by the students of the university and the staff of the library:
 List of the classification number, ISBN number, Title, Author Names, Subject Area of the
books.
 Searching of books using subject area, Title and Author name.
 List of books that are issued to a specific student.
Draw an ER diagram for the library. Specify key attributes and constraints on each entity type and
on each relationship type. Note any unspecified requirements and make appropriate assumptions to
make the specification complete.

Ques 4.

Design normalised tables in 3NF for the ER diagram drawn in part (c), with the required integrity constraints

Ques 5.

Design normalised tables in 3NF for the ER diagram drawn in part (c), with the required integrity constraints

Ques 6.

Consider a Relation: Student (EnrolNo, StudentName, ProgrammeCode, ProgrammeName,
CourseCode, CourseName, Grade). Some of the constraints on the relation Student are:
 A student is assigned one unique Enrolment Number (EnrolNo).
 Two students may have same name.
 A student can register in one Programme only.
6
 A Programme consists of several compulsory courses.
 Grades can be “A”, “B”, “C”, or “D” and only one grade value is recorded for a student
in a course.
Perform the following task for the relation given above:
(i) What is the key to the relation?
(ii) Identify and list the functional dependencies in the relation.
(iii)Make an instance of this relation showing possible redundancies.
(iv) Decompose R into 2NF and 3NF relations.

Ques 7.

Explain the concept of Multi-valued dependency and Join dependency with the help of an example of each. Also, explain the 4th Normal Form and 5th Normal form.

Ques 8.

Explain the following terms with the help of an example of each – Assertion, Cursor, Stored Procedure, Triggers.

Ques 9.

Consider the following relational database:

Customer (custId, custName, custAddress, custPhone)
Account (AccountNumber, custId, TypeOfAccount, Balance)
Transaction (DateTimeofTransaction, AccountNumber, DebitORCredit, Amount)

The underlined attribute(s) in the relation forms the primary key. In relation Customer, the custID is
the unique identifier of a customer. The purposes of other attributes in Customer relation are self
explanatory. You may define the domain of different attributes. The TypeOfAccount attribute can
take the value (“Saving”, “Current”, “Salary”, “Other”). Please note that at a specific time of a date
only one transaction can be performed from an account. Please also note that the Account relation
has foreign key custID and Transaction relation has foreign key AccountNumber. Write and run the
following SQL queries on the database:
(i) Create the tables with the primary and foreign key constraints.
(ii) Insert at least 5 records in the first 2 tables and 20 records in the 3rd table.
(iii) List “Saving” Account details showing the AccountNumber, custName, custPhone,
Balance of all the accounts. These records should be shown in the order of custName.
(iv) Find all the transactions made by customer whose custID is “240002”.
(v) Find the list of those customers who have more than one account.
(vi) Find the total of Debit transactions made for Account Number “A0054”
(vii) Find the total of balance of all the accounts of a customer.
(viii) Find the list of customers whose name start with an alphabet “B”
(ix) List the pair of customers who share the same phone number.
(x) Find the list of the customers, who have not made any credit transaction since 1st January,
2023.

Ques 10.

Explain the ACID properties of transactions with the help of an example of each.

Ques 11.

What are the problems that can be encountered, if the three transactions (given in Figure 1) are run concurrently? Explain with the help of different transaction schedules of these transactions

Ques 12.

What are the problems that can be encountered, if the three transactions (given in Figure 1) are run concurrently? Explain with the help of different transaction schedules of these transactions.

                              Figure 1: Three Concurrent Transactions

Ques 13.

What is 2-Phase locking? Lock and unlock various data items of the transactions, given in Figure 1, using 2-Phase locking such that no concurrency related problem occurs, when the transactions A, B and C are executed concurrently

Ques 14.

) Explain the Log based Recovery with the help of an example. What are Redo and Undo operations. Why do you need checkpoint? Explain the process of recovery with check points with the help of an example Explain with the help of an example, how recovery is performed when Deferred database modification scheme is used.

Ques 15.

What is the cost of selection operation, when the index scan method is used? Explain with the help of an example. Explain the cost of Join operation when Merge-Join method is used.

Ques 16.

Make the query tree for the following query (assume the database of problem 2(d)).

SELECT c.custName, c. custId, a.AccountNumber, t.DebitORCredit
FROM Customer c, Account a, Transaction t
WHERE c.custId = a.custId AND a.AccountNumber = t.AccountNumber
AND Amount > 10000;

Ques 17.

What are object-relational database? Explain the concept of complex data types used in these databases. Explain the object model in the context of Object Oriented database systems. How objectoriented database systems are different from Object-relational database systems

Ques 18.

Explain the multi-dimensional data model of a data warehouse. Also, define the concept of decision tree with the help of an example. List any four applications of data mining.

Ques 19.

Explain the need of NoSQL databases. Explain the characteristics of any two types of NoSQL databases.

Ques 20.

 Write short notes on the following database technologies: (i) Distributed databases (ii) Block chain databases

• Latest IGNOU Solved Assignment
• IGNOU MCS 207 2024 2025 Solved Assignment
• IGNOU 2024 2025 Solved Assignment
• IGNOU PGDCA_NEW POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS 2024 2025 Solved Assignment
• IGNOU MCS 207 Database Management Systems 2024 2025 Solved Assignment

Looking for IGNOU MCS 207 Solved Assignment 2024 2025. You are on the Right Website. We provide Help book of Solved Assignment of PGDCA_NEW MCS 207 - Database Management Systemsof year 2024 2025 of very low price.
If you want this Help Book of IGNOU MCS 207 2024 2025 Simply Call Us @ 9199852182 / 9852900088 or you can whatsApp Us @ 9199852182
 

IGNOU PGDCA_NEW Assignments Jan - July 2025 - IGNOU University has uploaded its current session Assignment of the PGDCA_NEW Programme for the session year 2024 2025. Students of the PGDCA_NEW Programme can now download Assignment questions from this page. Candidates have to compulsory download those assignments to get a permit of attending the Term End Exam of the IGNOU PGDCA_NEW Programme.

Download a PDF soft copy of IGNOU MCS 207 Database Management Systems PGDCA_NEW Latest Solved Assignment for Session January 2025 - December 2025 in English Language.

If you are searching out Ignou PGDCA_NEW  MCS 207 solved assignment? So this platform is the high-quality platform for Ignou PGDCA_NEW  MCS 207 solved assignment. Solved Assignment Soft Copy & Hard Copy. We will try to solve all the problems related to your Assignment. All the questions were answered as per the guidelines. The goal of IGNOU Solution is democratizing higher education by taking education to the doorsteps of the learners and providing access to high quality material. Get the solved assignment for MCS 207 Database Management Systems course offered by IGNOU for the year 2024 2025.Are you a student of high IGNOU looking for high quality and accurate IGNOU MCS 207 Solved Assignment 2024 2025 English Medium? 

Students who are searching for IGNOU POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS (PGDCA_NEW) Solved Assignments 2024 2025 at low cost. We provide all Solved Assignments, Project reports for Masters & Bachelor students for IGNOU. Get better grades with our assignments! ensuring that our IGNOU POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS Solved Assignment meet the highest standards of quality and accuracy.Here you will find some assignment solutions for IGNOU PGDCA_NEW Courses that you can download and look at. All assignments provided here have been solved.IGNOU MCS 207 SOLVED ASSIGNMENT 2024 2025. Title Name MCS 207 English Solved Assignment 2024 2025. Service Type Solved Assignment (Soft copy/PDF).

Are you an IGNOU student who wants to download IGNOU Solved Assignment 2024? IGNOU PG DIPLOMA PROGRAMMES Solved Assignment 2023-24 Session. IGNOU Solved Assignment and In this post, we will provide you with all solved assignments.

If you’ve arrived at this page, you’re looking for a free PDF download of the IGNOU PGDCA_NEW Solved Assignment 2024 2025. PGDCA_NEW is for POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS.

IGNOU solved assignments are a set of questions or tasks that students must complete and submit to their respective study centers. The solved assignments are provided by IGNOU Academy and must be completed by the students themselves.