As we mentioned earlier, Baker Cakes has built a number of applications to access their customer data. We’ll want to implement some views in our physical model to assist in the retrieval of data for these applications. Baker Cakes is running a marketing campaign to try to increase the number of retail customers in their loyalty program. They are sending out special promotions to those customers not yet enrolled in the program, and for those in the program, they are offering special features in their online ordering application. For the marketing application, we need to create a query that lists the names of all retail customers who are not yet enrolled in the loyalty program. For this, we’ll want to use a view in our physical data model. ...

Get Data Modeling Made Simple with CA ERwin Data Modeler r8 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.