Multiple Fact Tables

  • Please assist? I would like to do a data model of the tables here:

    Any idea how i would go about to break this down and build a decent data model/links to tables?

  • Simple solution here, copy the text of the whole section, paste into a good text/code editor (notepad++, vim etc.) and create a ddl and dml for the tables. Then use a diagram editor of your choice (dia, yEd, Visio etc.) to populate a ERD for the tables. Alternatively, run the scripts in an SQL Database and use the built in diagram tool.


    Obviously there is some find and replace and such work involved but that should not be an obstacle.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply