What is wrong with this DB Diagram? [closed]

by

Your fact table should contain foreign keys to the dimensions. I see only primary keys

More Related Contents:

  1. How to use GROUP BY to concatenate strings in SQL Server?
  2. SQL, Auxiliary table of numbers
  3. ListAGG in SQLSERVER
  4. DateTime2 vs DateTime in SQL Server
  5. SET versus SELECT when assigning variables?
  6. Is it possible to for SQL Output clause to return a column not being inserted?
  7. Generate Dates between date ranges
  8. How to print VARCHAR(MAX) using Print Statement?
  9. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  10. Query error with ambiguous column name in SQL
  11. Why (and how) to split column using master..spt_values?
  12. How would you implement sequences in Microsoft SQL Server?
  13. What does =* mean?
  14. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  15. SSIS Package not wanting to fetch metadata of temporary table
  16. SQL Select Upcoming Birthdays
  17. SQL GROUP BY CASE statement with aggregate function
  18. How can I include null values in a MIN or MAX?
  19. Favourite performance tuning tricks [closed]
  20. Query a database based on result of query from another database
  21. How to delete the top 1000 rows from a table using Sql Server 2008?
  22. CHECK CONSTRAINT on multiple columns
  23. INSERT VALUES WHERE NOT EXISTS
  24. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  25. SQL count consecutive days
  26. Inner Joining three tables
  27. Cumulative Total in MS Sql server [duplicate]
  28. What does ON [PRIMARY] mean?
  29. Export table data from one SQL Server to another
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment