This exercise has been created for the Data Modeling Meetup Munich (DM3).

It works best with small groups (3 to 5 people). If possible, split your team into multiple groups (2 to 4). Then, you can discuss and compare the results from the different groups afterwards.

By Fernando de Sousa from Melbourne, Australia (Flickr) [CC BY-SA 2.0], via Wikimedia Commons

By Fernando de Sousa from Melbourne, Australia (Flickr) [CC BY-SA 2.0], via Wikimedia Commons

Case Study

Cinemania is a successful movie theater chain with multiplex cinemas in multiple locations.

Films are shown in 2D or 3D, dubbed, with subtitles or in their original foreign-language versions. There are special offers like discount days, family screenings or sneak previews.

You can buy tickets online, via phone or at the box office.

Possible  Core Business Concepts

• Cinema
• Screen
• Film
• Screening
• Customer
• Ticket
• Employee

Exercise

As a group, create the backbone of a data vault model (hubs and links) for Cinemania on a whiteboard or flipchart. Use the list of possible core business concepts as inspiration for your hubs. Take 10 to 15 minutes.

Possible solution, 2023-07-07 (PNG file)

First published on Medium, 2018-05-11