- Shopping Bag ( 0 items )
This book is for database designers and database administrators using Visio, which is the database component of Microsoft's Visual Studio .NET for Enterprise Architects suite, also included in MSDN subscriptions. This is the only guide to this product that tells DBAs how to get their job done. Although primarily focused on tool features, the book also provides an introduction to data modeling, and includes practical advice on managing database projects. The principal author was the program manager of VEA's database modeling solutions.
· Explains how to model databases with Microsoft® Visio for Enterprise Architects (VEA), focusing on tool features.
· Provides a platform-independent introduction to data modeling using both Object Role Modeling (ORM) and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects.
· Additional ORM models, course notes, and add-ins available online.
Audience: Data modelers, database modelers, and DBAs working with Visual Studio .NET for Enterprise Architects and subscribers to Microsoft Developer Network (MSDN); upper division undergraduate and graduate students in Computer Science and Information Science; professional courses in database modeling, business rules, Microsoft course in Visual Studio .NET and SQL Server.
|Pt. 1||Overview of Database Modeling and the Database Modeling Tool|
|Pt. 2||The Conceptual Modeling Solution (ORM)|
|4||Object Types, Predicates, and Basic Constraints||65|
|6||Configuring, Manipulating, and Reusing ORM Models||121|
|7||Mapping ORM Models to Logical Database Models||133|
|8||Reverse Engineering and Importing to ORM||165|
|9||Conceptual Model Reports||177|
|Pt. 3||The Logical Modeling Solution (ER and Relational)|
|10||Creating a Basic Logical Database Model||203|
|11||Generating a Physical Database Schema||231|
|12||Editing Logical Models: Intermediate Aspects||255|
|13||Editing Logical Models: Advanced Aspects||281|
|14||Reverse Engineering Physical Schemas to Logical Models||297|
|15||Logical Database Model Reports||307|
|Pt. 4||Managing Database Projects|
|16||Change Propagation and Round-Trip Engineering||329|
|17||Other Features and Best Practices||361|
|Glossary and ORM Notation||389|