Some additional notes for Assignment 2

1. If you are moving databases between different team members you may need to execute the following command against the database after attaching it in order to be able to view the database diagram. In a query window with the correct database in the drop down window of the object explorer panel enter:

sp_changedbowner 'sa'

and execute.

2.  Remember to define all your FKeys BEFORE entering data or you may get referential integrity errors which will be hard to find and correct when trying to save these definitions subsequently via your database diagram changes

3. If your database attaches in a Read Only mode try launching Management Studio with right mouse Run as Administrator

4. When entering data that involves 2 way or recursive relationships leave the FK as NULL on the first pass and go back and complete the entries when all parents for such relationships have been entered successfully

5. When deleting a feature from an Erwin diagram make sure you answer yes to the pop up question "do you also want them deleted from the model" else while not visible it may continue to influence  features of your diagram. If you suspect a problem you can always check the entries under the Model Explorer (to the left) to see if all entries are correct.