Teach Yourself Visual Studio® .NET 2003 in 21 Days [Electronic resources] نسخه متنی

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.