MIT OpenCourseWare
  • OCW home
  • Course List
  • about OCW
  • Help
  • Feedback
  • Support MIT OCW

Tools

Microsoft® Visio® software is recommended for viewing the .vsd files in this section. Free Microsoft® Visio® viewer software can also be used to view the .vsd files.

Here are some tools for working with a SQL client and ER diagrams in Visio®.

SQL Client Tools Install (PDF)
This document outlines the installation of the SQL Server client tools, specifically the Enterprise Manager and the Query Analyzer.

Restoring a backed up MS SQL Server database (PDF)
Gives a walk-through of the steps required to restore a SQL server database from a backup file.

SQL Server/Client Install (PDF)
Find out how to install MSDE and the SQL Client tools.

ER Diagram for a Distributed Sensor Network (PDF)
A problem description for creating ER diagrams using Visio®.

ER Diagram sample solution in Visio® (VSD)
A sample solution of the above problem.