IGNOU MCS 23 SOLVED ASSIGNMENT

Ques 1.

Differentiate between a File Processing System and a Database Management System (DBMS) based on four key aspects.

Ques 2.

Explain the three-level architecture of a DBMS (External, Conceptual, and Internal). How does this architecture support Logical and Physical Data Independence?

Ques 3.

What are the ACID properties of a transaction? Explain each property with a suitable example of an airline ticket booking.

Ques 4.

Differentiate between DDL (Data Definition Language) and DML (Data Manipulation Language) statements in SQL. Provide two examples for each category.

Ques 5.

Explain the difference between 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). Provide an example of a relation that is in 3NF but not in BCNF.

Ques 6.

An online learning platform, "EduSphere," needs a database to manage its operations. The requirements are as follows:

 
• The platform has many Students. Each student is identified by a unique StudentID and has a Name, Email, and RegistrationDate.



 
• The platform features several Instructors. Each instructor has a unique InstructorID, Name, and a short Bio.



 
• There are multiple Courses on offer. Each course has a unique CourseID, a Title, Duration (in hours), and a Fee.



 
• An instructor can teach multiple courses, but each course is taught by only one instructor.



 
• A student can enroll in multiple courses, and a course can have many students. When a student enrolls, the EnrollmentDate and the final Grade obtained are recorded.



 

Ques 7.

Design a complete ER (Entity-Relationship) diagram for the "EduSphere" platform. Clearly show all entities, attributes (including primary keys), relationships, and their cardinality constraints.

Ques 8.

Convert the ER diagram from part (a) into a set of relational schemas (tables). You must underline the primary key for each table and clearly indicate all foreign keys and the tables they reference.

Ques 9.

Consider the following relational schemas for a company database:

• Employees (EmpID, EmpName, Salary, DeptID)


• Departments (DeptID, DeptName)


• Projects (ProjID, ProjName, Lead_EmpID)


 

Ques 10.

Write and execute SQL queries for the following tasks. Make suitable assumptions where necessary.

(a) Create the Employees table with EmpID as the primary key and DeptID as a foreign key referencing the Departments table. The Salary should not be negative. (4 Marks)

(b) List the names and salaries of all employees working in the 'Technology' department, sorted in descending order of their salary.

(c) Find the name of each department and the number of employees working in it. Display only those departments that have more than 10 employees.

(d) Find the names of all employees whose salary is greater than the average salary of all employees in the company.

(e) List the names of all projects along with the name of the employee who is leading the project.

Ques 11.

 Consider the relation R(A, B, C, D, E, F) with the following set of Functional Dependencies (FDs):

F = { A → BC, CD → E, B → D, E → A }

(i) Find all the candidate keys for the relation R.

(ii) Is the relation R in 3NF? Justify your answer.

(iii) Decompose the relation R into a set of relations that are in BCNF.

Ques 12.

Consider the following schedule S with two transactions T1 and T2:

S: R1(X); W1(X); R2(X); W2(X); R1(Y); W1(Y); Commit1; R2(Y); W2(Y); Commit2;

(i) Draw the precedence (serializability) graph for the schedule S.

(ii) Is the schedule S serializable? If yes, provide the equivalent serial schedule(s). If no, explain why.

iii) Identify any concurrency problems (e.g., Lost Update, Dirty Read) present in this schedule. Explain how the problem occurs.

Ques 13.

Differentiate between a File Processing System and a Database Management System (DBMS) based on four key aspects.

Ques 14.

Explain the three-level architecture of a DBMS (External, Conceptual, and Internal). How does this architecture support Logical and Physical Data Independence?

Ques 15.

What are the ACID properties of a transaction? Explain each property with a suitable example of an airline ticket booking.

Ques 16.

Differentiate between DDL (Data Definition Language) and DML (Data Manipulation Language) statements in SQL. Provide two examples for each category.

Ques 17.

Explain the difference between 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). Provide an example of a relation that is in 3NF but not in BCNF.

Ques 18.

