(Grade X) Project Work
Project Title : Database Design for “KrishiKranti” Farming App
Design a database for a farming app named KrishiKranti
that helps farmers manage crops, tools, sales, and farm activities.
Your task:
a. Create Table and Insert Records
Create a table named Farmers with the following fields
and insert at least 15 records:
Farmer_ID
Name
Crop_Type
Address
Income
b. Add a new field named Farm_Size in the above table.
c. Display Name, Crop_Type, and Address of all farmers
from the table.
d. Display all the records of farmers whose Address is
"Kavre".
e.Display Farmer_ID, Name, and Income from the table.
f. Increase the Income of all farmers by 10%.
g. Update the Name to "Ramesh" and Crop_Type to
"Rice" where Farmer_ID is 5.
h.Delete the record of the farmer named "Sita".
i. Display all the records in ascending order by Name.
j. Display all the records whose Crop_Type starts with
"K".
k. Multiple Conditions
Display the records of farmers whose:
Crop_Type is "Vegetables"
AND Address is "Bhaktapur"
l. Display the records of farmers whose Income lies
between 25,000 and 40,000.
Note:
· You can take reference from https://doanepal.gov.np/ne/
which is the
URL of 'Ministry of Agriculture and Livestock Development
for Farming' for related information that can be useful to design your
database.
· Prepare the
project in A4 size paper.
· The project must
be done in written form with neat handwriting.
· Use blue or
black pen only.
· Maintain proper
margins and headings.
· Draw tables
neatly using a ruler.
·
Write each question clearly before writing its SQL query and output
table wherever required.