Question: Generate any 1 0 SQL queries based on these tables for charity management system for Oracle Tables: 1 - Charity With columns - ID -
Generate any SQL queries based on these tables for charity management system for Oracle
Tables:
Charity
With columns
ID
ADDRESS
ADDRESSES
With columns
ADDRESSID
CITY
Books
With columns
BNO: which is for book number
BTITLE: which it means book title
CHARITYPHONENUM
With columns
CID
PHONENUMBER
DONATION
With columns
DONARID
DONATIONNUM
DATEOFDONATION
STAFFID
MONEYAMOUNT
DONATIONFOOD
With columns
DONORID
DONATIONNUM
STAFFID
DONOR
With columns
DONORID
NAME
ADDRESS
EMAIL
NUMBEROFDONATION
DONORPHONENUM
FAMILY
With columns
FAMILYID
ADDRESS
INCOME
NUMBEROFMEMBER
FAMILYPHONENUM
FOOD
With columns
FOODBANKID
MEALPROGRAM
FOODPANTRIES
IDSTAFF
FOODFAMILY
With columns
FID
FOODBANK
FOODPERSON
With columns
PID
FOODBANKID
MAJORS
With columns
MAJORID
MAJOR
PERSON
With columns
PERSONID
ADDRESS
PERSONPHONENUM
STAFF
With columns
SID
FNAME
LNAME
DATEBIRTH
ADDRESS
EMAIL
CHARITYID
STAFFPHONENUM
STUDENTS
With columns
SID
NAME
TEST
TEST
ADDRESSID
MAJORID
SUPERVISE
With columns
STAFFID
SUPERVISORID
You can use these queries for example:
Select all charities with their addresses.
Retrieve donation information with donor details.
List all families with their phone numbers.
Get the total number of donations made by each donor.
Identify staff members supervising other staff.
List all books along with the charity they belong to
Get the details of all donations exceeding $
Retrieve donors who have donated to the food bank.
List all major programs with the staff responsible.
Find the person associated with each food bank.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
