Caché QuickStart Tutorial
Contact Management Data Model
Much of the tutorial focuses on building a web-based contact management application. When complete, this application will allow you to store information about your contacts, their addresses, and phone numbers. You will be able to search, edit, add, and delete contacts through a web interface.
From an object-oriented perspective, the model will consist of three classes:
The following diagram shows this relationship:
From a relational perspective, both Contact
will be represented by separate tables. Address
, however, will correspond to a set of columns within the Contact
Here is the relational schema:
Notice that each table has an ID
column. This column represents the unique row id (object id) for each row (object). Notice also that the PhoneNumber
table contains a Contact
column. This column contains the ID
of the parent Contact
We will develop in an object-oriented fashion. We will build the class from the object model. Caché will automatically project these class definitions to their relational representations.