Obaysch

Deliberate Data Structure Design

Data Vault Modeling Exercise: Cinemania

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 in 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

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, flipchart or Miro board.

Use the list of
possible core business concepts as inspiration for your hubs. Take 10 to 15 minutes.

First published on Medium, 2018-05-11

Data Vault Modeling Exercise: Deep Dive

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 in multiple groups (2 to 4). Then, you can discuss and compare the results from the different groups afterwards.

By Wellbeach Dive Resort [CC BY-SA], via Wikimedia Commons

Case Study

Deep Dive is a successful diving course provider on a remote tropical island close to atolls and coral reefs that make for perfect diving spots.

The company serves all kinds of clients, from professional divers wanting to improve their skills over well-to-do families looking for a special vacation to adventurous backpackers that have to work for Deep Dive to pay their time under water.

The diving spots around the island differ in size and difficulty, making them suitable for various courses for different audiences.

Possible Core Business Concepts

  • Boat
  • Course
  • Diving Spot
  • Employee
  • Equipment
  • Hotel
  • Visitor

Exercise

As a group, create the backbone of a data vault model (hubs and links) for Deep Dive on a whiteboard, flipchart or Miro board.

Use the list of possible core business concepts as inspiration for your hubs. Take 10 to 15 minutes.

© 2026 Obaysch

Theme by Anders Noren — Up ↑