Writing an optimised SQL query

£10-20 GBP

Finalizat

Data postării:

peste 5 ani în urmă

£10-20 GBP

Plata la predare

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

ID-ul proiectului: 18239444

Despre proiect

6 propuneri

Proiect la distanță

Activ: 5 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@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 în 1 zi

5,0

(20 recenzii)

4,5

6 freelanceri plasează o ofertă medie de £42 GBP pentru proiect

@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 în 3 zile

4,9

(3 recenzii)

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 în 1 zi

5,0

(1 recenzie)

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 în 1 zi

0,0

(0 recenzii)

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 în 1 zi

0,0

(0 recenzii)

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 în 1 zi