An online learning platform, "EduSphere," needs a database to manage its operations. The requirements are as follows:

 
• The platform has many Students. Each student is identified by a unique StudentID and has a Name, Email, and RegistrationDate.



 
• The platform features several Instructors. Each instructor has a unique InstructorID, Name, and a short Bio.



 
• There are multiple Courses on offer. Each course has a unique CourseID, a Title, Duration (in hours), and a Fee.



 
• An instructor can teach multiple courses, but each course is taught by only one instructor.



 
• A student can enroll in multiple courses, and a course can have many students. When a student enrolls, the EnrollmentDate and the final Grade obtained are recorded.



 

Ques 19.

Design a complete ER (Entity-Relationship) diagram for the "EduSphere" platform. Clearly show all entities, attributes (including primary keys), relationships, and their cardinality constraints.

Ques 20.

Convert the ER diagram from part (a) into a set of relational schemas (tables). You must underline the primary key for each table and clearly indicate all foreign keys and the tables they reference.

Ques 21.

Consider the following relational schemas for a company database:

• Employees (EmpID, EmpName, Salary, DeptID)


• Departments (DeptID, DeptName)


• Projects (ProjID, ProjName, Lead_EmpID)


 

Ques 22.

Write and execute SQL queries for the following tasks. Make suitable assumptions where necessary.

(a) Create the Employees table with EmpID as the primary key and DeptID as a foreign key referencing the Departments table. The Salary should not be negative. (4 Marks)

(b) List the names and salaries of all employees working in the 'Technology' department, sorted in descending order of their salary.

(c) Find the name of each department and the number of employees working in it. Display only those departments that have more than 10 employees.

(d) Find the names of all employees whose salary is greater than the average salary of all employees in the company.

(e) List the names of all projects along with the name of the employee who is leading the project.

Ques 23.

 Consider the relation R(A, B, C, D, E, F) with the following set of Functional Dependencies (FDs):

F = { A → BC, CD → E, B → D, E → A }

(i) Find all the candidate keys for the relation R.

(ii) Is the relation R in 3NF? Justify your answer.

(iii) Decompose the relation R into a set of relations that are in BCNF.

Ques 24.

Consider the following schedule S with two transactions T1 and T2:

S: R1(X); W1(X); R2(X); W2(X); R1(Y); W1(Y); Commit1; R2(Y); W2(Y); Commit2;

(i) Draw the precedence (serializability) graph for the schedule S.

(ii) Is the schedule S serializable? If yes, provide the equivalent serial schedule(s). If no, explain why.

iii) Identify any concurrency problems (e.g., Lost Update, Dirty Read) present in this schedule. Explain how the problem occurs.

• Latest IGNOU Solved Assignment
• IGNOU MCS 23 2025 2026 Solved Assignment
• IGNOU 2025 2026 Solved Assignment
• IGNOU BCA Bachelor of Computer Applications 2025 2026 Solved Assignment
• IGNOU MCS 23 Introduction to Database Management Systems 2025 2026 Solved Assignment

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

IGNOU BCA Assignments Jan - July 2026 - IGNOU University has uploaded its current session Assignment of the BCA Programme for the session year 2025 2026. Students of the BCA 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 BCA Programme.

Download a PDF soft copy of IGNOU MCS 23 Introduction to Database Management Systems BCA Latest Solved Assignment for Session January 2026 - December 2026 in English Language.

If you are searching out Ignou BCA  MCS 23 solved assignment? So this platform is the high-quality platform for Ignou BCA  MCS 23 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 23 Introduction to Database Management Systems course offered by IGNOU for the year 2025 2026.Are you a student of high IGNOU looking for high quality and accurate IGNOU MCS 23 Solved Assignment 2025 2026 English Medium? 

Students who are searching for IGNOU Bachelor of Computer Applications (BCA) Solved Assignments 2025 2026 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 Bachelor of Computer Applications Solved Assignment meet the highest standards of quality and accuracy.Here you will find some assignment solutions for IGNOU BCA Courses that you can download and look at. All assignments provided here have been solved.IGNOU MCS 23 SOLVED ASSIGNMENT 2025 2026. Title Name MCS 23 English Solved Assignment 2025 2026. Service Type Solved Assignment (Soft copy/PDF).

Are you an IGNOU student who wants to download IGNOU Solved Assignment 2024? IGNOU BACHELOR DEGREE 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 BCA Solved Assignment 2025 2026. BCA is for Bachelor of 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.