Writing an optimised SQL query

£10-20 GBP

Færdiggjort

Slået op

over 5 år siden

£10-20 GBP

Betales ved levering

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

Projekt-ID: 18239444

Om projektet

6 forslag

Projekt på afstand

Aktiv 5 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@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 på 1 dag

5,0

(20 anmeldelser)

4,5

6 freelancere byder i gennemsnit £42 GBP på dette 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 på 3 dage

4,9

(3 anmeldelser)

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 på 1 dag

5,0

(1 bedømmelse)

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 på 1 dag

0,0

(0 anmeldelser)

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 på 1 dag

0,0

(0 anmeldelser)

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 på 1 dag