O'Reilly logo

Designing a Data Warehouse: Supporting Customer Relationship Management by Chris Todman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C. Logical Model for the Wine Club

In this appendix we display the relational logical schema. The purpose of this is to show how the components fit together and especially to show the use of existence attributes. The domains have been omitted.

Relation Customer
Customer_Code
Customer_Name
Hobby_Code
Date_Joined
Primary Key (Customer_Code)
Foreign Key (Hobby_Code references Hobby.Hobby_Code)
 
Relation Customer Exist
Customer_Code
Customer_Exist_Start
Customer_Exist_End
Primary Key (Customer_Code, Customer_Exist_Start)
Foreign Key (Customer_Code references Customer.Customer_Code)
 
Relation Customer Address Exist
Customer_Code
Customer_Address_Exist_Start
Customer_Address_Exist_End
Customer_Address
Primary Key (Customer_Code, Customer_Address_Exist_Start) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required