hello everyone!
My modelling might be wrong I'm trying to figure out queries that I'll be able to do with my modelling. Here is the scenario of my modelling: A surgeon order some surgical procedure and this S_procedure needs some surgical Instruments. Sometimes the surgeon will practice the surgical procedure by using a technology, this technology needs also some instruments additional/subtitutionnal from what the S_procedure needs. Also depending on the surgeon, sometimes he might add some instruments additionnaly from what the S_procedure or the technology needs.
I'm trying to know if I could answer these queries:
Which Surgeons needs additional instrument for a surgical procedure named "x" (nameOfsurgicalProcedure)?
What instruments needs a surgeon name "y" (lastname) for a surgical procedure named "x" (nameOfsurgicalProcedure)?
I'm trying to know if my modelling is optimal i added an IDsurgicalProcedure to the table "jt-surgeon_needs_instrument"
My modelling might be wrong I'm trying to figure out queries that I'll be able to do with my modelling. Here is the scenario of my modelling: A surgeon order some surgical procedure and this S_procedure needs some surgical Instruments. Sometimes the surgeon will practice the surgical procedure by using a technology, this technology needs also some instruments additional/subtitutionnal from what the S_procedure needs. Also depending on the surgeon, sometimes he might add some instruments additionnaly from what the S_procedure or the technology needs.
I'm trying to know if I could answer these queries:
Which Surgeons needs additional instrument for a surgical procedure named "x" (nameOfsurgicalProcedure)?
What instruments needs a surgeon name "y" (lastname) for a surgical procedure named "x" (nameOfsurgicalProcedure)?
I'm trying to know if my modelling is optimal i added an IDsurgicalProcedure to the table "jt-surgeon_needs_instrument"