Sample Model

When you install CA ERwin Data Modeler, a sample model by name eMovies is installed. Use this model as an example to learn data modeling and to learn how to use the tool.

This model is available in the following folder:

<install folder>\ERwin Data Modeler r9\BackupFiles\Samples\Standard

Note: If you are using Microsoft Windows 7 or Windows 8, you must run the data modeling tool as an administrator to open the eMovies model.

The business requirements of this model are as follows:

Manage employee details
Manage store details
Manage movie details
Manage copies of movies
Manage customer details
Maintain movie rental details for customers
Record payment details for rented movies
Display the credit status of customers
Generate invoices for customers
Display overdue details for customers
Search for customers
Search for movies that are rented based on the rented date, customer phone number, employee number, or movie number

Apart from entities, attributes, and relationships, this model serves as an example for the following features:

Domains
Logical Model
Subject Area
Annotation
Key Groups
ER Diagrams
Naming Standards Object
Data Type Standards Object
Themes
Validation Rules