Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
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 ...
ahmed nader's user avatar
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 "...
fgblomqvist's user avatar
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-...
User2910293's user avatar