Sams Teach Yourself .Net in 21 Days

By Jason Beres

• Table of Contents
  • Copyright
  • About the Author
  • About the Technical Editor
  • Acknowledgments
  • We Want to Hear from You
  • Introduction
  • Week 1: At a Glance
  • Day 1. Introduction to the Microsoft .NET Framework
  • Day 2. Introduction to Visual Studio .NET
  • Day 3. Writing Windows Forms Applications
  • Day 4. Deploying Windows Forms Applications
  • Day 5. Writing ASP.NET Applications
  • Day 6. Deploying ASP.NET Applications
  • Day 7. Exceptions, Debugging, and Tracing
  • Week 1. In Review
  • Week 2: At a Glance
  • Day 8. Core Language Concepts in Visual Basic .NET and C#
  • Day 9. Using Namespaces in .NET
  • Day 10. Accessing Data with ADO.NET
  • Day 11. Understanding Visual Database Tools
  • Day 12. Accessing XML in .NET
  • Day 13. XML Web Services in .NET
  • Day 14. Components and .NET
  • Week 2. In Review
  • Week 3: At a Glance
  • Day 15. Writing International Applications
  • Day 16. Using Macros in Visual Studio .NET
  • Day 17. Automating Visual Studio .NET
  • Day 18. Using Crystal Reports
  • Day 19. Understanding Microsoft Application Center Test
  • Day 20. Using Visual SourceSafe
  • Day 21. Object Role Modeling with Visio
    • Introducing Object Role Modeling
    • Using Visio to Create an ORM Model
    • Adding ORM Facts to the Data Model
    • Creating a Database Diagram from the Conceptual Model
    • Summary
    • Q&A
    • Quiz
    • Exercises
  • Week 3. In Review

Exercises

1. Using the original ORM model that you created, add a Manufacturer role that has an inverse relationship with the Products role.

   The question you should use is

   Manufacturers create Products
   

   The inverse relationship is

   Products are created by Manufacturers
   

   Add a few value references for the Manufacturer role, such as ManufacturerName, ManufacturerCity, and so on. You should also add an entity reference called ManufacturerID for the Manufacturer object.

   After you've done that, re-create the database diagram and re-create the ORM_Test database in SQL Server.

2. In Visio, use the Reverse Engineer option from the Database menu in a new Database Diagram project. Reverse-engineer the Northwind database in your MSDE database, and study how the database was created based on the conceptual model that was reverse-engineered.

Share This