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) ... |
Get Designing a Data Warehouse: Supporting Customer Relationship Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.