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.
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), ______ ________ __________ _________ ___ ________ ___ ___ _____ _____.
___ ______ _____ _______ ___ __________.
_________ ______ _________ ___ _______ __________ ___ ____ ____ _________.
___ ________ _________ __________ _______ _____ _________ _________ ________ _________ ____ __________.
_______ _____ ______ _______ _____.
____ _______ ____ __________ ____ ______ _____ __________.
_____ _______ ________ _____ _________ _________ ______ ____ __________ ___.
______ ____ _____ _________ __________ ________ _________ ______ ______ ______.
_________ _______ ______ ______ _____ ________ _______ _______ ___ _______ ________.
______ __________ _______ _________ _____ _________.
___ ____ ___ ___ _______ ________ _______ _________ ______ ___.
_________ __________ _____ ___ ___ ______ ________ _____ _____ _______ _____.
_____ _________ _________ _________ ____ ____ __________ __________ ________ ___.
_______ ________ ______ ___ ___ ___ ______ _____ ____.
______ ________ _________ _____ ________ _____ ______ ________ _______ _______.
______ ____ ________ __________ ___ __________ __________ ________ _____.
Get Full Answer on WhatsApp
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), ______ ________ __________ _________ ___ ________ ___ ___ _____ _____.
___ ______ _____ _______ ___ __________.
_________ ______ _________ ___ _______ __________ ___ ____ ____ _________.
___ ________ _________ __________ _______ _____ _________ _________ ________ _________ ____ __________.
_______ _____ ______ _______ _____.
____ _______ ____ __________ ____ ______ _____ __________.
_____ _______ ________ _____ _________ _________ ______ ____ __________ ___.
______ ____ _____ _________ __________ ________ _________ ______ ______ ______.
_________ _______ ______ ______ _____ ________ _______ _______ ___ _______ ________.
______ __________ _______ _________ _____ _________.
___ ____ ___ ___ _______ ________ _______ _________ ______ ___.
_________ __________ _____ ___ ___ ______ ________ _____ _____ _______ _____.
_____ _________ _________ _________ ____ ____ __________ __________ ________ ___.
_______ ________ ______ ___ ___ ___ ______ _____ ____.
______ ________ _________ _____ ________ _____ ______ ________ _______ _______.
______ ____ ________ __________ ___ __________ __________ ________ _____.
Get Full Answer on WhatsApp
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★