Writing an optimised SQL query

£10-20 GBP

Completed

Posted

over 5 years ago

£10-20 GBP

Paid on delivery

I'm providing you with a UML diagram (see attachment and the note below) and the following question based on which a SQL needs to be written. The Question is, Which Drugs are in a relationship with a Gene that is in a relationship with a Protein which has a relationship with another Protein where minimum positivity is 0.8 and minimum identicality is 0.85, and that other Protein is in a relationship with a Gene that has a relationship with the Disease "Asthma"? Note on the UML diagram: In the diagram, you will find 4 tables that contain protein data. the Protein_Protein table that they all have a relationship with is a joint table, where target_protein_id and matched_protein_id, each can belong to any of the 4 tables, ie. these two foreign keys are not necessarily stored in one single Protein table.

Database Administration

Project ID: 18239444

About the project

6 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@PiasKumarDas

Hi, I am expert in writing inner join,full join i.e. any join query between tables based on primary-foreign key relationships. Thanks

£18 GBP in 1 day

5.0

(20 reviews)

4.5

6 freelancers are bidding on average £42 GBP for this job

@softechinfinites

Hello, I have 5 years experienced in Database Administration, Database Development, MySQL, Oracle, SQL and assure you the quality work on time as per your requirements. I will provide plagiarised free content with in the deadline and always available on freelancer 24x7 for any support. Guaranteed Plagiarism Free Content As I have TURNITIN ACCOUNT & COPYSCAPE PREMIUM ACCOUNT. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.

£150 GBP in 3 days

4.9

(3 reviews)

3.9

@anshsparkle

HELLO I CAN START RIGHT NOW - I AM EXPERT IN Database Administration Database Development and I BET YOU CANNOT FIND BETTER FREELANCER THAN ME ... pLEASE MESSEGE ME AND LETS DISCUSS THE THINGS THANKS

£18 GBP in 1 day

5.0

(1 review)

0.4

@articlewriter321

Hello there, I have gone through the requirements and I would like to undertake it. I am an an expert in SQL and I would like to provide quality work. please send me a message so that we can discuss further.

£18 GBP in 1 day

0.0

(0 reviews)

0.0

@multixperts

Good Day I am Abid Malik, a Masters of Project Management with over 12 years of experience in the field of Information Technology, Web Application Development n Design & Digital Marketing ( Business Analyst ). I have the sound knowledge of the digital world. I am dedicated and up to date with the current market trends and standards. You can count on my skills for your project regarding quality and deadlines. I would be glad if you consider my profile for the stated job. Thanks and Regards, Abid Malik

£33 GBP in 1 day

0.0

(0 reviews)

0.0

@ivan990

I'm new here, so I need to do some jobs to get reputation! If you want I can solve this problem in one day. Do you have some data to fill the database?

£13 GBP in 1 day