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

16 Apr 2024

Answer :

Word Count : 634

Creating a database for departmental budget heads and allocating funds can be achieved using a variety of database management systems (DBMS) such as MySQL, PostgreSQL, or Microsoft SQL Server. For the sake of this practical answer, let's design a simple solution using SQLite, which is lightweight and doesn't require a separate server process. SQLite databases are self-contained, meaning they are stored as a single file, making them easy to manage.

Step 1: Database Design

First, we need to design the structure of our database. In this case, we'll have two tables: one for budget heads and another for allocations.

```sql
CREATE TABLE budget_heads (
_____ ______ ______ ________ ________ _______ ___ _________ ________.
________ _____ _________ ________ _____ _________ _________ ______ ________ ______.
_____ ________ ____ ___ _____ _____.
_____ _______ _________ _______ ___ __________ _______ ___ _________.
_________ ________ ______ ________ ___.
__________ _________ ___ ___ ______ ______ ________ _________ ______ _____ ___ _______.
______ _______ _____ __________ ______ _____ _____.
_________ _____ ______ ________ ______ ______.
________ _______ ______ ________ __________.
___ ________ ________ ___ _____ ____ _______ _______ _______.
________ ____ ________ _______ ____ _________ _________ ______ _______ _______.
_________ ______ ____ _____ _______.
__________ _____ ____ _______ ________.
___ _______ _________ _________ ________ __________ _______ ______ ______ _________ ____.
________ _________ ________ _____ _________ ____ __________.
_______ _____ __________ ________ _____ _________ ___ _________ ___ ___.
___ ______ ___ _________ ________ ________ ____ _____ _______ _______ ____.
_____ ____ ______ _______ _____ ____ ________ _________ ________ ______.
___ _______ _____ __________ ____ __________ _______ _____ __________.
______ _________ _________ ____ ___ _________ _________ ___ ____ _______.
_________ ___ ________ ___ ______ ________.
_____ _________ ________ _____ _____ ___ ____ ___ _____ _______ _________.
____ ________ ____ __________ ________ _______ ______ ___.
_________ _______ _______ __________ _______ __________ ____ ________.
______ ___ ___ _________ _________.
_____ ____ ________ _________ ____ ______ __________ ____.
______ _______ ___ _____ ______ _______ ______ __________ ___.
______ ____ __________ _________ ___ __________ __________ _____ _________ _________ __________ _____.
_________ ________ __________ ______ ______ _______.
_______ _________ ____ ____ _____ ________ ______ _____ _____.
________ ________ ________ ___ _______.
______ ____ ______ _______ __________ _______ ______ _______.
______ _________ ______ _______ __________ ________ ________ ____ ____.
_____ _________ ________ ______ _______ ________ ____ _________.
_______ ____ ________ __________ _____ _____.
________ _______ ___ _____ _________ ___ ___ ___ __________.
_______ _____ ______ __________ _________ _________ ____ __________ _____ ___ ____ _____.
____ ______ _______ __________ ______ _________ ___ ____ _________.
_________ _______ ______ _____ __________ ______ ______ ____ ______.
_____ ________ ____ _____ _________ _____ ________ ___ ________ ______ __________ ________.
_______ _______ ________ _____ ___ _______ ____ ___ _________ __________.
_______ ___ ____ _____ __________.
_____ _____ ______ _______ ___ _________ _________.
______ _______ ____ _________ _________ _____ ____ ________ _____ _________ _____.
_________ _________ ______ __________ ____ _________ _____ _____.
_______ ______ _____ ___ _______ _____ ___.
________ _____ _______ ____ __________ __________ ___ _______ __________ ______.
______ ____ ____ ______ _________.
______ ______ _____ ________ ____ ________ _____ ____ _______ ____.
_____ __________ ______ __________ ______ ____ ____ __________ ______ ____.
_____ ______ ______ ________ ___ ____.
________ ____ _____ __________ _____ ____ _________ _______.
____ ________ ____ ______ ___ _______ _______ ________ ________ ______ ________ ________.
_________ __________ _______ _________ ___ _____.
__________ __________ _______ ____ _________.
_________ ____ ____ ______ ________ _______ ___ _________ __________.
_________ ________ ______ _________ _______.
____ ________ ______ ____ _________ _____ _________ ___ ___ ____ __________.
___ _______ _____ ___ _________ __________ ____ __________ ________.
________ _____ __________ _________ _________ _____.
_____ _________ _____ ______ _______.
________ ____ _______ _________ __________ ____ ______ _______ ___.
_______ ____ _________ _________ ________ ______ ________ ________ _________.
__________ _____ __________ _____.
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★★★