In Progress

SQL QUERIES assignment

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.

Notes :

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


plz ..

choose one query , and write SQL statement for it
to make sure , you understand the requirement

Skills: Java, MySQL, PHP, Software Architecture, SQL

See more: user case diagram, the assignment problem, sn it, problem assignment, data organizer, student manage, sql queries, sql java, queries, java sql, event organizer, ER diagram, image manipulation available, workflow 2013, php submit assignment, java fix problem, table queries, queries sql, sql problem, case assignment, delete sql php, php sql image, sql student, java student profile, java program report records

About the Employer:
( 33 reviews ) al khobar, Saudi Arabia

Project ID: #4471475

Awarded to:

sswijaya

Hi let me help you. Thanks.

$35 USD in 3 days
(0 Reviews)
0.0

25 freelancers are bidding on average $96 for this job

eperfections

Ready to do the SQL assignment !

$147 USD in 3 days
(426 Reviews)
7.5
dobreiiita

I can complete this project in a day....

$58 USD in 1 day
(210 Reviews)
6.6
harish1984

Hi, MySQL expert here. Please check Inbox.

$60 USD in 2 days
(70 Reviews)
6.1
theincredible

Can be done, give it to the expert

$79 USD in 3 days
(64 Reviews)
5.8
kchg

Hello, sir. I'm interested with your project. I'll do it for you. Regards.

$515 USD in 5 days
(34 Reviews)
5.6
MMaghawry

SQL expert working in Jeddah Saudi Arabia.

$176 USD in 3 days
(32 Reviews)
5.6
msabouri

I can help you.

$69 USD in 3 days
(54 Reviews)
5.2
ranjitsinha

I am ready to take your project. Please give me the chance to do this. Thanks.

$130 USD in 3 days
(103 Reviews)
5.0
nibiranijum

Hi, I am expert in query. Did lots of projects like this. Ready to start.

$88 USD in 3 days
(17 Reviews)
4.3
Reza2012

Hi I have more than nine years experience Database administration. I want to do the job if you allow me. Please see PM. Thanks.

$57 USD in 3 days
(3 Reviews)
3.1
raisuddin79

I download the document, diagram and database file (it's SQL server database). I test the database and confident about completing the query's. I have solid understanding on SQL (mysql and sql server both). I am confide More

$45 USD in 2 days
(5 Reviews)
2.4
navkesh

I am Microsoft Certified Developer and SQL DBA having around 6+ year of experience. My expertise includes .NET, ASP .NET, ADO .NET, VB .NET, C#, WCF, LINQ, Web Service, SQL Server, MySQL, PostgreSQL, AJAX, jQuery etc. More

$55 USD in 1 day
(0 Reviews)
0.0
techroom

yes i can.. should i send you a sample

$45 USD in 3 days
(0 Reviews)
0.0
staretzu

Hello, Please see PM

$50 USD in 2 days
(0 Reviews)
0.0
Prateeik

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.

$35 USD in 5 days
(0 Reviews)
0.0
marksong2010

I can do it very easily and quickly.

$55 USD in 3 days
(0 Reviews)
0.0
vikas235677

Hii i am DB2 IBM certified . you can trust me and can give me project. please think at once and give me chance to serve you.

$154 USD in 3 days
(0 Reviews)
0.0
ishudinu86

I will be to the point. Let me know.

$88 USD in 4 days
(0 Reviews)
0.0
muzzamilnoor

Experienced Oracle DBA and developer. This assignment will be completed to your complete satisfaction.

$43 USD in 3 days
(0 Reviews)
0.0
swapnilchavan18

Hi I am interested to do this.

$110 USD in 1 day
(0 Reviews)
0.0