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 10 SQL queries based on these tables for charity management system for Oracle
Tables:
1- Charity
With columns
-ID
-ADDRESS
2-ADDRESSES
With columns
-ADDRESSID
-CITY
3-Books
With columns
-BNO: which is for book number
-BTITLE: which it means book title
4- CHARITYPHONENUM
With columns
- CID
- PHONE_NUMBER
5-DONATION
With columns
-DONARID
-DONATION_NUM
-DATEOFDONATION
-STAFF_ID
-MONEYAMOUNT
6-DONATIONFOOD
With columns
-DONOR_ID
-DONATIONNUM
-STAFFID
7-DONOR
With columns
-DONOR_ID
-NAME
-ADDRESS
-EMAIL
-NUMBEROFDONATION
-DONOR_PHONE_NUM
8-FAMILY
With columns
-FAMILY_ID
-ADDRESS
-INCOME
-NUMBEROFMEMBER
-FAMILY_PHONE_NUM
9-FOOD
With columns
-FOODBANKID
-MEALPROGRAM
-FOODPANTRIES
-IDSTAFF
10-FOODFAMILY
With columns
-F_ID
-FOODBANK
11-FOODPERSON
With columns
-P_ID
-FOODBANK_ID
12-MAJORS
With columns
-MAJORID
-MAJOR
13-PERSON
With columns
-PERSON_ID
-ADDRESS
-PERSON_PHONE_NUM
14-STAFF
With columns
-SID
-FNAME
-LNAME
-DATEBIRTH
-ADDRESS
-EMAIL
-CHARITY_ID
-STAFF_PHONE_NUM
15-STUDENTS
With columns
-SID
-NAME
-TEST1
-TEST2
-ADDRESSID
-MAJORID
16- SUPERVISE
With columns
-STAFF_ID
-SUPERVISOR_ID
You can use these queries for example:
1. Select all charities with their addresses.
2. Retrieve donation information with donor details.
3. List all families with their phone numbers.
4. Get the total number of donations made by each donor.
5. Identify staff members supervising other staff.
6. List all books along with the charity they belong to.
7. Get the details of all donations exceeding $100.
8. Retrieve donors who have donated to the food bank.
9. List all major programs with the staff responsible.
10. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!