Writing an optimised SQL query

£10-20 GBP

Terminado

Publicado

hace más de 5 años

£10-20 GBP

Pagado a la entrega

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 del proyecto: 18239444

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 5 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 1 día

5,0

(20 comentarios)

4,5

6 freelancers están ofertando un promedio de £42 GBP por este trabajo

@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 en 3 días

4,9

(3 comentarios)

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 en 1 día

5,0

(1 comentario)

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 en 1 día

0,0

(0 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 1 día