IGNOU MLIL 2 2026 - Create a database for 8 departmental budget heads and alloca

Question

Create a database for 8 departmental budget heads and allocate Rs 2 lakh each (10) for every head. Generate reports for the list of budget heads and the amount allocated.

09 Jan 2026

Answer :

Word Count : 196

To create a database for 8 departmental budget heads and allocate Rs 2 lakh each, follow these practical steps: 1. Create the Database: ```sql CREATE DATABASE DepartmentBudget; USE DepartmentBudget; ``` 2. Create the Table for Budget Heads: ```sql CREATE TABLE BudgetHeads ( HeadID INT AUTO_INCREMENT PRIMARY KEY, DepartmentName VARCHAR(50), AllocatedAmount DECIMAL(10,2)

______ ________ __________ _____ ___ _____ _________ ____ ________ _______ ________ ______.
_________ ____ __________ __________ _______.
______ __________ _________ ________ _________.
_________ _____ ____ __________ __________ __________ _______ ______ _________ _______.
___ _____ ___ ___ _____ __________ ______ __________.
________ _________ ________ __________ _____ _________.
________ _______ ___ ___ ____ __________ ______ __________ _________ ____ _________.
______ _______ __________ ___ ____.
______ _________ ___ ______ _____.
_______ ___ _______ _____ ________ ______ _____ _______ ____ ____ ______.
__________ ___ ________ _________ __________ __________ ______ _____ ______ ____ ____ _______.
_____ ______ _____ ____ __________ ______ ______ __________.
____ ____ ______ _____ ___ ____ __________ _____ ________ ______.
________ ___ ____ ________ __________.
_________ _________ _______ ________ _________.
____ ____ _____ ____ ____ ________ ____.
_________ _____ ________ ____ ________ ________ ____ _____ ______ _________.
_____ _________ _____ ______ ___.
______ ____ _____ _________ ______.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers