Sounds like the classic entity–relationship model

I am assisting a professor with his intro to databases class this semester and that was the first thing taught there

https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_mo...