Container Tracking Schemas

The normalized relational form of the container tracking schema is shown in Figure B.1.

Figure B.1: The relational model container tracking schema.

The dimensional-fact form of the container tracking schema is shown in Figures B.2 and B.3. Figure B.2 shows facts for voyages of containers and Figure B.3 shows damage sustained to containers. In both Figures B.2 and B.3, fact tables are shaded and dimension tables are not.

Figure B.2: Container voyages dimensional-fact tracking schema.

Figure B.3: Container damage dimensional-fact tracking schema.

Demographics Schema

Two demographics schemas were used in this book, the first is shown in Figure B.4. The second version, shown in Figure B.5, is a slightly enhanced version containing population and foreign exchange information.

Figure B.4: Demographics for the locations dimension.

Figure B.5: Enhanced demographics.

Inventory-Accounting Schema

The schema in Figure B.6 represents the original normalized version of the OLTP database schema from which the data warehouse schema was created. The data warehouse schema is shown in Figure B.7.

Figure B.6: OLTP transactional normalized schema.

Figure B.7: The sales and purchases data warehouse schema.

Sample Schemas

Figure B.7 shows the data warehouse schema, containing two fact table star schemas.