Create a database for 5 departmental budget heads and allocate Rs.l la

Question

Create a database for 5 departmental budget heads and allocate Rs.l lakh each for every head. Generate reports for the list of budget heads and the amount allocated.

10 Mar 2023

Answer :

Word Count : 623

To create a practical database for departmental budget heads, we first need to conceptualize the structure of the database and the necessary tables to store the data. Here, we'll use a basic relational database system (such as MySQL, SQLite, or PostgreSQL) to manage and retrieve budget allocation information.

### Step 1: Define the Database Structure

The database will contain a table that stores information related to the budget heads, including the department and the amount allocated. We will define a simple table called `Department_Budgets`. The structure of the table will include the following columns:

1. Budget_ID: A unique identifier for each budget head.
2. Department_Name: The name of the department (e.g., Finance, HR, IT, Marketing, and Operations).
3. Allocated_Amount: The amount allocated ______ _____ ______ ___ ___ _______ _________.
_____ ________ _____ _______ ___.
_________ _____ ____ _________ ______ _______ ________ __________ _____ ___ _______.
__________ ________ ________ _________ _____ _____ __________ _________ ________.
_________ _______ ________ _____ _______.
______ ____ ________ _______ _________ ______ ___ _____ ________ ______ _________.
__________ ______ __________ _________ ______.
_____ ____ _____ ___ ______ ____ _______.
__________ _________ _____ _______ ______ _________.
________ ________ ______ ______ ______ _______ __________ __________ ________.
_____ ______ ____ ____ _________ _______ _____ _________ _________ _____.
_____ _______ ______ _____ ______ ________ ________ ____ _____.
_______ __________ _____ _____ _______ _________ __________.
___ _______ _________ ____ ________ _______ __________ _____ _____.
____ ______ _______ __________ ______ ______.
_____ ___ _____ ________ __________ ______ _____ _________ ________ _____ ______ ___.
_______ ________ _____ ____ _________ _____.
________ ____ _____ ______ _______ ___ ___.
____ __________ __________ _____ ________ ___ __________ ________.
___ _________ ____ ____ _________ ___ __________ ___ __________ ______ ___ ____.
____ ________ _____ __________ ___ _____ ____ _________ __________.
____ _________ ____ _________ _______ ____ ___ ___ ____ ____ ___.
_______ ___ ___ ________ ____.
___ __________ _________ ____ ______ ____ ___ ________ _______ _____ __________ ________.
_____ __________ _____ ________ __________ _______ _________ __________.
____ ____ ____ ___ _________ __________ ____ _______ __________ _______ __________ _______.
___ ___ _______ _________ _____ ___ ________.
_____ ___ __________ __________ _____ __________.
____ __________ _________ _________ ___ _____ ___ ____ _______ ___ _________.
_____ ___ ___ ________ ______ ____ ____ ______ _________ _____ ___ _________.
______ _____ _______ ______ __________ _____ ___ _____ __________ ______.
________ _____ _______ ____ _____ ________ _____ ____ _________.
_________ _____ ______ ____ ___ ______ ____.
_____ ____ _____ ________ __________.
_____ ______ ____ _________ ________ ______ ______ ____ __________.
______ _______ _____ ______ ____ __________.
_________ ________ _____ ________ _____.
_______ ____ _______ _____ __________ ________ _______ _____ _______.
_________ ________ ________ __________ ______.
_____ _________ __________ _____ ________ ____ _____.
_________ ___ ________ ________ _________ ________ __________ _______ ________ _______ _____ _______.
____ _______ ________ _________ _______.
____ _________ ____ _______ ____ ______ ________ ___ ______.
______ _____ _______ ________ _____ __________ __________ _____ ______ _________.
_________ _______ ____ _______ ___ ____ _______ ___ __________.
________ ______ ______ ____ _________ ___ __________.
_______ __________ _____ ___ ____ ________.
____ _____ _____ _______ _____ _________ __________.
_______ _______ _____ _____ ______.
____ _________ ___ _____ _________ ___.
______ _______ __________ _______ ______ _________ ____ _____.
______ ________ ____ ________ _________ ___ ______ _____ ____.
____ _________ __________ ________ ____ __________ _______ ____ ________ _______.
___ _______ _____ ____ __________ ______ _____ ___ __________ ______.
_________ __________ _____ _________ _______ _________ _______.
_________ ______ ________ ____ ________ _________.
__________ ______ ________ ________ _________.
___ _____ ___ _________ _____ ________ ____ ___ ___ ___.
__________ __________ ______ _________ ______ ___ ____ _____ __________.
_______ ____ ___ _____ ______ ________ _________ ____.
_______ ___ _______ ________ ___.
_______ _______ ___ _________ ____ _____ _______ _____.
______ ______.
Get Full Answer on WhatsApp

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

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★