Level: Intermediate
Very early in Jazz music history, New York became the center of its development, shaping its own style. Nowadays, the Jazz scene is still alive and swinging. Let us now imagine that you have to develop an application where you need to store information about Jazz history and the current events around the New York Jazz scene. How would you store the data? How would you organize it? Which data types would you use? And most importantly, which types of questions will your application be able to answer from that data?
In this talk we will go through schema modeling having a problem as a starting point. We will study the guarantees that the database can provide, and what is better done at the application level. We will not only discuss data types but also normalization and some interesting extensions.