I am trying to design a database.I have 2 tables.The Events table and topic table.The scenario is as follows:
Table Name Column Name Datatype Primary Key Foreign Key
Event Event_ID INTEGER Yes Yes
In the event table the Event_ID is a FK to the PK Event_ID in Topic Table.But when using DB Designer I select 1:n (non-Identifying) relation tool and click on event table first and link it to topic table.I am getting a new column Topic_ID which is another PK in Topic Table.As per the design the Topic_ID column is not to be present in the Event Table.
I want only the Event_ID column to be linked between the Topic and Event table.