I currently have the following class diagram. I am mapping the class diagram into a table design for a relational database. I have so far created the SQL tables for passenger, train, Station and also created a table in between to remove the "many to many" relationship. I have done this by taking the primary key from passenger (name) and the primary key from train (trainNumber, departureDate). I am confused however, do I create one intermediate table for TrainStation to remove the many to many, or do I need to create 2 intermediate tables because I have 2 associations?
Also, with the unary relationship, what would I reference?
This post has been edited by James1992: 10 May 2013 - 03:48 AM