All Questions
3 questions
1
vote
1
answer
95
views
Can i make a relationship between two relationships in the database?
I am making a database system where there are patients, doctors, categories and medical records.
doctor and patient has a relationship called treatments ( many-to-many )
patient and a relationship ...
6
votes
3
answers
5k
views
How to model Parent -> Child -> Grandchild if the Child can be removed
I'm dealing with a set of relationships where the child can be removed, but I obviously don't want to lose the connection between the grandchild and the parent. I did think about marking the child as "...
2
votes
1
answer
4k
views
Multi-variance products
My current system houses different variants of Products in different tables;
Productgroups
Productcolors
Productsizes
Productmodels
Products can reside under 1 Productgroup and can have multi-...