Absolute Beginner’s Guide to Databases

Automatically Generate the Database from the TEB Model

In Chapter 3, “An Introduction to Database Design,” you were introduced to the Visio Create Database Wizard. This wizard reads a Visio database entity relationship diagram and either adds the tables to an existing database or creates a new database. For details on how this Visio feature works, take a few moments and return to Chapter 3. The following steps will be a brief review of how to use the wizard.

After you have opened the TEB Database model in Visio, from the Tools menu, choose Database Design\Create Database Wizard. Figure 5.2 illustrates the wizard dialog box.

Figure 5.2. The opening screen of the Create Database Wizard dialog box.

Figure 5.3 illustrates Step 2 of the wizard ...