CA ERwin Data Modeler Editions › Sample Model

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