Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have a look at this pdf
why? your model works and you only have 1 syn key
Hi,
You can remove syn Key by using concept of Composite Key
or Rename field which is causing for Synthetic Key.
Regards
Hi,
Either change the name of the field Date in calendar.
Also check our primary key, which one you need as a primary key and which tables you need to associate.
Thanks and regards
Khushboo
Hi,
Better create a link table with all the common fields in all the table.
Before asking this question it is important to understand the meanings of the fields in the key and how they are likely to be used. Here the date field reflects 2 distinct dates - a sales date and a purchase date, and the sales and purchases are linked via the product key.
Have a look at this article on multiple date fields - you may land up with a more useful final model.
Apart from that, I agree with Massimo - there is no real need to remove this key.
Thanks Guys
Hi,
if u have got help from any of the answers u mark it as helpful or correct