- #1
- 7,309
- 11,118
Hi,
I am playing around with the large(ish) database Adventureworks2014. A couple of issues , please:
1) How do we go about finding the keys when joining , say, 5 tables at a time? Does one do a database diagram using those tables?
2) I am having trying to set up the diagrams for these joins. Problem is I am having trouble finding the tables I need when designing the diagrams; tables are not listed in the dialog box used to choose for the diagram to make ( please see dialog box in center) . How do I load missing tables into the list, so I can use them for diagrams? I guess this is more of an OLAP issue than an OLTP Thanks.:
I am playing around with the large(ish) database Adventureworks2014. A couple of issues , please:
1) How do we go about finding the keys when joining , say, 5 tables at a time? Does one do a database diagram using those tables?
2) I am having trying to set up the diagrams for these joins. Problem is I am having trouble finding the tables I need when designing the diagrams; tables are not listed in the dialog box used to choose for the diagram to make ( please see dialog box in center) . How do I load missing tables into the list, so I can use them for diagrams? I guess this is more of an OLAP issue than an OLTP Thanks.:
Attachments
Last edited: