Data Modeling
Ex-1 Scenario Under the motion picture studio system of the 1930s and ‘40s in the US,
? an actor could work on any number of pictures (zero, one, or many),
? each picture had at least one actor (one or many),
? every actor belonged to one and only one studio, and
? every studio had at least one actor.Contract actors were often “lent” from one studio to another for the production of one picture. Do not model this practice. It did not change the fact that the actors “belonged” to their original studios.Do not model the fact that pictures belonged to studios.The only aspects you should model are the ones presented here.
Don’t invent complications.
Categories: