How I do ER diagrams

Smud

Member
Just thought I'd share ....

Run the code "makexmlschema.p" to build the code to extract xml table details, run the program "sports.p" to create the xml files, open up Micro$oft Access and import the tables you want to document (the import adds a "row" to the end of the table name, just rename the table). Build the relationships and print off a PDF. Its not complete (or 100% correct) but you get the idea!
 

Attachments

  • makexmlschema.p
    517 bytes · Views: 11
  • mySportsDb.pdf
    133.4 KB · Views: 17
  • sports.p
    3.5 KB · Views: 9
Top