The following 27 queries are required ,
where you should submit the correct SQL queries that execute the following missions. Your queries should reflect all available data through the SN program’s interface (e.g. displaying the user's profile, showing No of Collected Points by a volunteer on the screen), and manage the volunteering workflow through records manipulation (e.g. adding new participation by a volunteer, changing the rank, deleting an organizer's account). You should offer the volunteer/event/organizer a report of all his/her information and volunteering progress.
1- Activites table isn't required , I try to delete it , but it didn't delete .
2- multivalued photo all the coulmns are primary key , [url removed, login to view] + photo .. but the photo couldn't be primary key because the data type is image
could you fix these problem please ...
And in the attachment my ER diagram , in case you need it !
- assignment for student - low budget -
Updated : data base files - attached
choose one query , and write SQL statement for it
to make sure , you understand the requirement
25 freelancers are bidding on average $96 for this job
I m computer science student and i can do query fluently as it is my daily routine to do so. please contact me with the project details and i can assure to deliver the project in time.