95
Chapter 5: SQL Server Management and Development Tools
5
Chapter 7, “Relational Database Design and Creating the Physical Database,” covers the logical design
of tables and columns. The realities of implementing the logical design, and how to script tables using
DDL, are discussed in Chapter 2, “Data Architecture.”Building Database Diagrams
The Database Diagram tool takes the Table Designer up a notch by adding custom table
design views (see Figure 5-7) and a multitable view of the foreign-key relationships. The
Database Diagram tool has its own node under each database. Each database may contain
multiple diagrams, which makes working with large databases easier because each module,
or schema, of the database may be represented by a diagram.FIGURE 5-7
The AdventureWorks database relationships viewed with the Database Diagram tool.Sometimes the Database Diagram tool is useful to visually explore the schemas of large
databases. Unfortunately, the Database Diagram tool suffers from a few clumsy issues.■ (^) It makes sense to create a separate diagram for each section of a large database,
and databases can be organized by schemas (as AdventureWorks is).
c05 July 23, 2012 11:44 AM V1
c05.indd 95c05.indd 95 7/30/2012 4:14:47 PM7/30/2012 4:14:47 PM
http://www.it-ebooks.info