O'Reilly logo

Pentaho 5.0 Reporting by Example Beginner’s Guide by Dario R. Bernabeu, Mariano García Mattío

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Inventory

The inventory database contains the following tables:

The film table

The film table contains a list of all films (logical information), not necessarily in stock. The stock information (physical copy) is in the table inventory described as follows:

Column

Description

film_id

A primary key used to uniquely identify each film in the table.

title

The title of the film.

description

A short description or plot summary of the film.

release_year

The year the film was released.

language_id

A foreign key pointing at the language table; it is used to identify the language of the film.

original_language_id

A foreign key pointing at the language table; it is used to identify the original language of the film. It is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required