I have the following class diagram with no more informations related to multiplicity or any other thing. I have to propose a relational database based only on this diagram so I would need to ask the community opinion whether I did well or not. Please share your view. Thank you.
I need to propose a database relation, I added:
Needs to select all "Services-Serviciu" which expose "Capabilites-Capabilitate" from de list of "Dependencies-Dependenta" of RayTracingEngine "Services"
I made the following:
SELECT * FROM
Serviciu s
INNER JOIN Capabilitate C ON s.id = c.id_C
INNER JOIN Dependenta d ON s.id = d.id_D
WHERE d.id_D = c.id_C AND s.nume = "RayTracingEngine"
Can you please help me if I did well or needs something to be changed ? Thank you.