Writing an optimised SQL query

Completed Posted 5 years ago Paid on delivery
Completed 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 Database Development MySQL Oracle SQL

Project ID: #18239444

About the project

6 proposals Remote project Active 5 years ago

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
(20 Reviews)
4.5

6 freelancers are bidding on average £42 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 More

£150 GBP in 3 days
(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
(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 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 ha More

£33 GBP in 1 day
(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
(0 Reviews)
0.0