2.4 Designing the Database Schema
If you already have the database tables for USERS, PRODUCTS, and EXPERTISE_AREAS that store information about users with a technician role and the expertise they have for particular products, you can begin working with them immediately. Seeing them in a data diagram can help you understand whether the schema might require any changes to support the new use case.
After creating a named connection in the Connection Navigator to browse your database schema objects, you can see your existing tables under a Tables folder. Using the New Gallery, you can create a new database diagram, select the USERS, PRODUCTS, and EXPERTISE_AREAS tables from the Connection Navigator, and drop them onto the diagram. Figure 2-5 shows what the database diagram would look like.
Of course, if the tables didn't already exist, you could use the same diagrammer to design them and generate the DDL scripts to create the tables from scratch.
