Writing an optimised SQL query
£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.
Project ID: #18239444
About the project
Awarded to:
Hi, I am expert in writing inner join,full join i.e. any join query between tables based on primary-foreign key relationships. Thanks
6 freelancers are bidding on average £42 for this job
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
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
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.
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
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?